Migrating Teradata Users to BigQuery (MTUBQ) – Contenuti

Contenuti dettagliati del Corso

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