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

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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 Postgres Data That Doesn’t Match Join Conditions with Full Outer Join
  • 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
  • Find Lonely Postgres Data with Left and Right Join
  • Find Lonely Postgres Data with Left and Right Join
  • Detect Duplicates in Postgres with Cartesian Product
  • Detect Duplicates in Postgres with Cartesian Product
  • Find Related Data with Inner Join in Postgres
  • Find Related Data with Inner Join in Postgres
  • See All Rows from Different Postgres Tables with Union All
  • See All Rows from Different Postgres Tables with Union All
  • Join Tables in Postgres with Complex Conditions
  • Join Tables in Postgres with Complex Conditions
  • Create a History Table in Postgres with Joins
  • Create a History Table in Postgres with Joins
  • Use Joins to Detect Orphaned Data in Postgres
  • Use Joins to Detect Orphaned Data in Postgres

Taught by

Brett Cassette

Reviews

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.