Understand Joins and Unions in Postgres
|
Master your Postgres tables and unlock the power to answer complex questions. Learn joins, unions, and more in this comprehensive course.
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.
Course Content
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
User Reviews
Be the first to review “Understand Joins and Unions in Postgres”
You must be logged in to post a review.
There are no reviews yet.