Course banner

SQL

The SQL language from the ground up.

About This Course
You'll Learn
The SQL language from the ground up. All topics in this course apply to any SQL database, including MySQL, PostgreSQL, Oracle, and SQL Server.
There are 33 lessons containing 212 code examples. Most people finish this course in 6 hours over 9 calendar days.
Prerequisites
Basic JavaScript knowledge. This course isn't about JavaScript, but the code examples do use JavaScript. No SQL experience is required.
What Other Developers Think
Thanks @garybernhardt for finally giving me the motivation to learn enough SQL to be dangerous ;)
— Brett CTwitter avatar
[Execute Program] gives me a great way to practice programming in the way that pianists practice scales. I've been having a lot of fun doing the Regex, SQL, and Typescript courses.
— Andrew ETwitter avatar
Level 1
Basic Column Types
Selecting Columns
No Type Enforcement in SQLite
Null
Inserting Multiple Rows
Level 2
Locked Lesson IconLocked
Select Where
No Booleans in SQLite
Updating Rows
Selecting Expressions
Unique Constraints
Primary Keys
Level 3
Locked Lesson IconLocked
Column Aliases
Comparing With Null
Selecting Expressions From Tables
Bind Parameters
Multiple Statements
Null in Unique Constraints
Level 4
Locked Lesson IconLocked
Deleting Rows
Dropping Tables
Comments
Referencing Other Tables
Defaults
Foreign Keys
SQL Injection
On Conflict Do Nothing
Quiz: Two Foreign Keys
Level 5
Locked Lesson IconLocked
On Conflict Update
Constraint Analysis
Simple Joins
Quiz: Discounts and Users and Comments
Join Performance
Left and Right Joins
ON vs. WHERE
Join Mistakes