CATEGORY
Databases and Data
Relational data, SQL, PostgreSQL, and practical data handling.
LESSONS
Choose a lesson
Open Learn, then continue with Practice and Prove.
Beginner
Relational Data, Tables, Rows, and Keys
SQL Fundamentals
Open lessonBeginner
Install a Local SQL Practice Database
SQL Fundamentals
Open lessonBeginner
Create Tables and Choose Column Types
SQL Fundamentals
Open lessonBeginner
Select Columns and Rows
SQL Fundamentals
Open lessonBeginner
Filter Rows with WHERE
SQL Fundamentals
Open lessonBeginner
Sort, Limit, and Remove Duplicates
SQL Fundamentals
Open lessonBeginner
Work with NULL and Unknown Values
SQL Fundamentals
Open lessonBeginner
Insert Rows Safely
SQL Fundamentals
Open lessonBeginner
Update Rows with Targeted Conditions
SQL Fundamentals
Open lessonBeginner
Delete Rows and Protect Scope
SQL Fundamentals
Open lessonBeginner
Expressions, Aliases, and String Operations
SQL Fundamentals
Open lessonBeginner
Aggregate Functions
SQL Fundamentals
Open lessonBeginner
Group Results with GROUP BY and HAVING
SQL Fundamentals
Open lessonBeginner
Join Tables with INNER JOIN
SQL Fundamentals
Open lessonBeginner
Keep Unmatched Rows with OUTER JOIN
SQL Fundamentals
Open lessonIntermediate
Subqueries and Common Table Expressions
SQL Fundamentals
Open lessonIntermediate
Constraints and Data Integrity
SQL Fundamentals
Open lessonIntermediate
SQL Fundamentals Capstone
SQL Fundamentals
Open lesson