Interactive
Expanded Library

SQL: Using Joins, Constraints, Normalization, and Subqueries

by Gregg Pollack

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. This interactive course was formerly known as The Sequel to SQL on Code School.

Table of contents

Aggregate Functions
2 Videos • 5 Challenges
Constraints
2 Videos • 7 Challenges
Normalization & Relationships
2 Videos • 3 Challenges
Joins & Aliases
3 Videos • 6 Challenges
Subqueries
1 Video • 3 Challenges

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

Trending courses

STP and EtherChannel Operation and Configuration

STP and EtherChannel Operation and Configuration

by Ross Bagurdes
  • 2h 46m Duration
  • Intermediate Skills Level
  • (17)
Automating Cisco Meraki Operations Using APIs

Automating Cisco Meraki Operations Using APIs

by Nick Russo
  • 1h 28m Duration
  • Intermediate Skills Level
  • (12)
TCP and UDP Operation

TCP and UDP Operation

by Ross Bagurdes
  • 2h 1m Duration
  • Intermediate Skills Level
  • (20)
Automating Cisco DNA Center Operations Using APIs

Automating Cisco DNA Center Operations Using APIs

by Nick Russo
  • 1h 24m Duration
  • Intermediate Skills Level
  • (13)
Earning and Retaining Your PMP® Certification

Earning and Retaining Your PMP® Certification

by Casey Ayers
  • 2h 4m Duration
  • Beginner Skills Level
  • (26)
Cisco Enterprise Networks: Basic Networking and IP Fundamentals

Cisco Enterprise Networks: Basic Networking and IP Fundamentals

by Ben Piper
  • 1h 45m Duration
  • Intermediate Skills Level
  • (66)
Managing Software in Linux with Debian Software Management

Managing Software in Linux with Debian Software Management

by Andrew Mallett
  • 1h 58m Duration
  • Beginner Skills Level
  • (23)
Expanded
Information Systems Auditor: Operations, Maintenance, and Service

Information Systems Auditor: Operations, Maintenance, and Service

by Kevin Henry
  • 3h 6m Duration
  • Intermediate Skills Level
  • (12)
SCCM Current Branch: Deploy Clients and Manage Inventory

SCCM Current Branch: Deploy Clients and Manage Inventory

by Greg Shields
  • 3h 15m Duration
  • Intermediate Skills Level
  • (27)
Expanded
Network Interface Layer and Ethernet Operation for Cisco CCNA 200-125/100-105

Network Interface Layer and Ethernet Operation for Cisco CCNA 200-125/100-105

by Ross Bagurdes
  • 3h 5m Duration
  • Intermediate Skills Level
  • (53)
Ready to upskill? Get started