Module 1: Introduction to Data Engineering

• Explore the role of a data engineer.
• Analyze data engineering challenges.
• Intro to BigQuery.
• Data Lakes and Data Warehouses.
• Demo: Federated Queries with BigQuery.

Module 2: Building a Data Warehouse

• The modern data warehouse.
• Intro to BigQuery.
• Demo: Query TB+ of data in seconds.
• Getting Started.
• Loading Data.
• Video Demo: Querying Cloud SQL from BigQuery.
• Lab: Loading Data into BigQuery.

Module 3: Introduction to Building Batch Data Pipelines

• EL, ELT, ETL.
• Quality considerations.
• How to carry out operations in BigQuery.

Module 4: Serverless Data Processing with Cloud Dataflow

• Cloud Dataflow.
• Why customers value Dataflow.
• Dataflow Pipelines.
• Lab: A Simple Dataflow Pipeline (Python/Java).
• Lab: MapReduce in Dataflow (Python/Java).
• Lab: Side Inputs (Python/Java).
• Dataflow Templates.
• Dataflow SQL.

Tutorials

• Using BigQuery to load and transform the data. Use this approach to perform a one-time load of a small amount of data into BigQuery for analysis. You might also use this approach to prototype your dataset before you automate larger or multiple datasets.
• Using Dataflow to load, transform, and cleanse the data. Use this approach to load a larger amount of data, load data from multiple data sources, or to load data incrementally or automatically.