Expanded Library

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.

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.

Table of contents

Aggregate Functions
6mins
Table Constraints
13mins
Normalization and Relationships
11mins
Inner Joins, Aliases, and Outer Joins
12mins
Subqueries
4mins

Course FAQ

What is SQL?

SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system.

What is SQL used for?

SQL is used to manage and organize data in all sorts of systems in which various data relationships exist.

What will I learn in this SQL tutorial?

In this course, you will learn the most important basics of the SQL language in order to create tables with constraints, relationships, and write other powerful queries.

Who is this course for?

This course is for anyone who wants to learn the SQL language.

Are there prerequisites for this SQL tutorial?

There are no prerequisites for this course.

About the author

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.

See more courses by Gregg Pollack
Ready to upskill? Get started