Course Description
Learn the most important parts of the SQL language so you can create tables with constraints, use relationships, and write powerful join queries.
Course Overview
-
Level 1 Free Level Aggregate Functions 2 Videos | 10 Challenges
Learn how to use SQL aggregate functions, including COUNT, SUM, and AVG, to do calculations on groups of data.
-
Level 2 Table Constraints 2 Videos | 11 Challenges
Add constraints — like NOT NULL, UNIQUE, FOREIGN KEY, and PRIMARY KEY — to your tables to increase data integrity.
-
Level 3 Normalization and Relationships 2 Videos | 7 Challenges
Apply normalization rules to create tables without duplicate data and build the appropriate relationships.
-
Level 4 Inner Joins, Aliases, and Outer Joins 3 Videos | 7 Challenges
Explore writing a single query to pull data from multiple tables and using aliases to create succinct queries.
-
Level 5 Subqueries 1 Video | 3 Challenges
Dive deeper as you learn how to write queries within queries.
Additional Resources (1)
-
Soup to Bits
Soup to Bits: The Sequel to SQL Database
Recommended Prerequisites
About The Professor
Gregg Pollack
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.
Teaching Assistants
Course Notes
This course should take approximately 4 - 5 hours.
Enroll yourself or your team in Code School and get unlimited access to all courses, screencasts, build your report card, and more.
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.