Course Overview
This deep dive technical course provides technical training for Enterprise Data Warehouses (EDW) solutions using BigQuery.
The course provides guidance and training on technical challenges that can arise when migrating existing EDW and ETL pipelines to Google Cloud. Learners are provided with practical experience with real migration tasks, such as data migration, schema optimization, and SQL Query conversion and optimization.
The course also covers key aspects of ETL pipeline migration to Dataproc and using Pub/Sub, Dataflow, and Cloud Data Fusion.
Who should attend
The core audience for this course is Google Cloud Partners with the following relevant job roles:
- Data Warehouse Deployment Engineers
- Data Warehouse Consultants
- Data Warehouse Architects
These roles, though not the core audience, may find the course relevant should they meet the requirements:
- Technical Project Leads
- Technical Project Managers
- Data / Business Analysts
Prerequisites
Required:
- Have completed the Data Engineering on Google Cloud training.
- Be a Google Cloud Certified Professional Data Engineer or have equivalent expertise in Data Engineering.
- Have access to Cloud Connect - Partners.
Recommended:
- Experience building data processing pipelines.
- Experience with Apache Beam and Apache Hadoop.
- Java or Python programming expertise.
Organizational requirements:
- The Cloud Partner organization must have implemented at least one Data Warehouse solution previously on any Data Warehouse platform.
Course Objectives
- Discuss key elements of Google Data Warehouse solution portfolio and strategy.
- Map Enterprise Data Warehouses concepts and components to BigQuery and Google data services.
- Identify best practices for migrating Data Warehouses to BigQuery and demonstrate key skills required to perform successful migrations.
- Implement data load and transformation pipelines for a BigQuery Data Warehouse using Google data processing and integration services.
- Implement a streaming analytics solution using Pub/Sub, Dataflow, and BigQuery.
- Use Looker and LookML to generate reports and gain insights.
- Explore the GIS, GIS Visualization, and Machine Learning enhancements to BigQuery.