Database

The Sequel to SQL

​Learn the most important parts of the SQL language so you can create tables with constraints, use relationships, and write powerful join queries.

Enroll Now to Play

Course Overview

  1. The Sequel to SQL Level 1 Badge

    Level 1 Free Level 2 Videos | 10 Challenges
    Aggregate Functions

    Learn how to use SQL aggregate functions, including COUNT, SUM, and AVG, to do calculations on groups of data.

  2. The Sequel to SQL Level 2 Badge

    Level 2 2 Videos | 11 Challenges
    Table Constraints

    Add constraints — like NOT NULL, UNIQUE, FOREIGN KEY, and PRIMARY KEY — to your tables to increase data integrity.

  3. The Sequel to SQL Level 3 Badge

    Level 3 2 Videos | 7 Challenges
    Normalization and Relationships

    Apply normalization rules to create tables without duplicate data and build the appropriate relationships.

  4. The Sequel to SQL Level 4 Badge

    Level 4 3 Videos | 7 Challenges
    Inner Joins, Aliases, and Outer Joins

    Explore writing a single query to pull data from multiple tables and using aliases to create succinct queries.

  5. The Sequel to SQL Level 5 Badge

    Level 5 1 Video | 3 Challenges
    Subqueries

    Dive deeper as you learn how to write queries within queries.

The Sequel to SQL completion badge

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.

Supplemental Learning

Recommended Prerequisites

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

Course Notes

  • Estimated Course Length: 4 - 5 hours

Course Reviews (14)

discostews

Another good course from the Codeschool team - excellent overview of the basics of SQL. Found it a good refresh on skills and also a good way to get clarity on some topics like ALIAS and SUBQUERY that I'd been googling to achieve. Looking forward to the next one.

alphaneer

This is a great all around course. If you've spent some time away from your favorite sql query editor, this course provides a very nice interactive walk through to get you thinking about the arrangement of data again and how to shape it into something useful.

NorwayKen

Just wanted to tell you that the sequel to sql <-- CAN't stop saying that btw. is great. You make advanced SQL seem basic. I really liked that the course showed you the structure of the database and not only how to get out the data. I am going to recommend this course to both beginners and advanced users alike.