Your Progress
Introduction to SQL
Learn what Structured Query Language is and why it's important
SELECT Basics
Learn how to retrieve specific columns of data
Filtering with WHERE
Learn how to filter data using the WHERE clause
Pattern Matching with LIKE
Learn how to search for text patterns in your data
Working with NULL Values
Learn how to handle missing data in SQL databases
Sorting Results
Learn how to sort query results using ORDER BY
Aggregate Functions
Learn how to use COUNT, SUM, AVG, MIN, and MAX functions
Grouping Data
Learn how to group data and use aggregate functions on groups
Basic JOINs
Learn how to combine data from multiple tables
The LIMIT Clause
Learn how to restrict the number of rows returned by a query
The OFFSET Clause
Learn how to skip rows in your query results
LEFT JOIN
Learn how to retrieve all records from the left table and matching records from the right table
RIGHT JOIN
Learn how to retrieve all records from the right table and matching records from the left table
FULL JOIN
Learn how to retrieve all records when there's a match in either table
Subqueries
Learn how to use queries inside other queries for powerful data retrieval