Passer au contenu principal

Accueil Google Cloud

Cours

Build Data Lakes and Data Warehouses on Google Cloud

IntermédiaireNiveau de compétence

Mis à jour 05/2026

Build modern data lakehouses on Google Cloud using BigQuery, Cloud Storage, Apache Iceberg, BigLake, federated queries, and data governance tools.

Commencer Le Cours Gratuitement

Google CloudCloud

3 h 48 min

52 Exercices

2,800 XP

Certificat de réussite

Apprécié par les Utilisateur dans des milliers d’entreprises

Former une équipe ?

Essayez pour les entreprises

Description du cours

Learn to build modern data lakehouses on Google Cloud. This course covers data lake and data warehouse architectures, the lakehouse approach with Cloud Storage and BigQuery, Apache Iceberg open table format, BigLake, federated queries, partitioning, clustering, data governance, and machine learning on the lakehouse.

Prérequis

Il n’y a aucun prérequis pour ce cours

1

Course introduction

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

Course Introduction

Commencer Le Chapitre

2

Introduction to Modern Data Engineering on Google Cloud

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

Module 1: Introduction to modern data engineering on Google Cloud

The classics: Data lakes and data warehouses

The modern approach: Data lakehouse

Choosing the right architecture

Quiz Question 1

Quiz Question 2

Quiz Question 3

Quiz Question 4

Commencer Le Chapitre

3

Building a Data Lakehouse with Cloud Storage, Open Formats, and BigQuery

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.

Module 2: Building a data lakehouse with Cloud Storage, open formats, and BigQuery

Building a data lake foundation

Introduction to Apache Iceberg open table format

BigQuery as the central processing engine

Combining operational data in AlloyDB

Combining operational and analytical data with federated queries

Real world use case

Quiz Question 1

Quiz Question 2

Quiz Question 3

Quiz Question 4

Federated query with BigQuery

Commencer Le Chapitre

4

Modernizing Data Warehouses with BigQuery and BigLake

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

Module 3: Modernizing data warehouses with BigQuery and BigLake

BigQuery fundamentals

Partitioning and clustering in BigQuery

Introducing BigLake and external tables

Querying external data and Iceberg tables

Quiz Question 1

Quiz Question 2

Quiz Question 3

Quiz Question 4

Quiz Question 5

Quiz Question 6

Quiz Question 7

Quiz Question 8

Commencer Le Chapitre

5

Advanced Lakehouse Patterns and Data Governance

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

Module 4: Advanced lakehouse patterns and data governance

Data governance and security in a unified platform

Demo: Data Loss Prevention

Analytics and machine learning on the lakehouse

Real-world lakehouse architectures and migration strategies

Quiz Question 1

Quiz Question 2

Quiz Question 3

Quiz Question 4

Quiz Question 5

Quiz Question 6

Quiz Question 7

Quiz Question 8

Commencer Le Chapitre

6

Labs and Best Practices

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

Module 5: Labs and best practices

Getting Started with BigQuery ML

Vector search with BigQuery

Review and best practices

Commencer Le Chapitre

7

Course Summary

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

Summary and next steps

Commencer Le Chapitre

Build Data Lakes and Data Warehouses on Google Cloud

Cours
terminé

Obtenez un certificat de réussite

Ajoutez cette certification à votre profil LinkedIn, à votre CV ou à votre curriculum vitae
Partagez-le sur les réseaux sociaux et dans votre évaluation de performanceInscrivez-vous Maintenant

Rejoignez plus de 19 millions d’Utilisateurs et commencez Build Data Lakes and Data Warehouses on Google Cloud dès aujourd’hui !

Apprenez où que vous soyez avec l'application DataCamp

Progressez où que vous soyez grâce à nos cours conçus pour mobile et à nos défis quotidiens de 5 minutes.