Data Analytics
280 learners
Learning SQL Joins with PostgreSQL
Dive into the world of SQL Joins powered by PostgreSQL's robust capabilities. This course is designed to expand your data analysis skills by exploring the concept of table joins. With PostgreSQL's comprehensive join support as your backdrop, learn how to uncover intricate relationships within a database. This course blends the power of PostgreSQL with the thrill of data discovery.
PostgreSQL
See path
5 lessons
25 practices
2 hours
Badge for Data Querying and Retrieval,
Data Querying and Retrieval
Lessons and practices
Lesson 1: Joining Tables - SQL JOINs with PostgreSQL
Inner Join Application in SQL
Movie Characters with Inner Join
Fix the SQL Join Query
Joining Movies and Characters
Movie Box Office Sales
Lesson 2: Exploring INNER JOIN
Joining Movie Tables
Sorting Movies by Ratings
Fix the SQL Query
Join Tables and Fetch Results
Mastering SQL Inner Join Queries
Lesson 3: Diving into LEFT JOIN and RIGHT JOIN
Mastering Left Join Basics
Using RIGHT JOIN in SQL
Fix SQL Query Bug
Mastering JOIN in SQL
Mastering Movie Box Office Queries
Lesson 4: Completing the Picture - FULL JOIN Mastery
Full Joins to See It All
Finding Marvel Captains
Full Join Bug Hunt
Filter Avengers Movies
Advanced Table Join Query
Lesson 5: Joining Multiple Tables
Joining Multiple Movie Tables
Multiple Tables Join Challenge
Multiple Table Joins Fix
Joining Movie Tables with SQL
Master Multiple Table Joins
Meet Cosmo:
The smartest AI guide in the universe
Our built-in AI guide and tutor, Cosmo, prompts you with challenges that are built just for you and unblocks you when you get stuck.
Sign up
Join the 1M+ learners on CodeSignal
Be a part of our community of 1M+ users who develop and demonstrate their skills on CodeSignal