About this Course

93,396 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 Up87%(1,825 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

Frequently Asked Questions

More questions? Visit the Learner Help Center.