Data Warehousing for Partners: Data Warehouse Migration with BigQuery

In this course, you will receive technical training for Enterprise Data Warehouses solutions using BigQuery based on the best practices developed internally by Google’s technical sales and services organizations. The course will also provide guidance and training on key technical challenges that can arise when migrating existing Enterprise Data Warehouses and ETL pipelines to Google Cloud. You will get hands-on experience with real migration tasks, such as data migration, schema optimization, and SQL Query conversion and optimization. The course will also cover key aspects of ETL pipeline migration to Dataproc as well as using Pub/Sub, Dataflow, and Cloud Data Fusion, giving you hands-on experience using all of these tools for Data Warehouse ETL pipelines.

• Welcome to the Course
• This module will give you an overview of the course.
• Data Warehouse Solutions on Google Cloud
• This module discusses the key elements of Google's Data Warehouse solution portfolio and strategy.
• BigQuery for Data Warehousing Professionals
• This module maps Enterprise Data Warehouse concepts and components to BigQuery and Google data services.
• Migrating to BigQuery
• This module identifies best practices for migrating data warehouses to BigQuery and demonstrate key skills required to perform successful migration.
• Tools and Positioning
• This module explores the implementation of data load and transformation pipelines for a BigQuery Data Warehouse using Google data processing and integration services.
• Streaming Analytics
• This module explores how to implement a streaming analytics solution using Pub/Sub, Dataflow, and BigQuery.
• Introduction to Looker as a Data Platform
• This module demonstrates how to use Looker and LookML to generate reports and gain insights.
• BigQuery Extended Capabilities
• This module explores the Geographic Information Systems (GIS), GIS Visualization, and machine learning enhancements to BigQuery.
• Course Resources
• PDF links to all modules