BigQuery Fundamentals for Teradata Professionals (Coursera)

Offered by Google Cloud,
BigQuery Fundamentals for Teradata Professionals (Coursera)

This course covers BigQuery fundamentals for professionals who are familiar with SQL-based cloud data warehouses in Teradata and want to begin working in BigQuery. Through interactive lecture content and hands-on labs, you learn how to provision resources, create and share data assets, ingest data, and optimize query performance in BigQuery. Drawing upon your knowledge of Teradata, you also learn about similarities and differences between Teradata and BigQuery to help you get started with data warehouses in BigQuery.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

What You Will Learn

  • Describe BigQuery’s architecture, resource provisioning, and data definition model.
  • Create, secure, and share BigQuery data assets using best practices.
  • Implement common patterns and best practices for designing schemas, ingesting data, and querying data in BigQuery.
  • Compare and contrast the differences and commonalities between Teradata and BigQuery.

Syllabus

WEEK 1
BigQuery Architecture and Resource Provisioning
This introductory module summarizes the key details of BigQuery architecture and resource provisioning including how BigQuery utilizes slots to execute SQL queries and workload management in BigQuery. Drawing upon your knowledge of Teradata, this module also provides a high-level overview of the similarities and differences between Teradata and BigQuery architecture and resource provisioning to help you get started with BigQuery.
BigQuery Data Definition Model
This module summarizes the key details of BigQuery’s resource hierarchy and data definition model, including how to create datasets and tables in BigQuery. Drawing upon your knowledge of Teradata, this module also provides a high-level overview of the similarities and differences between the Teradata and BigQuery resource hierarchies and primary data types to help you start working with data in BigQuery.
BigQuery and Google Cloud IAM
This module summarizes the key details of the Google Cloud Identity and Access Management (IAM) model, including how roles and permissions are applied to datasets and tables in BigQuery. Drawing upon your knowledge of Teradata, this module also provides a high-level overview of the similarities and differences in roles and permissions between Teradata and BigQuery to help you start securing and sharing your data in BigQuery.

WEEK 2
BigQuery Data Ingestion
This module summarizes the primary options and best practices for ingesting data into BigQuery, including batch data loading, streaming ingestion, and queries to external data sources. Drawing upon your knowledge of Teradata, this module also provides a high-level overview of the similarities and differences in data ingestion options between Teradata and BigQuery to help you start reading and loading your data into BigQuery.
BigQuery Schema Design and Optimization
This module summarizes common patterns and best practices for designing and optimizing table schemas in BigQuery, including the use of nested and repeated fields, partitioning, and clustering. Drawing upon your knowledge of Teradata, this module also provides a high-level overview of the similarities and differences in schema usage and design between Teradata and BigQuery to help you start structuring and optimizing your data in BigQuery.
SQL in BigQuery
This module summarizes the key features and operations of the Google Standard SQL dialect used in BigQuery and best practices for optimizing query performance and controlling costs in BigQuery. Drawing upon your knowledge of Teradata, this module also provides a high-level overview of the similarities and differences in the SQL dialects and features between Teradata and BigQuery to help you start running and optimizing queries in BigQuery.

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Using Databases with Python (Coursera) Coursera
University of Michigan

Using Databases with Python (Coursera)

This course will introduce students to the basics of the Structured Query Language (SQL) as well as basic database design for storing data as part of a multi-step data gathering, analysis, and processing effort. The course will use SQLite3 as its database. We will also build web crawlers and multi-step data gathering and visualization processes. We will use the D3.js library to do basic data visualization.

Nov 30th 2026
5-12 Weeks
Big Data Analysis with Scala and Spark (Coursera) Coursera
École Polytechnique Fédérale de Lausanne

Big Data Analysis with Scala and Spark (Coursera)

Manipulating big data distributed over a cluster using functional concepts is rampant in industry, and is arguably one of the first widespread industrial uses of functional ideas. This is evidenced by the popularity of MapReduce and Hadoop, and most recently Apache Spark, a fast, in-memory distributed collections framework written in Scala. In this course, we'll see how the data parallel paradigm can be extended to the distributed case, using Spark throughout.

Dec 7th 2026
4 Weeks
Dataplex by Google Cloud (Coursera) Coursera
Board Infinity

Dataplex by Google Cloud (Coursera)

Welcome to "Dataplex By Google Cloud " a comprehensive course designed to provide a thorough understanding of Google Cloud Dataplex, a platform for managing, monitoring, and analyzing data across various data systems in Google Cloud. Spanning two modules, the course begins with the fundamentals of Dataplex, including its setup, configuration, and basic functionalities.

Dec 7th 2026
2 Weeks
Big Data Analysis with Scala and Spark (Scala 2 version) (Coursera) Coursera
École Polytechnique Fédérale de Lausanne

Big Data Analysis with Scala and Spark (Scala 2 version) (Coursera)

Manipulating big data distributed over a cluster using functional concepts is rampant in industry, and is arguably one of the first widespread industrial uses of functional ideas. This is evidenced by the popularity of MapReduce and Hadoop, and most recently Apache Spark, a fast, in-memory distributed collections framework written in Scala. In this course, we'll see how the data parallel paradigm can be extended to the distributed case, using Spark throughout.

Dec 7th 2026
4 Weeks
Optimizing Your Google Cloud Costs en Español (Coursera) Coursera
Google Cloud

Optimizing Your Google Cloud Costs en Español (Coursera)

Optimizing Your Google Cloud Platform (GCP) Costs es el segundo curso de una serie de dos partes sobre los conceptos básicos de la administración de costos y facturación de GCP. Este curso está destinado principalmente a personas que se desempeñan en funciones relacionadas con finanzas o TI, y que están a cargo de optimizar la infraestructura de nube de sus organizaciones.

Dec 7th 2026
3 Weeks
SQL for Data Science Capstone Project (Coursera) Coursera
University of California, Davis

SQL for Data Science Capstone Project (Coursera)

Data science is a dynamic and growing career field that demands knowledge and skills-based in SQL to be successful. This course is designed to provide you with a solid foundation in applying SQL skills to analyze data and solve real business problems. Whether you have successfully completed the other courses in the Learn SQL Basics for Data Science Specialization or are taking just this course, this project is your chance to apply the knowledge and skills you have acquired to practice important SQL querying and solve problems with data. You will participate in your own personal or professional journey to create a portfolio-worthy piece from start to finish.

Nov 30th 2026
4 Weeks
BigQuery Fundamentals for Oracle Professionals (Coursera) Coursera
Google Cloud

BigQuery Fundamentals for Oracle Professionals (Coursera)

This course covers BigQuery fundamentals for professionals who are familiar with SQL-based cloud data warehouses in Oracle and want to begin working in BigQuery. Through interactive lecture content and hands-on labs, you learn how to provision resources, create and share data assets, ingest data, and optimize query performance in BigQuery. Drawing upon your knowledge of Oracle, you also learn about similarities and differences between Oracle and BigQuery to help you get started with data warehouses in BigQuery.

Dec 7th 2026
2 Weeks
Preparing for the Google Cloud Professional Data Engineer Exam (Coursera) Coursera
Google Cloud

Preparing for the Google Cloud Professional Data Engineer Exam (Coursera)

From the course: "The best way to prepare for the exam is to be competent in the skills required of the job." This course uses a top-down approach to recognize knowledge and skills already known, and to surface information and skill areas for additional preparation. You can use this course to help create your own custom preparation plan. It helps you distinguish what you know from what you don't know. And it helps you develop and practice skills required of practitioners who perform this job.

Dec 14th 2026
5-12 Weeks