Build Data Lakes and Data Warehouses on Google Cloud

This course is part of multiple programs.

Instructor: Google Cloud Training

Access provided by ASTRA NAVIGATION INC.

63,800 already enrolled

7 modules

Gain insight into a topic and learn the fundamentals.

2,915 reviews

Intermediate level

Some related experience required

Flexible schedule

1 week at 10 hours a week

Learn at your own pace

83%

Most learners liked this course

7 modules

Gain insight into a topic and learn the fundamentals.

2,915 reviews

Intermediate level

Some related experience required

Flexible schedule

1 week at 10 hours a week

Learn at your own pace

83%

Most learners liked this course

What you'll 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.

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

4 assignments

Taught in English

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

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is available as part of

When you enroll in this course, you'll also be asked to select a specific program.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 7 modules in this course

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.

Introduce the learner to the topics that will be covered in the course and the skills they will learn.

What's included

1 plugin

This module introduces the foundational concepts of data lakes and data warehouses, setting the stage for modern architectures on Google Cloud.

What's included

1 assignment4 plugins

This module details the concept of a lakehouse and introduces the Google Cloud products most commonly used to build a modern data lakehouse using open-source formats.

What's included

1 assignment1 app item8 plugins

1 assignment Total 8 minutes

Data lakehouse features and benefits 8 minutes

1 app item Total 45 minutes

Federated query with BigQuery and AlloyDB 45 minutes

8 plugins Total 120 minutes

Module 2: Building a data lakehouse with Cloud Storage, open formats, and BigQuery 15 minutes
Building a data lake foundation 15 minutes
Introduction to Apache Iceberg open table format 15 minutes
BigQuery as the central processing engine 15 minutes
Combining operational data in AlloyDB 15 minutes
Combining operational and analytical data with federated queries 15 minutes
Real world use case 15 minutes
Accessing and completing labs 15 minutes

This module explores BigQuery as the cornerstone of a modern data warehouse and introduces BigLake for unifying access across the data lake and warehouse.

What's included

1 assignment1 app item4 plugins

This module focuses on advanced architectural patterns for the lakehouse, including data processing, orchestration, and comprehensive data governance across BigQuery, Cloud Storage, and BigLake.

What's included

1 assignment5 plugins

1 assignment Total 16 minutes

Security and ML in the lakehouse 16 minutes

5 plugins Total 75 minutes

Module 4: Advanced lakehouse patterns and data governance 15 minutes
Data governance and security in a unified platform 15 minutes
Demo: Data Loss Prevention 15 minutes
Analytics and machine learning on the lakehouse 15 minutes
Real-world lakehouse architectures and migration strategies 15 minutes

This module provides labs to deepen skills in the tools and technologies used by a lakehouse on Google Cloud and an overview of best practices, common mistakes, and future trends

What's included

2 app items2 plugins

Summarize the architectural and operational capabilities of the BigQuery-centric data lakehouse, covering governance, advanced analytics, and machine learning

What's included

1 plugin

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Instructor ratings

(563 ratings)

Google Cloud Training

Google Cloud

2,064 Courses 3,939,703 learners

Offered by

Google Cloud

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

5 stars
73.21%
4 stars
22.35%
3 stars
3.15%
2 stars
0.72%
1 star
0.54%

Showing 3 of 2915

Reviewed on Jan 3, 2022

Great!!! Key to understand how to take advantage of the resources offered by the Google cloud to a modern way to build and process your data.

Reviewed on Apr 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.

Reviewed on Jul 19, 2020

This is a great course for people wishing to make a career in Data Engineering on the Google Cloud Platform. Highly recommended! Its simply superb!

View more reviews