-
Intro to GCP & SQL Workspace
-
Creating Dataset & Importing Table
-
Exploring SELECT statement
-
Using WHERE clause & OPERATORS
-
Using Limit clause inside Subqueries
-
Using Aggregation, Grouping & Alias
-
Working with LIKE & Wildcards
-
Understanding the usage of HAVING clause
-
Append data vertically using UNION
-
How to use SQL JOINS to merge data
-
Create logical columns using CASE
-
Using UNNEST & STRUCT with an ARRAY
-
Using UPDATE statement for data cleaning
-
Exploring INSERT statement for adding rows
-
Removing rows using DELETE statement
-
Standard vs. Materialized views