1 day course

Supporting material

Google Cloud Partner of the Year

Private

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

Prerequisites

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