1 day course 
Supporting material 
Google Cloud Partner of the Year 
Private Buy 1 Private Course, Get 2 Scheduled Courses Free
Buy any private course for delivery in 2024, and receive two free scheduled training courses to be taken before March 31, 2025. See our offers page for more details.
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 the US.
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
- Quick reminder of Teradata architecture
- Overview of BigQuery architecture
- Separation of compute and storage in BigQuery
- BigQuery Slots
- Workload management 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
- How data types map from Teradata to BigQuery
- Understand data types unique to BigQuery
- Schema definitionsin BigQuery
- Partitioning in BigQuery
- Clustering in BigQuery
- Lab: Schema Migration to BigQuery
- SELECT statements
- DML statements
- DDL statements
- UDFs and Procedures
- Lab: Writing SQL for BigQuery