Migrating Teradata Users to BigQuery

Learn how to navigate both Teradata and BigQuery architectures, so that you can configure your datasets, optimize your schemas, and successfully map all of your users to BigQuery.

google badge
Book this course
Call our sales team today
1 day course
Supporting material
Google Cloud Partner of the Year
A private training session for your team. Groups can be of any size, at a location of your choice including our training centres.

As a Google Cloud Partner, we’ll use lectures and labs to show you how to translate various concepts in Teradata to the analogous concepts in BigQuery.

You’ll become familiar with the high-level architectures of both systems, and, by the end of the course, will understand the key differences in how to configure datasets and tables, and be able to map data types in Teradata to data types in BigQuery.

We’ll also teach you about schema mapping from Teradata to BigQuery and how to optimize your new schemas in BigQuery. The session will cover a high-level SQL dialect comparison in both systems.

Our Migrating Teradata Users to BigQuery course is available as a private training session that can be delivered via Virtual Classroom or at a location of your choice in South Africa.

Course overview

Who should attend:

This course is for data analysts, engineers, scientists, application developers, and Teradata users who wish to transfer their skills and knowledge to BigQuery.

What you'll learn:

By the end of this course, you will be able to:

  • Compare architecture and provisioning of resources in Teradata and BigQuery
  • Configure datasets and tables in BigQuery
  • Map data types in Teradata to data types in BigQuery
  • Map and optimise schemas from Teradata to BigQuery
  • Carry out SQL translation from Teradata to BigQuery


Before taking this course, we recommend attending a session covering a general introduction to BigQuery, or equivalent experience.

Course agenda

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 & 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
  • How data types map from Teradata to BigQuery
  • Understand data types unique to BigQuery
Module 4: Schema Mapping & Optimisation
  • Schema definitionsin 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
Don't miss out
Keep up to date with news, views and offers from Jellyfish Training.
Your data will be handled in accordance with our Privacy Policy