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.
Book this courseCourse Overview
1 day course
Certificate of Attendance
Private
Partner of the Year
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 live online or at a location of your choice in the UK.
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
Map data types in Teradata to data types in BigQuery
Carry out SQL translation from Teradata to BigQuery
Configure datasets and tables in BigQuery
Map and optimise schemas from Teradata to BigQuery
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 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
Who it's for
This course is for data analysts, engineers, scientists, application developers, and Teradata users who wish to transfer their skills and knowledge to BigQuery.
Prerequisites
Before taking this course, we recommend attending a session covering a general introduction to BigQuery, or equivalent experience.
BOOK THIS COURSE
Enquire for a team or large group
For private sessions call our sales team