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
- 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