4.7
stars
2,663 ratings

Google Cloud Training

44,507 already enrolled

Offered By

Google Cloud

About this Course

46,771 recent views

The two key components of any data pipeline are data lakes and warehouses. This course highlights use-cases for each type of storage and dives into the available data lake and warehouse solutions on Google Cloud in technical detail. Also, this course describes the role of a data engineer, the benefits of a successful data pipeline to business operations, and examines why data engineering should be done in a cloud environment.
This is the first course of the Data Engineering on Google Cloud series. After completing this course, enroll in the Building Batch Data Pipelines on Google Cloud course.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Intermediate Level

Approx. 7 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

What you will learn

Differentiate between data lakes and data warehouses.
Explore use-cases for each type of storage and the available data lake and warehouse solutions on Google Cloud.
Discuss the role of a data engineer and the benefits of a successful data pipeline to business operations.
Examine why data engineering should be done in a cloud environment.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Intermediate Level

Approx. 7 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Instructor

Instructor rating

4.63/5 (502 Ratings)

Google Cloud Training

1,885,492 Learners

1,023 Courses

Offered by

Google Cloud

We help millions of organizations empower their employees, serve their customers, and build what’s next for their businesses with innovative technology created in—and for—the cloud. Our products are engineered for security, reliability, and scalability, running the full stack from infrastructure to applications to devices and hardware. Our teams are dedicated to helping customers apply our technologies to create success.

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Syllabus - What you will learn from this course

Content Rating83%(3,181 ratings)

Week

Week 1

4 minutes to complete

Introduction

4 minutes to complete

2 videos (Total 4 min)

2 hours to complete

Introduction to Data Engineering

2 hours to complete

14 videos (Total 41 min)

14 videos

Module introduction1m

The role of a data engineer4m

Data engineering challenges5m

Introduction to BigQuery2m

Data lakes and data warehouses4m

Transactional databases versus data warehouses4m

Partner effectively with other data teams5m

Manage data access and governance1m

Demo: Finding PII in your dataset with the DLP API1m

Build production-ready pipelines2m

Google Cloud customer case study1m

Recap1m

Lab Intro: Using BigQuery to do Analysis13s

Getting Started with Google Cloud and Qwiklabs4m

1 practice exercise

Introduction to Data Engineering4m

2 hours to complete

Building a Data Lake

2 hours to complete

8 videos (Total 42 min)

Week

Week 2

4 hours to complete

Building a data warehouse

4 hours to complete

16 videos (Total 91 min)

16 videos

Module Introduction1m

The modern data warehouse3m

Introduction to BigQuery6m

Demo: Querying TB of data in seconds7m

Get started with BigQuery11m

Load data into BigQuery11m

Lab Intro: Loading Data into BigQuery25s

Explore schemas27s

Demo: Exploring Schemas10m

Schema design3m

Nested and repeated fields9m

Demo: Nested and repeated fields15m

Design the optimal schema for BigQuery1m

Lab Intro: Working with JSON and Array data in BigQuery17s

Optimize with partitioning and clustering6m

Review2m

1 practice exercise

Building a Data Warehouse4m

2 minutes to complete

Summary

2 minutes to complete

1 video (Total 2 min)

Reviews

4.7

332 reviews

5 stars
72.71%
4 stars
22.89%
3 stars
3.30%
2 stars
0.75%
1 star
0.33%

TOP REVIEWS FROM MODERNIZING DATA LAKES AND DATA WAREHOUSES WITH GOOGLE CLOUD

by MPMay 17, 2020

Great course providing the fundamental concepts around Data Lakes, Data Warehouses, Schemas, ETL/ELT/EL, and specific Google GCP Technologies that help implement these concepts

by BAFeb 8, 2020

The course offers a nice description of what modern DWH means, which are the differences between classic DWH and cloud DWH. You have the chance to work with the new cloud concept on GCP.

by TGFeb 4, 2020

Course material spends a little too much time promoting the benefits of GCP when it could be focusing on the technical aspects of using GCP

by LGApr 25, 2022

This is an excellent course to understand about Data Lakes and Data Warehouses, and how to implement them with GCP. It takes you from zero to a level where you can move confidently in GCP.

View all reviews

Frequently Asked Questions

Can I preview a course before enrolling?
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.
What will I get when I enroll?
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.
When will I receive my 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.
Why can’t I audit this course?
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.

Build employee skills, drive business results

Discover Coursera for Business

Modernizing Data Lakes and Data Warehouses with Google Cloud

About this Course

What you will learn