Course Overview
In this course you will learn how to translate various concepts in Teradata to the analogous concepts in BigQuery. You will learn how the high-level architectures of Teradata and BigQuery compare, understand di erences in how to con gure datasets and tables, map data types in Teradata to data types in BigQuery, understand schema mapping from Teradata to BigQuery, optimize your new schemas in BigQuery, and do a high-level comparison of SQL dialects in Teradata and BigQuery
Course Objectives
- Comparing architecture and provisioning of resources in Teradata and BigQuery
- Configuring datasets and tables in BigQuery
- Mapping data types in Teradata to data types in BigQuery
- Mapping and optimizing schemas from Teradata to BigQuery
- SQL translation from Teradata to BigQuery
Who Should Attend?
Current users of Teradata (Data Engineers, Data Analysts, Data Scientists, Application Developers) migrating to BigQuery.
- Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
- Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
- Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
- Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
- Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
- Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.
Agenda
- Understanding BigQuery Architecture
- Creating Datasets and Tables in BigQuery
- Mapping Data Types
- Schema Mapping and Optimization
- SQL Translation from Teradata to BigQuery