- Course
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.
Beginner
- Course
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.
Beginner
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Core Tech
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.
SQL: Using Joins, Constraints, Normalization, and Subqueries (Interactive)
Beginner
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