Working with SQL in BigQuery for Teradata Professionals

Overview
BigQuery supports many types of SQL statements including data definition language (DDL), data manipulation language (DML), user-defined functions (UDFs), and stored procedures.

The objective of this lab is to provide Teradata professionals with the necessary knowledge and skills to begin working with SQL in BigQuery. Upon completion of this lab, Teradata professionals will have a deeper understanding of how to use SQL in BigQuery to create, update, and work with data structures in BigQuery.

In this lab, you create tables and views using DDL statements, update tables using DML statements, join data using SQL, and define custom user-defined functions (UDFs) and stored procedures.

Objectives
In this lab, you learn how to:
- Create new tables and views using DDL statements.
- Update existing table data using DML statements.
- Join data and define common table expressions (CTEs) using SQL SELECT statements.
- Define custom UDFs and stored procedures.

#gcp #googlecloud #qwiklabs #learntoearn