Detailed Course Outline
Module 1: Understanding BigQuery Architecture
- Quick reminder of Teradata architecture
- Overview of BigQuery architecture
- Separation of compute and storage in BigQuery
- BigQuery Slots
- Workload management in BigQuery
Module 2: Creating Datasets and Tables in BigQuery
- Resource Hierarchy in Teradata
- Resource Hierarchy in BigQuery
- Creating resources in BigQuery
- Sharing resources in BigQuery
- Lab: Provisioning and Managing Resources in BigQuery
Module 3: Mapping Data Types from Teradata to BigQuery
- How data types map from Teradata to BigQuery
- Understand data types unique to BigQuery
Module 4: Schema Optimization and Mapping
- Schema definitions in BigQuery
- Partitioning in BigQuery
- Clustering in BigQuery
- Lab: Schema Migration to BigQuery
Module 5: SQL Translation from Teradata to BigQuery
- SELECT statements
- DML statements
- DDL statements
- UDFs and Procedures
- Lab: Writing SQL for BigQuery