Manage data with CLI in BigQuery
You will learn how to create, update, list, delete resources and execute queries with...
Master Conditional Expressions in BigQuery
You will understand the conditional expressions such as CASE, IF, IFNULL and NULLIF and know...
Master DateTime Functions in BigQuery
You will learn how to extract date and time from timestamp columns and how to...
SELECT Statement in BigQuery
With SELECT statement, you can specify the columns you want to retrieve, as well...
Transform Data with DML in BigQuery
Understanding DML is essential for maintaining data integrity and ensuring the accuracy and consistency of...
Understand Array in BigQuery
You will understand the concept of Array and STRUCT, and learn how to create, convert...
Undertand STRUCT In BigQuery
STRUCT In BigQuery, a STRUCT is a data type that represents a structured record. You...
UNION operator in BigQuery
The UNION operator combines the results of two or more input queries by pairing columns from the...
WHERE and HAVING in BigQuery
The WHERE clause filters the results of the FROM clause. The HAVING clause filters the results produced...
Work with multi-statement queries in BigQuery
You will learn how to write multi-statement queries, use temporary tables and write subqueries effectively...
- 1
- 2