Expanded

SQL: Using Joins, Constraints, Normalization, and Subqueries (Interactive)

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
Level
Beginner
Updated
Oct 28, 2021
Duration
50m
Table of contents
Aggregate Functions
Common Aggregate Functions 3m Challenge: Actor Pay Rates 0m Challenge: Counting Actors 0m Challenge: Adding Numeric Values 0m Challenge: Average Salary 0m Aggregates Within Clauses 3m Challenge: Filtering Aggregates 0m
Constraints
Identifying Constraints 6m Challenge: Adding Constraints 0m Challenge: Unique Table Constraint 0m Challenge: Primary Key Constraint 0m Value Constraints 7m Challenge: Foreign Key Constraint 0m Challenge: Foreign Key Table Constraint 0m Challenge: Dropping Tables with Foreign Key 0m Challenge: CHECK Constraints 0m
Normalization & Relationships
Normalization 6m Challenge: Join Table Creation SQL 0m Challenge: Inserting a Join Row 0m Relationships 5m Challenge: Creating a Relationship 0m
Joins & Aliases
Inner Joins 5m Challenge: Your First Inner Join 0m Challenge: Two Inner Joins 0m Aliases 3m Challenge: Column and Table Aliases 0m Challenge: Three Table Aliases 0m Outer Joins 4m Challenge: Your First Outer Join 0m Challenge: On the Other Hand 0m
Subqueries
Subqueries 4m Challenge: Our First Subquery 0m Challenge: An Aggregate Subquery 0m Challenge: Thinking Outer of the Box 0m
Description
Course info
Level
Beginner
Updated
Oct 28, 2021
Duration
50m
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. This interactive course was formerly known as The Sequel to SQL on Code School.

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

Course info
Level
Beginner
Updated
Oct 28, 2021
Duration
50m
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.