Help make Code School better
We are hoping that you could take a minute to let us know what you thought about The Sequel to SQL.
Level 1 Free Level 2 Videos | 10 ChallengesAggregate Functions
Learn how to use SQL aggregate functions, including COUNT, SUM, and AVG, to do calculations on groups of data.
Level 2 2 Videos | 11 ChallengesTable Constraints
Add constraints — like NOT NULL, UNIQUE, FOREIGN KEY, and PRIMARY KEY — to your tables to increase data integrity.
Level 3 2 Videos | 7 ChallengesNormalization and Relationships
Apply normalization rules to create tables without duplicate data and build the appropriate relationships.
Level 4 3 Videos | 7 ChallengesInner Joins, Aliases, and Outer Joins
Explore writing a single query to pull data from multiple tables and using aliases to create succinct queries.
Level 5 1 Video | 3 ChallengesSubqueries
Dive deeper as you learn how to write queries within queries.
Complete these levels to unlock
Course Completion Badge
Learn the most important parts of the SQL language so you can create tables with constraints, use relationships, and write powerful join queries.
Watch Us Build
About The Professor
Gregg is passionate about taking complex topics and teaching them efficiently. He's helped build Envy Labs, Starter Studio, and Code School. He also furthers education through BarCamp in Orlando, the Orlando Ruby Users Group, and the Orlando Tech Events newsletter.View Full Credits
- Estimated Course Length: 4 - 5 hours