Course Content
Introduction
0/1
Overview
01:39
BigQuery Table Operations
0/8
How to Create a Table in BigQuery
11:44
Upload Data from Google Sheets to BigQuery
07:59
How to Delete a Table in BigQuery
01:20
How to Append or Insert Data into an Existing Table in BigQuery
04:51
How to Append or Insert Multiple Rows into an Existing Table in BigQuery
03:49
How to Update or Change Values in an Existing Table in BigQuery
05:08
How to Delete Data from a Table in BigQuery
03:57
How to Delete All Data and Drop a Table in BigQuery
02:37
Core SQL Querying & Filtering
0/9
How to Select Specific Columns in BigQuery
09:32
How to Rename Columns in BigQuery Using AS _ SQL Alias Tutorial
04:40
How to Use WHERE Filter in BigQuery
04:06
Using WHERE Filter with AND OR Operators in BigQuery
02:57
Master SQL LIKE and NOT LIKE Operators in BigQuery
04:09
Master SQL IN and NOT IN Operators in BigQuery
03:37
Master the SQL BETWEEN Operator in BigQuery
00:00
Eliminate Duplicates with SQL DISTINCT in BigQuery
04:03
Count Unique Values in SQL Columns with BigQuery
02:08
Aggregation, Grouping and Ordering
0/7
How to Aggregate Columns in BigQuery
03:47
Using GROUP BY in BigQuery
06:25
Master SQL HAVING Clause in BigQuery
04:19
Sort Data Like a Pro – Master the ORDER BY Clause in SQL with BigQuery
03:07
Master the LIMIT Clause in SQL with BigQuery
01:56
Master the OFFSET Keyword in SQL – Skip Rows Efficiently in BigQuery
02:56
Mastering Aggregate Functions in SQL BigQuery – SUM, AVG, COUNT More!
12:27
Advanced Query Structures
0/4
Mastering the SQL WITH Clause in BigQuery
04:01
Using Multiple WITH Clauses in BigQuery
03:50
Mastering Subqueries in BigQuery
03:09
Understand SQL Execution Order – How Queries Are Processed in BigQuery
06:31
Data Types, Schema and NULL Handling
0/9
Understanding Table Schema in BigQuery
04:54
How to Change Data Schema or Data Types in BigQuery – SQL Schema Modification
10:59
Null vs Blank Values in SQL – Understanding the Difference
02:35
How to Exclude NULL or Blank Values in SQL Queries
03:25
Replace NULL Values Using IFNULL and COALESCE in BigQuery SQL
05:38
Aggregation Functions on NULL Values in BigQuery SQL
03:59
Handling NULL Values in SUM Function in BigQuery SQL
03:15
How to CAST or Change Data Type in SQL
08:02
CAST vs SAFE_CAST in SQL BigQuery – Key Differences When to Use Each
02:56
Conditional Logic & Fundamental Functions
0/13
Mastering CASE WHEN Statements in SQL on BigQuery
05:36
Converting Text to Lowercase Uppercase in BigQuery – SQL String Functions
02:57
Master String Functions in BigQuery SQL
17:27
Mastering Integer and Float Functions in BigQuery SQL
19:42
Working with Booleans in BigQuery SQL
04:31
Extract Date, Month, and Year from a Column in BigQuery – SQL Date Functions
04:03
Master Date Functions in SQL – Essential Techniques for Data Manipulation
07:31
Current Date and Time Functions in BigQuery SQL – Mastering Time-Based Queries
04:13
Add or Subtract Date and Time in BigQuery SQL – Essential Date Manipulation
09:01
Round Off and Truncate DateTime Values in BigQuery SQL – Master DateTime
05:19
Add or Subtract Days in BigQuery SQL – Date Arithmetic Simplified
03:09
Master Time Functions in BigQuery SQL – Work with Time Data Like a Pro
11:23
Mastering Timestamp Functions in BigQuery SQL – Complete Guide
20:12
SQL, Joins and Set Operators
0/8
Mastering Left Join in SQL – Complete Guide to Combining Data
15:20
Mastering INNER JOINs in BigQuery SQL
06:09
Mastering RIGHT JOIN in BigQuery SQL
04:24
Mastering FULL JOIN in BigQuery SQL
05:23
Mastering CROSS JOIN in BigQuery SQL
03:54
Mastering Self JOIN in BigQuery SQL
06:39
Using UNION ALL in SQL BigQuery – Combining Data from Multiple Tables
11:50
EXCEPT Keyword in SQL BigQuery – How to Exclude Data from Results
02:56
Window Functions for Analytical SQL
0/13
ROW_NUMBER() Window Function in SQL BigQuery – Ranking and Ordering Data
05:27
RANK() Window Function in SQL BigQuery – Ranking Data with Precision
05:20
DENSE_RANK() Window Function in SQL BigQuery – Ranking Without Gaps
03:07
LEAD() LAG() Window Functions in SQL BigQuery – Moving Data Forward and Backward
04:07
SUM() CUMSUM() in Window Functions – Calculating Running Totals
03:34
COUNT() in Window Functions – Counting Rows Within Specific Windows
02:04
CUME_DIST() in SQL – Understanding Cumulative Distribution in BigQuery
04:13
Calculating Standard Deviation in SQL – A Step-by-Step Guide for BigQuery
02:52
FIRST_VALUE() LAST_VALUE() Window Functions in SQL BigQuery
05:03
Understanding PERCENT_RANK() in SQL – How to Calculate Percent Rank in BigQuery
04:08
AVERAGE() in Window Functions – Calculating Moving Averages in SQL BigQuery
03:46
Calculating Variance in SQL – A Comprehensive Guide for BigQuery
01:59
Understanding Correlation in SQL – A Step-by-Step Guide with BigQuery
06:04
Working with Complex and Nested Data
0/15
Mastering Array Aggregations in SQL – Techniques and Best Practices
03:21
Mastering String Aggregations in SQL – Concatenate, Group, and Analyze Text
03:21
Working with Arrays in SQL – A Comprehensive Guide
05:22
Mastering Array Functions in SQL – Essential Techniques and Use Cases
12:23
Using Array Subqueries in SQL – Advanced Techniques and Best Practices
01:52
Preferred Method for UNNESTing Arrays in SQL – Best Practices
03:36
Unnest Arrays in SQL the Unpreferred Way – Scalar Approach Explained
02:51
Unnesting Arrays in SQL – Transform Array Data into Rows
04:02
Understanding Struct Data Types in SQL – Usage and Best Practices
03:23
Working with Nested Data Types – Arrays of Structs in SQL
03:24
Using Structs within Arrays in SQL – A Deep Dive
03:55
Using Structs in Query Results in SQL – Simplifying Complex Data
01:52
Modifying Data Inside Structs in SQL – Tips and Techniques
01:11
Working with Multiple Nested Structs in SQL – Advanced Techniques
01:25
Using Aggregate Functions with Structs in SQL – Advanced Data Analysis
02:50
Performance Optimization and Workflow Automation
0/6
Understanding Query Execution Details in SQL – Optimize Performance
09:50
How to Schedule and Automate Table Workflows in SQL
12:40
Mastering Pivot Tables in SQL – Transform Your Data with Ease
05:59
Unpivoting in SQL – Transform Data from Columns to Rows
03:01
Understanding Partitioned Tables in SQL – Optimize Query Performance
07:07
Clustering Tables in SQL- Boost Query Performance and Storage Efficiency
10:00
Learn BigQuery SQL Mastery taught by Googler
Previous
Next
0% Complete