Skip to main content

Courses About Pricing Educators

Sign in Get started

Courses About Pricing Educators

Get started Sign in

Loading courses

Loading lessons

Working Across Tables: PostgreSQL: Uncharted

Courses PostgreSQLWorking Across Tables

Working Across Tables

Follow keys across normalized cafe tables with inner, outer, self, and junction-table joins.

PostgreSQL
Unit 5 of 12
11 lessons
102 min
240 XP

Every lesson is open. Sign in when you are ready to begin.

Sign in to start

Lessons

11 total

1One Table CracksRecognize an update anomaly caused by repeating one customer fact across rows.InteractiveConcept7 min20 XPOpen
2Keys That ConnectMatch foreign-key columns to the tables whose primary keys they reference.InteractiveConcept8 min20 XPOpen
3Your First JOINCombine orders with their matching customer rows using INNER JOIN.CodeConcept8 min20 XPOpen
4Join FluencyUse table aliases and qualified column names to remove ambiguity.CodeConcept8 min20 XPOpen
5Three Tables at OnceJoin orders through their line items to retrieve menu names and quantities.CodeConcept10 min20 XPOpen
6Rows Without PartnersPreserve every customer while attaching matching orders with LEFT JOIN.CodeConcept10 min20 XPOpen
7LEFT, RIGHT, FULLCompare which unmatched rows LEFT, RIGHT, and FULL joins preserve.CodeConcept12 min20 XPOpen
8Finding the MissingUse a LEFT JOIN and NULL test to find rows with no matching partner.CodeConcept8 min20 XPOpen
9Joining a Table to ItselfJoin staff rows to other staff rows through the manager relationship.CodeConcept9 min20 XPOpen
10Many-to-ManyFollow a junction table to find customers connected to a menu item.CodeConcept10 min20 XPOpen
11Joins Mastery CheckJoin four tables and aggregate customer orders while preserving customers with no orders.CodeMastery check12 min40 XPOpen

Counting and Summarizing Designing Schemas