Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

egghead.io

Understand Joins and Unions in Postgres

via egghead.io

Overview

You know the basics of Postgres, but most meaningful queries will require you to combine tables in novel ways to ask questions you couldn't ask with a single table alone. Joins and unions come up over and over again in interview questions -- because of how fundamental they are. This course will make you a master of your tables, and give you the power to answer questions you couldn't before.

Syllabus

  • Find Postgres Data That Doesn’t Match Join Conditions with Full Outer Join
  • Find Lonely Postgres Data with Left and Right Join
  • Detect Duplicates in Postgres with Cartesian Product
  • Find Related Data with Inner Join in Postgres
  • See All Rows from Different Postgres Tables with Union All
  • Join Tables in Postgres with Complex Conditions
  • Create a History Table in Postgres with Joins
  • Use Joins to Detect Orphaned Data in Postgres

Taught by

Brett Cassette

Reviews

4.4 rating at egghead.io based on 42 ratings

Start your review of Understand Joins and Unions in Postgres

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.