July Release Confetti
150+ New Hands-on Training in Aws, Linux, Azure
Red Hat, Devops, and More
Learn More

Google Cloud Certified Professional Data Engineer

Training Architect
course instructor image
Matthew Ulasien
I am a technology enthusiast who specializes in helping people and making businesses run better through modern tech, as well as a fan of all things Google. Before starting with Linux Academy, I was a cloud consultant for small businesses, helping them future-proof outdated infrastructure with modern cloud solutions and transform the way they work. I enjoy spending time with my family, playing games (when I actually have free time), and keeping up with modern technology trends.

Getting Started

Course and Exam Introduction

Welcome to the Google Cloud Professional Data Engineer Course

00:06:16

About the Training Architect

00:00:41

Intro to the Data Dossier - Interactive Study Guide

00:04:53

Course and Exam Overview

00:05:06

What is a Data Engineer

00:03:19

Case Studies

Case Study Overview

00:02:25

Flowlogistic Case Study

00:13:53

MJTelco Case Study

00:08:24

Foundational Concepts

Data Lifecycle

00:11:41

Batch and Streaming Data

00:05:28

Cloud Storage as Staging Ground

00:07:16

Database Types

00:07:21

Practice Exam: Google Cloud Data Engineer - Foundational Concepts

00:30:00

Managed Databases

Cloud SQL

Choosing a Managed Database

00:07:15

Cloud SQL Basics

00:05:07

Cloud SQL Hands On

00:12:46

Importing Data

00:12:10

SQL Query Best Practices

00:02:48

Datastore

Datastore Overview

00:09:21

Data Organization

00:16:03

Queries and Indexing

00:11:29

Data Consistency

00:06:18

Bigtable

Bigtable Overview

00:07:44

Instance Configuration

00:18:11

Data Organization

00:05:28

Schema Design

00:07:14

Cloud Spanner

Cloud Spanner Overview

00:11:17

Data Organization and Schema

00:07:12

Hands On and Viewing Examples

00:11:46

QUIZ: Managed Databases on Google Cloud

00:30:00

Data Engineering Architecture

Real Time Messaging with Cloud Pub/Sub

Streaming Data Challenges

00:08:24

Cloud Pub/Sub Overview

00:12:29

Pub/Sub Hands On

00:18:24

Data Pipelines with Cloud Dataflow

Data Processing Pipelines

00:05:24

Cloud Dataflow Overview

00:10:09

Key Concepts

00:09:35

Template Hands On

00:11:08

Streaming Ingest Pipeline Hands On

00:20:03

Dataproc

Dataproc Overview

00:10:48

Configure Dataproc Cluster and Submit Job – Part 1

00:15:35

Configure Dataproc Cluster and Submit Job – Part 2

00:14:35

Migrating and Optimizing for Google Cloud

00:09:49

QUIZ: Data Ingest and Processing

00:30:00

Analyzing Data and Enabling Machine Learning

BigQuery

BigQuery Overview

00:14:43

Interacting with BigQuery

00:22:10

Load and Export Data

00:19:03

Optimize for Performance and Costs

00:15:29

Streaming Insert Example

00:08:38

QUIZ: BIGQUERY

00:30:00

Machine Learning

What is Machine Learning?

00:14:47

Working with Neural Networks

00:15:08

Cloud Machine Learning Engine (ML Engine)

ML Engine Overview

00:21:24

ML Engine Hands On Part 1

00:23:11

ML Engine Hands On Part 2

00:11:04

Pretrained Machine Learning API's

Pre-trained ML API's

00:12:31

Vision API Demo

00:13:28

QUIZ: MACHINE LEARNING ON GOOGLE CLOUD

00:30:00

Datalab

Datalab Overview

00:08:45

Datalab Demo

00:17:48

Data Visualization

Cleaning Your Data with Dataprep

What is Dataprep?

00:08:58

Dataprep Demo Part 1

00:14:15

Dataprep Demo Part 2

00:16:32

Dataprep Demo Part 3

00:11:48

Building Data Visualizations with Data Studio

Data Studio Introduction

00:09:31

Data Studio Demo

00:28:19

QUIZ: DATALAB/DATAPREP/DATA STUDIO

00:30:00

Course Conclusion

Additional Hands On and Practice Resources

00:04:43

Next Steps

00:03:41

Practice Exam: Data Engineer - Final Exam

02:00:00

Details

The Google Cloud Professional Data Engineer is able to harness the power of Google's big data capabilities and make data-driven decisions by collecting, transforming, and visualizing data. Through designing, building, maintaining, and troubleshooting data processing systems with a particular emphasis on the security, reliability, fault-tolerance, scalability, fidelity, and efficiency of such systems, a Google Cloud data engineer is able to put these systems to work.


This course will prepare you for the Google Cloud Professional Data Engineer exam by diving into all of Google Cloud's data services. With interactive demonstrations and an emphasis on hands-on work, you will learn how to master each of Google's big data and machine learning services and become a certified data engineer on Google Cloud.


Study Guides

Data Dossier Link

https://www.lucidchart.com/documents/view/0ca44a63-4ea4-4d78-8367-2465512d21be/0

Instructor Deck

Community

Looking For Team Training?

Learn More