
New AI auto-completion feature release
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
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
Click on this link in order to create yourself a project to work with
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
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`
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`
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`
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!