Advanced

Code School: The Sequel to SQL

By Gregg Pollack
Learn the most important parts of the SQL language so you can create tables with constraints, use relationships, and write powerful join queries.
Course info
Rating
(30)
Level
Intermediate
Updated
Jun 30, 2015
Duration
46m
Table of contents
Aggregate Functions
Common Aggregate Functions 3m Aggregates Within Clauses 3m
Table Constraints
Identifying Constraints 6m Value Constraints 7m
Normalization and Relationships
Normalization 6m Relationships 5m
Inner Joins, Aliases, and Outer Joins
Inner Joins 5m Aliases 3m Outer Joins 4m
Subqueries
Subqueries 4m
Description
Course info
Rating
(30)
Level
Intermediate
Updated
Jun 30, 2015
Duration
46m
Description

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

About the author
Gregg Pollack
About the author

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.

More from the author
Code School: Accelerating Through Angular
Beginner
1h 1m
Oct 24, 2016
Code School: Real-time Web with Node.js
Beginner
1h 7m
Sep 23, 2016
More courses by Gregg Pollack

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT