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.
Overview
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