Google Professional Data Engineer Exam Preparation

DifficultyIntermediate
AVG Duration20h
Students6061
Ratings
4.6/5
starstarstarstarstar-half
Content
17167

Description

This learning path is designed to help you prepare for the Google Certified Professional Data Engineer Exam. Even if you don't plan to take the exam, these courses will help you gain a solid understanding of the various data processing components of the Google Cloud Platform.

At the heart of Google’s big data services is BigQuery, a managed data warehouse in the cloud. The first three courses will show you how to load and query data in BigQuery, optimize BigQuery’s performance, and visualize your data.

The next three courses will show you how to process your data. First, you will use Cloud Machine Learning Engine to train neural networks to perform predictive analytics. Next, you’ll use Cloud Dataflow and Cloud Dataproc to build data processing pipelines that transform and summarize your data using Apache Beam, Hadoop, and Spark.

The final course will introduce you to Bigtable, Google’s revolutionary NoSQL database. It will show you how to take advantage of Bigtable’s high performance for big data applications.

All of these courses include hands-on demos you can do yourself. Then you can test what you’ve learned by taking the practice exam.

Learning Objectives

  • Designing data processing systems
  • Building and operationalizing data processing systems
  • Operationalizing machine learning models
  • Ensuring solution quality

Prerequisites

  • Basic database knowledge

Intended Audience

  • Data professionals
  • People studying for the Google Professional Data Engineer exam

Feedback

If you have thoughts or suggestions for this learning path, please contact Cloud Academy at support@cloudacademy.com.

Certificate

Your certificate for this learning path

Training Content

1
Course - Beginner - 46m
FREE
Overview of Google Cloud Platform
In this course, you'll learn about GCP services such as compute, storage, and networking, and how to create virtual machines and web apps using the Google Cloud Console and gcloud CLI.
2
Exam - 20m
Knowledge Check: Overview of Google Cloud Platform
Knowledge Check: Overview of Google Cloud Platform
3
Course - Intermediate - 16m
Introduction to Google Cloud Data Loss Prevention
This course is a short introduction to Google Cloud Data Loss Prevention, which is a service that finds and de-identifies sensitive data, such as birthdates and credit card numbers.
4
Hands-on Lab - Intermediate - 45m
Inspecting and De-Identifying Data With Google Cloud Data Loss Prevention
In this lab, you will inspect data stored in Cloud Storage and understand the sensitive information therein.
5
Course - Intermediate - 1h 48m
Google Cloud Platform: Systems Operations
This course covers Google Cloud systems operations, providing insight and practical information across the complete set of GCP features.
6
Exam - 25m
Knowledge Check: Google Cloud Platform - Systems Operations
Knowledge Check: Google Cloud Platform - Systems Operations
7
Course - Intermediate - 1h 8m
Designing a Google Cloud Infrastructure
This course uses a case study to show how to apply the design principles of security, compliance, and disaster recovery to meet real-world requirements.
8
Exam - 25m
Knowledge Check: Designing a Google Cloud Infrastructure
Knowledge Check: Designing a Google Cloud Infrastructure
9
Hands-on Lab - Intermediate - 45m
Granting Access to Google Cloud Storage Objects with Signed URLs
Use the gcloud CLI in Google Cloud Shell to create signed URLs to grant anyone access to objects stored in Google Cloud Storage for a set duration in this Lab.
10
Hands-on Lab - Intermediate - 1h 15m
Run SQL Queries and Analyze Data with Google Cloud SQL
In this lab, you will create two tables in a SQL PostgreSQL database, perform operations on them, monitor the resources usage and test that the atomicity property is respected by the database.
11
Course - Intermediate - 11m
Managing Google Cloud Storage
In this course, we’ll show you how to upload data to your Google Cloud Storage buckets, transfer data from another provider or from your on-premises environment, and implement object lifecycle management.
12
Course - Beginner - 36m
FREE
Introduction to Google BigQuery
Learn how to load data into BigQuery, run queries using standard SQL, and export data from BigQuery with this hands-on course.
13
Hands-on Lab - Beginner - 35m
Structure and Analyze Data with Google BigQuery
This Lab will show you the basic concepts of BigQuery and will allow you to handle data and query them in a real GCP environment.
14
Course - Intermediate - 37m
FREE
Optimizing Google BigQuery
Learn how to make BigQuery faster, cheaper, and more secure with this hands-on course.
15
Course - Intermediate - 37m
Visualizing BigQuery Data with Google Data Studio
With this course, you'll learn how to visualize BigQuery Data with Google Data Studio and create BigQuery reports.
16
Course - Beginner - 33m
Introduction to Machine Learning on GCP
This course introduces machine learning on Google Cloud Platform.
17
Course - Intermediate - 57m
Building a Machine Learning Model
This course will demonstrate how to build and train your own custom machine learning model from scratch.
18
Course - Beginner - 38m
Introduction to Google Vertex AI
In this course, we will introduce Google Vertex AI.
19
Hands-on Lab - Intermediate - 45m
Analyze and Retrieve Information from Text Using Google Cloud Natural Language
20
Course - Intermediate - 42m
Introduction to Google Cloud Dataprep
In this course, you will learn how you can use Cloud Dataprep to easily explore, clean, and prepare your data.
21
Course - Intermediate - 1h 9m
Introduction to Google Cloud Dataflow
In this course, you'll learn how to write data processing programs using Apache Beam and run them using Cloud Dataflow, as well as learning how to run both batch and streaming jobs.
22
Course - Intermediate - 31m
FREE
Introduction to Google Cloud Pub/Sub
In this course, you will learn how to use Google Cloud Pub/Sub to create a reliable, asynchronous, messaging service for any scale.
23
Exam - 25m
Knowledge Check: Introduction to Google Cloud Pub/Sub
Knowledge Check: Introduction to Google Cloud Pub/Sub
24
Course - Advanced - 45m
FREE
Google Cloud Pub/Sub - Advanced Topics
This course will demonstrate some of the more advanced options that are available in Google Cloud Pub/Sub.
25
Exam - 25m
Knowledge Check: Google Cloud Pub/Sub - Advanced Topics
Knowledge Check: Google Cloud Pub/Sub - Advanced Topics
26
Hands-on Lab - Intermediate - 1h
Deploy a Message Queuing Solution With Google Cloud Pub/Sub
Google Cloud Pub/Sub is a message queuing service that allows you to deploy topics and attach subscriptions to them. Once a message is sent to the topic, it will send the message to all the attached subscriptions.
27
Course - Intermediate - 49m
Introduction to Google Cloud Dataproc
In this course, you'll learn how to run Hadoop and Spark jobs on GCP.
28
Course - Intermediate - 48m
Introduction to Google Cloud Bigtable
In this course, you'll learn which of your applications could make use of Bigtable and how to take advantage of its high performance.
29
Hands-on Lab - Beginner - 55m
Managing a Redis Instance Using Google Cloud Memorystore
In this lab, you will create and manage a Redis instance by using Google Cloud Memorystore.
30
Resource - Intermediate - 2h 35m
Required Reading for Google Data Engineer Exam
31
Exam - 2h
Cert Prep: Google Cloud Platform Data Engineer
Cert Prep: Google Cloud Platform Data Engineer
About the Author
Students192820
Courses99
Learning paths169

Guy launched his first training website in 1995 and he's been helping people learn IT technologies ever since. He has been a sysadmin, instructor, sales engineer, IT manager, and entrepreneur. In his most recent venture, he founded and led a cloud-based training infrastructure company that provided virtual labs for some of the largest software vendors in the world. Guy’s passion is making complex technology easy to understand. His activities outside of work have included riding an elephant and skydiving (although not at the same time).