About this Course

109,369 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. 12 hours to complete

Suggested: 22 hours/week...

English

Subtitles: English

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. 12 hours to complete

Suggested: 22 hours/week...

English

Subtitles: English

Instructor

Offered by

Google Cloud logo

Google Cloud

Syllabus - What you will learn from this course

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
17 videos (Total 93 min)
17 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
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

  • Yes, you can preview the first video and view the syllabus before you enroll. You must purchase the course to access content not included in the preview.

  • If you decide to enroll in the course before the session start date, you will have access to all of the lecture videos and readings for the course. You’ll be able to submit assignments once the session starts.

  • Once you enroll and your session begins, you will have access to all videos and other resources, including reading items and the course discussion forum. You’ll be able to view and submit practice assessments, and complete required graded assignments to earn a grade and a Course Certificate.

  • If you complete the course successfully, your electronic Course Certificate will be added to your Accomplishments page - from there, you can print your Course Certificate or add it to your LinkedIn profile.

  • This course is one of a few offered on Coursera that are currently available only to learners who have paid or received financial aid, when available.

More questions? Visit the Learner Help Center.