Migrating Teradata Users to BigQuery (MTUBQ) - Lab Topology

Lab 1: Provisioning and Managing Resources in BigQuery

• Create datasets
• Create internal and external tables
• Control access to data
• Share data
• Monitor resource utilization

Lab 2: Schema Migration to BigQuery

• Understand data types in BigQuery
• Define schemas in BigQuery
• Partitioned and Clustered Tables
• Nested and Repeated Fields

Lab 3: Writing SQL for BigQuery

• SELECT statements
• DML statements
• DDL statements
• UDFs and Procedures