-
Course
- Core Tech
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 | 5m 59s
- Challenge: Adding Constraints | 10s
- Challenge: Unique Table Constraint | 10s
- Challenge: Primary Key Constraint | 10s
- Value Constraints | 6m 35s
- Challenge: Foreign Key Constraint | 10s
- Challenge: Foreign Key Table Constraint | 10s
- Challenge: Dropping Tables with Foreign Key | 10s
- Challenge: CHECK Constraints | 10s