Expanded Library
SQL: Using Joins, Constraints, Normalization, and Subqueries (Interactive)
Learn the most important parts of the SQL language so you can create tables with constraints, use relationships, and write powerful join queries.
What you'll learn
Learn the most important parts of the SQL language so you can create tables with constraints, use relationships, and write powerful join queries. This interactive course was formerly known as The Sequel to SQL on Code School.
Table of contents
Aggregate Functions
6mins
Constraints
13mins
- Identifying Constraints 6m
- Challenge: Adding Constraints 0m
- Challenge: Unique Table Constraint 0m
- Challenge: Primary Key Constraint 0m
- Value Constraints 7m
- Challenge: Foreign Key Constraint 0m
- Challenge: Foreign Key Table Constraint 0m
- Challenge: Dropping Tables with Foreign Key 0m
- Challenge: CHECK Constraints 0m
Normalization & Relationships
11mins
Joins & Aliases
12mins
