About this Course

99,847 recent views
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Intermediate Level
Approx. 9 hours to complete
English

Instructor

Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Intermediate Level
Approx. 9 hours to complete
English

Offered by

Placeholder

Google Cloud

Syllabus - What you will learn from this course

Content RatingThumbs Up86%(2,012 ratings)Info
Week
1

Week 1

7 minutes to complete

Introduction

7 minutes to complete
2 videos (Total 7 min)
2 videos
Getting Started with Google Cloud and Qwiklabs4m
2 hours to complete

Introduction to Data Engineering

2 hours to complete
13 videos (Total 55 min)
13 videos
Analyze data engineering challenges8m
Intro to BigQuery3m
Data Lakes and Data Warehouses5m
Demo: Federated Queries with BigQuery6m
Transactional Databases vs Data Warehouses4m
Partner effectively with other data teams6m
Manage data access and governance2m
Demo: Finding PII in your dataset with DLP API1m
Build production-ready pipelines2m
Review GCP customer case study3m
Recap1m
Lab Intro: Using BigQuery to do Analysis17s
1 practice exercise
Introduction to Data Engineering30m
2 hours to complete

Building a Data Lake

2 hours to complete
10 videos (Total 58 min)
10 videos
Data Storage and ETL options on GCP4m
Building a Data Lake using Cloud Storage10m
Demo: Optimizing cost with Google Cloud Storage classes and Cloud Functions7m
Securing Cloud Storage5m
Storing All Sorts of Data Types5m
Demo: Running federated queries on Parquet and ORC files in BigQuery4m
Storing Relational Data in the Cloud1m
Cloud SQL as a relational Data Lake7m
Lab: Loading Taxi Data into Cloud SQL27s
1 practice exercise
Building a Data Lake4m
Week
2

Week 2

4 hours to complete

Building a data warehouse

4 hours to complete
20 videos (Total 112 min), 1 reading, 3 quizzes
20 videos
Intro to BigQuery1m
Demo: Querying TB of Data in seconds7m
Getting Started9m
Loading Data11m
Lab Intro: Loading Data into BigQuery21s
Exploring Schemas24s
Demo: Exploring Schemas10m
Schema Design3m
Nested and Repeated Fields8m
Demo: Nested and Repeated Fields15m
Lab Intro: Working with JSON and Array Data in BigQuery13s
Optimizing with Partitioning and Clustering5m
Demo: Creating Partitioned Tables7m
Demo: Partitioning and Clustering6m
Preview: Transforming Batch and Streaming Data2m
Recap1m
Monitoring BigQuery usage and reservations5m
Intro to BigQuery System Table Reports6m
Demo: BigQuery System Tables with Data Studio7m
1 reading
BigQuery Pricing 10m
1 practice exercise
Building a Data Warehouse4m
2 minutes to complete

Summary

2 minutes to complete
1 video (Total 2 min)
1 video

Reviews

TOP REVIEWS FROM MODERNIZING DATA LAKES AND DATA WAREHOUSES WITH GCP

View all reviews

About the Data Engineering with Google Cloud Professional Certificate

Data Engineering with Google Cloud

Frequently Asked Questions

More questions? Visit the Learner Help Center.