Understand Joins and Unions in Postgres

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.

• 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