Data Science Fundamentals SQL II Grouping, Filtering, NULLs, and Joins

About

An introduction to SQL, from foundational concepts to slightly more advanced techniques, using Google BigQuery as the practical platform.

This module covers data filtering, NULL handling, table joins, result combining, and SQL functions.

Learning Objectives

You will be able to:

Filter rows using WHERE and filter groups using HAVING.
Handle NULL values using IS NULL and IS NOT NULL.
Join multiple tables using INNER JOIN and LEFT JOIN.
Combine data using UNION and UNION ALL.
Use common SQL functions for math calculations and string manipulation.

Content

Topic	About
Intermediate SQL (SQL-II)	• Grouping Data • Data Filtering • `NULL` Handling • Table Joins • Result Combining • SQL Functions

Each section includes exercises and stretch challenges for practice, using the NCAA Basketball dataset in BigQuery.

Prerequisites

Familiarity with data types (e.g., strings, integers, floats, booleans)
Able to use Google BigQuery to access data via SQL.
Write and execute a SQL query, including SELECT, FROM, LIMIT, and DISTINCT.
Familiar with ORDER BY, aliasing tables, and introductory aggregate functions (MIN, MAX, SUM, AVG, and COUNT).
Understand the order of operations in SQL.

References

📖 Reference Materials

Important note

Please ignore the _layouts folder and the config.yml file in the root of this repo. They are needed to make sure the repo renders well; please don’t change them or delete them and your repo will work fine :)