Expanded

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.
Get started
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
Your 10-day individual free trial includes:

Expanded library

This course and over 7,000+ additional courses from our full course library.

Hands-on library

Practice and apply knowledge faster in real-world scenarios with projects and interactive courses.
*Available on Premium only
Start a Premium 10-day free trial
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 FAQ
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
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
SQL: Using Joins, Constraints, Normalization, and Subqueries (Interactive)
Beginner
50m
Oct 28, 2021
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

Course info
Rating
(30)
Level
Intermediate
Updated
Jun 30, 2015
Duration
46m
Pluralsight IQ
Know exactly where everyone on your team stands with assessments and analytics.
Try our full library including this course free for your whole team for 14-days.