Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Master SQL with BigQuery using AI tools - From Zero to Hero

Name: Master SQL with BigQuery using AI tools - From Zero to Hero
Rating: 4.2 (232 reviews)

Great opportunity to leverage AI in order to learn SQL from scratch, since the Gemini is embedded in Google BigQuery

Created byLiad Livne

Last updated 4/2026

English

English [Auto],

What you'll learn

In a few minutes you will setup your own personal project in BigQuery. Then you will load data into your data warehouse and start running queries
Write and Execute Core SQL Queries in BigQuery, including SELECT, FROM, WHERE, GROUP BY, ORDER BY, and JOIN) to effectively query, filter, and aggregate data.
Covers all the main topics: Basic commands, Windows and Aggregated Functions, Joins & Sub Queries
Manage and Structure Data in Google BigQuery: Learn to navigate the BigQuery interface, load data from various sources (like GCS or uploads)
Solve business questions on Big Data, using SQL statements and AI tools such as Gemini
Analyze Complex Data and Optimize Queries in BigQuery: Develop the skills to construct complex, multi-step SQL queries to extract meaningful insights

Course content

15 sections • 59 lectures • 7h 20m total length

Welcome aboard !1:29
Crack BigQuery SQL syntax with AI tools, learn through best practices and updates, and write your own SQL statements to become a SQL hero.
new AI feature3:29
New AI auto-completion feature release
BigQuery Tutorial2:09
Course instructions - Best practice2:01
Follow the instructions by order
Download the files and save them
Check the Release Notes & FAQ
Watch the Video in the lessons
Practice by yourself
Add Public database
Save your queries & Doc
Updates will come
all_queries.sql & Basic commands0:02
Release Notes & FAQ0:01
Release Notes & FAQ

Last update: 2025-04-28

Common mistakes:
Table name not warped with [`] "backtick"
You havne selected a Project
Query syntax - forgot comma [,]
AI is not enabled

SELECT *11:29
SQL Shortcuts6:39
SELECT DISTINCT6:52
WHERE - AND | OR13:54
Where - in / like / between
======================
Only rows whose bool_expression evaluates to TRUE are included.
Rows whose bool_expression evaluates to NULL or FALSE are discarded.

-- IN operator
SELECT
*
FROM
`sql_tutorial.orders`
WHERE
ShipType IN ('A', 'B', 'C')
LIMIT
1000

-- like operator
SELECT
*
FROM
`sql_tutorial.orders`
WHERE
CustomerID like '%NA%'
LIMIT
1000

Between
-------

X [NOT] BETWEEN Y AND Z
Returns TRUE if X is [not] within the range specified.
The result of "X BETWEEN Y AND Z" is equivalent to "Y >= X AND X >= Z" but X is evaluated only once in the former.

-- between operator
SELECT
*
FROM
`sql_tutorial.orders`
WHERE
ShipWeight between 150 and 160
-- OrderDate between '2018-11-29' and '2019-10-30'
-- CustomerID between 'B' and 'F'
LIMIT
1000
WHERE - IN | LIKE | BETWEEN8:17
Master SQL with BigQuery teaches you to filter rows with a where clause using boolean expressions and to use in, like, and between for range and pattern matching.
ORDER BY & LIMIT4:19
Sort results using order by and limit to expose the top ten rows, order by ship type ascending and order date, with nulls first or last.
CONDITIONAL EXPRESSIONS18:29
NULL4:57

Exec - 01 - Distinct2:17
Exec - 02 - In1:55
Query 1

Extract the Employee First Name and Last Name for all the employees who live in New York or Phoenix

SELECT * FROM `sql_tutorial.employees`
Exec - 03 - And2:15
Query 1
Extract the Employee First Name and Last Name for all the employees who is Male and his birth date is higher than 1978
SELECT * FROM `sql_tutorial.employees`
Exec - 04 - In5:37
Query 1
Extract all the EmployeeId and Order Date for all when the shipType is A or B or D or F
SELECT
*
FROM `sql_tutorial.orders`

Query 2
Extract all the OrderID, EmployeeId and Order Date for all when the CustomerID is NOTNA or AEVAS or UTROT or OWDLO
SELECT
*
FROM `sql_tutorial.orders`

Query 3
Extract all the Order details for the orders with the OrderDate 2018-11-29 2019-04-18 or 2018-08-02

SELECT
*
FROM `sql_tutorial.orders`
Exec - 05 - Like3:51

JOIN13:43
Master the join operator in BigQuery by combining two tables with inner, left, right, and full joins, using on or using syntax, and aliasing to query as a single source.
LEFT | RIGHT JOIN13:41
Master left and right joins using example tables, showing how left outer join preserves left rows while adding matching right rows, and how right join mirrors this behavior with nulls.
FULL JOIN5:21
Review the full outer join, which returns all rows from both tables, fills nonmatching rows with nulls, and acts as a combination of left and right joins.
CROSS JOIN6:00
Explore cross join fundamentals, generating Cartesian products and multiplication matrices by pairing every row from two sets, with examples of filtering by a < b.
SELF JOIN16:39

COUNT | COUNT distinct11:57
Master count and count distinct in BigQuery, including handling nulls, counting total vs unique values, and grouping results by fields like gender and owner names.
MAX | MIN6:07
Master the max and min aggregate functions in BigQuery, returning the largest or smallest non-null values, with practical examples across data types and null handling.
SUM | AVG5:22
Learn to use sum and average in BigQuery, including non-null results, floating point non-determinism, distinct sums, and ship-type aggregations with boolean case expressions.
HAVING4:02

Requirements

No programming skills are needed, you will learn everything you need to know
You must have a Gmail / Google Account
Computer (Mac/Windows/Linux)

Description

2026-04-03 (update)
In the recent days Google BigQuery released a new feature - Gemini Auto completion which will make your learning easer than ever !!

Are you ready to unlock the power of data analysis using SQL, but find the learning curve daunting? Do you want to master Google BigQuery, a leading cloud data warehouse, but don't know where to start? What if you could learn these critical skills faster and more intuitively by harnessing the power of cutting-edge Artificial Intelligence?

This comprehensive "Zero to Hero" course offers a truly unique and modern approach to learning SQL specifically within the powerful Google BigQuery environment. We leverage the great opportunity presented by embedded AI tools, including Google's Gemini, right within BigQuery itself! This means you won't just learn SQL syntax; you'll learn how to use AI as your personal tutor and coding assistant to understand concepts, generate query ideas, debug errors, and accelerate your path to mastery – all from scratch.

Throughout this hands-on course, you will learn:

The absolute fundamentals of SQL, including SELECT, FROM, WHERE, GROUP BY, ORDER BY, JOIN operations, and common functions.
How to write efficient queries to analyze massive datasets stored in Google BigQuery.
Core concepts of BigQuery's architecture, including datasets, tables, jobs, and best practices for cost and performance optimization.
Practical techniques for loading data into BigQuery and preparing it for analysis.
Crucially, how to effectively utilize BigQuery's integrated AI features (like Gemini assistance) to:
- Explain complex SQL queries in plain language.
- Generate SQL code suggestions based on your needs.
- Help identify and fix errors in your queries.
- Summarize data and tables.
How to apply your SQL and BigQuery skills to solve real-world data analysis problems using public datasets.

Why is this course different?

We go beyond traditional teaching methods by integrating AI as a core part of the learning process. This course demonstrates how modern AI tools embedded within data platforms are revolutionizing how we learn and work with data. We focus on practical application, moving step-by-step from basic concepts to more advanced queries, ensuring you build confidence and real-world skills. No prior experience? No problem! We truly start from zero.

Who is this course for?

Aspiring Data Analysts, Data Scientists, Business Analysts, and BI professionals.
Students aiming for careers in tech and data.
Professionals looking to transition into data roles or upscale in cloud data warehousing.
Anyone who wants to learn SQL and BigQuery from the very beginning using an innovative, AI-assisted approach.
Individuals looking to move beyond spreadsheets for data analysis.

Prerequisites:

Absolutely no prior SQL or database knowledge is required.
Basic computer literacy and access to a web browser.
Ability to sign up for the Google Cloud Free Tier/BigQuery Sandbox (we'll guide you!).

Take the leap into modern data analysis!
Enroll today and transform yourself from a complete beginner into a confident SQL and BigQuery user, leveraging the power of AI every step of the way!

Who this course is for:

Aspiring Data Analysts, Data Scientists, or Business Intelligence Professionals: Looking to build foundational skills in SQL and cloud data warehousing, essential for landing jobs in the data field with the best practice how to embedded SQL with AI tools
Data enthusiastic

Master SQL with BigQuery using AI tools - From Zero to Hero

What you'll learn

Explore related topics

Course content

Introduction6 lectures • 9min

Setup5 lectures • 35min

Basic commands8 lectures • 1hr 15min

Basic commands - Exercises5 lectures • 16min

JOIN operators5 lectures • 55min

JOIN operators - Exercise3 lectures • 18min

Aggregated Functions4 lectures • 27min

Aggregated Functions - Exercise2 lectures • 11min

Sub Queries & Union4 lectures • 32min

Sub Queries & Union - Exercise2 lectures • 16min

Requirements

Description

Who this course is for: