Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Learning SQL Joins with PostgreSQL

Go to class Write review

Details

Provider

CodeSignal
Pricing

Free Certificate
Languages

English
Certificate

Certificate Available
Duration & workload

2 hours
Sessions

On-Demand
Level

Intermediate

Found in

Part of

Unlocking Data Insights with PostgreSQL

Overview

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.

Syllabus

Unit 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

Unit 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

Unit 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

Unit 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

Unit 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

Reviews

Start your review of Learning SQL Joins with PostgreSQL