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