SQL JOINS Masterclass: Learn to join 2 to 15 Tables

Name: SQL JOINS Masterclass: Learn to join 2 to 15 Tables
Rating: 4.1 (55 reviews)

Learn SQL Joins from scratch. Join 2, 3, 4, 5, 6, 7, 8, 9... and several tables! Become a true SQL Expert!

Created byDonatus Obomighie

Last updated 6/2024

English

What you'll learn

Learn to join 1 to 15 tables using SQL
Understand advanced and complex SQL Join
Create compelling report using SQL
Advance your data analytics skill
Learn from expert with many exercises and solutions

Course content

5 sections • 296 lectures • 5h 10m total length

Course Content Walkthrough2:57
Demo Lecture - 1 (A Sample of what to expect)2:39
Demo Lecture - 1 Code0:22
Demo Lecture - 2 (A Sample of what to expect)2:52
Demo Lecture - 2 Code0:27
Resource - Creating Databases and Inserting Data7:27
Resource - AB Database - Create & Insert0:03
Resource - PersonCash Database - Create & Insert0:03
Resource - Northwind Database - Create0:03
Resource - Northwind Database - Insert0:03
Resource - DVD Rental Database - Create0:03
Resource - DVD Rental Database - Insert0:03
Select - All columns0:59
Select - All columns - Code
Select - Few Columns1:01
Select a few columns—first name, last name, address, and country—from employees, and arrange their order for output.
Select - Few Columns - Code0:01
Select - Old Price and New Price2:00
Select - Old Price and New Price - Code0:02
Select - Report with Comment1:51
Explore selecting multiple columns from the customers table to build a report with a comment column, using aliases to clearly label each field.
Select - Report with Comment - Code0:01
Select - Distinct1:07
Select - Distinct - Code0:01
Alias - SQL Alias2:21
Alias - SQL Alias - Code0:02
Reporting with Concatenation - Title and First Name2:19
Reporting with Concatenation - Title and First Name - Code0:04
Reporting with Concatenation - Customer and Location1:25
Reporting with Concatenation - Customer and Location - Code0:04
Reporting with Concatenation - Customer and Location II0:40
Reporting with Concatenation - Customer and Location II - Code0:02
Reporting with Concatenation - Total Value of Products In Stock1:53
Reporting with Concatenation - Total Value of Products In Stock - Code0:04
Report Formatting - Introduction3:25
Report Formatting - Understanding Format Exercise & Solution 12:10
Report Formatting - Understanding Format Exercise & Solution 1 - Code0:06
Report Formatting - Understanding Format Exercise & Solution 21:28
Report Formatting - Understanding Format Exercise & Solution 2 - Code0:01
Report Formatting - Understanding Format Exercise & Solution 31:05
Apply sql joins masterclass concepts to formatting by displaying employees' last names in a single column, using the format method instead of concatenation on the employees table.
Report Formatting - Understanding Format Exercise & Solution 3 - code0:01
Report Formatting - Understanding Format Exercise & Solution 40:49
Report Formatting - Understanding Format Exercise & Solution 4 - Code0:02
Report Formatting - Understanding Format Exercise & Solution 50:36
Report Formatting - Understanding Format Exercise & Solution 5 - Code0:02
Report Formatting - Understanding Format Exercise & Solution 61:47
Report Formatting - Understanding Format Exercise & Solution 6 - Code0:19
Round - Amount Formatting Exercise & Solution 10:54
Round - Amount Formatting Exercise & Solution 1 - Code0:01
Round - Amount Formatting Exercise & Solution 20:56
Round - Amount Formatting Exercise & Solution 2 - Code0:01
Round - Amount Formatting Exercise & Solution 30:37
Round - Amount Formatting Exercise & Solution 3 - Code0:01
Round - Amount Formatting Exercise & Solution 42:10
Round - Amount Formatting Exercise & Solution 4 - Code0:03
Order By - Ascending Exercise & Solution 11:24
Order By - Ascending Exercise & Solution 1 - Code0:01
Order By - Ascending and Descending Exercise & Solution 21:34
Order By - Ascending and Descending Exercise & Solution 2 - Code0:02
Order By - Ascending and Ascending Exercise & Solution 30:48
Order By - Ascending and Ascending Exercise & Solution 3 - Code0:01
Where - Sales Managers' Details0:53
Where - Sales Managers' Details - Code0:01
Where - Owners' Details1:50
Where - Owners' Details - Code0:02
Where - Specific Order ID0:46
Where - Specific Order ID - Code0:01
Where - Searching for a Product with Price0:53
Where - Searching for a Product with Price - Code0:01
Where - Searching for a Product with Price II0:53
Where - Searching for a Product with Price II - Code0:01
Where - Searching for a Customer with ID0:39
Where - Searching for a Customer with ID - Code0:01
Where - Products above 32.81:24
Where - Products above 32.8 - Code0:02
Where - Products less than 100:42
Where - Products less than 10 - Code0:02
Where - Products whose price are 40 and above0:26
Where - Products whose price are 40 and above - Code0:02
Where - Products within a range1:25
Where - Products within a range - Code0:02
Where - Products - Restocking1:56
Where - Products - Restocking - Code0:02
Where - Order amount of 10540 or above1:14
Where - Order amount of 10540 or above - Code0:04
Where - None Mr2:25
Where - None Mr - Code0:04
Where - None Sales Representative1:27
Where - None Sales Representative - Code0:04
Where - Price Between two figures1:26
Learn to filter products by unit price using the between operator for values 18 to 19, and compare with greater than or equal to and less than or equal to.
Where - Price Between two figures - Code0:05
Where - Not Between0:37
Where - Not Between - Code0:03
Where - Two Between1:23
Where - Two Between - Code0:04
Where - Customers from certain cities1:01
Where - Customers from certain cities - Code0:02
Where - Every other customers except0:55
Where - Every other customers except - Code0:02
Where - Customers From France1:21
Use a where clause to identify customers from France by city, highlighting Lyon and other cities across countries, and understand how country and city data shape results.
Where - Customers From France - Code0:02
Where - Sales Manager & Vice President Details1:23
Explore querying employee data to retrieve sales manager or vice president details using a where clause with or logic, and why some role combinations return no results.
Where - Sales Manager & Vice President Details - Code0:02
Where - Names of certain products with given prices0:42
Where - Names of certain products with given prices - Code0:02
Where - Searching for a product given certain details1:19
Where - Searching for a product given certain details - Code0:02
Where - Searching for employee given certain details0:47
Where - Searching for employee given certain details - Code0:05
Where - Null Region0:47
Where - Null Region - Code0:02
Where - Not Null Region0:25
Filter customers by country using the where clause, focusing on UK and not null region constraints, as part of the SQL joins masterclass.
Where - Not Null Region - Code0:02
Wildcard - Contains "Sales"1:38
Wildcard - Phone number starts with 1710:54
Explore how to use a wildcard to filter phone numbers that start with 171 in a customers table, leveraging SQL joins and the like operator to select relevant rows.
Wildcard - Phone number starts with 171 - Code0:01
Wildcard - Contact ends with...1:01
Wildcard - Contact ends with... - Code0:01
Wildcard - Searching with letter1:00
Wildcard - Searching with letter - Code0:01
Wildcard - Searching for a company0:30
Wildcard - Searching for a company - Code0:01
Wildcard - Searching for a city0:27
Search for a city using wildcard queries to retrieve customer details across joined tables. Explore using the city column to filter results and understand joining logic.
Wildcard - Searching for a city - Code0:01
Wildcard - Searching for a city with starting and end letters0:33
Wildcard - Searching for a city with starting and end letters - Code0:01
Wildcard - NOT1:01
Explore filtering with wildcard patterns to identify company names that do not start with specific letters, using not operators to refine results.
Wildcard - NOT - Code0:02
Aggregate - Introduction0:49
Aggregate - Min()0:36
Aggregate - Min() - Code0:01
Aggregate - Min() - First Shipment1:10
Use aggregate min() with joins to determine the first shipment date by combining related tables, retrieving the earliest ship date such as 1996-07-10.
Aggregate - Min() - First Shipment - Code0:01
Aggregate - Max()0:23
Aggregate - Max() - Code0:01
Aggregate - Count()0:52
Learn to count the number of products using the aggregate count() on the products table. Use the unique product ID to avoid duplicates and run a basic select query.
Aggregate - Count() - Code
Aggregate - Count() - Number of Orders1:05
Aggregate - Count() - Number of Orders- Code0:02
Aggregate - Avg()0:30
Aggregate - Avg() - Code
Aggregate - Avg() - Purchase0:36
Aggregate - Avg() - Purchase - Code0:01
Aggregate - Sum()0:41
Master the sum() aggregate to compute the total stock across the products table. Learn how to tally the overall quantity of products in stock and understand per-product versus all-products totals.
Aggregate - Sum() - Code
Aggregate - Sum() - Total number of stock0:52
Aggregate - Sum() - Total number of stock - Code
Aggregate - SUM() - Total Sales1:13
Aggregate - SUM() - Total Sales - Code0:02
Aggregate - ARRAY_AGG()1:05
Aggregate - ARRAY_AGG() - Code0:01
Aggregate - STRING_AGG() - List of Customers1:39
Aggregate - STRING_AGG() - List of Customers - Code0:01
Aggregate - ARRAY_AGG() - Customer Names0:20
Aggregate - ARRAY_AGG() - Customer Names - Code
Understanding Limit, Fetch and Offset1:38
Limit - First Row1:01
Limit - First Row - Code0:02
Limit - First Three Rows0:46
Limit - First Three Rows - Code0:02
Offset & Limit - Third to Fifth Rows0:54
Offset & Limit - Third to Fifth Rows - Code0:03
Offset & Limit - The Most Expensive Product3:40
Offset & Limit - The Most Expensive Product - Code0:04
Offset & Limit - Productivity6:51
Offset & Limit - Productivity - Code0:18

Basics - Introduction to Join - Purpose of Join1:28
Basics - Type of Join0:27
Explore the basics of SQL joins by examining cross join, left outer join, right outer join, and full join, and understand how each type combines tables.
Basics - Cross Join5:34
Basics - Cross Join Code0:02
Basics - Inner Join5:18
Basics - Inner Join Code0:04
Basics - Left Join7:10
Basics - Left Join Code0:04
Basics - Right Join2:59
Basics - Right Join Code0:04
Basics - Full Outer Join4:32
Basics - Full Outer Join Code0:06
Basics - Natural Join3:18
Basics - Natural Join Code0:04
Basics - Self Join5:30
Basics - Self Join Code0:09
Intermediate - How to choose the right column for the JOIN8:36
Intermediate - How to choose the right column for the JOIN - Exercise4:48
Intermediate - How to choose the right column for the JOIN - Exercise - Code0:04
Intermediate - Understanding "USING"0:32
Intermediate - Understanding "USING" - Code0:04
Intermediate - Understanding Alias in JOIN2:19
Intermediate - Understanding Alias in JOIN - Code0:05
Intermediate - ON and WHERE2:02
Intermediate - ON and WHERE - Code0:13
Intermediate - Joining Many Tables6:10
Intermediate - Hits on Joining Many Tables11:33
Learn how to join 2 to 15 tables, such as supply, product, and supplier, using the linking supplier id, and navigate the floor of the join for efficient queries.
Intermediate - Hits on Joining Many Tables - Code0:20
Group By With Single Table - A requirement for further lesson1:37
Group By With Single Table - A requirement for further lesson - Code0:02
Group By With Two Tables - A requirement for further lesson2:19
Group By With Two Tables - A requirement for further lesson - Code0:04
Pro - Two Tables - The Second to The Cheapest Product2:34
Pro - Two Tables - The Second to The Cheapest Product - Code0:06
Pro - Two Tables - Better Report1:07
Pro - Two Tables - Better Report - Code0:06
Pro - Two Tables - Number of Orders Per Employee4:35
Pro - Two Tables - Number of Orders Per Employee - Code0:05
Pro - Two Tables - Number of Shipment Per Each Shipping Company3:04
Learn to count shipments per shipping company by joining two tables: the shippers and orders on shipper id, and aggregate to show each company's shipment total.
Pro - Two Tables - Number of Shipment Per Each Shipping Company - Code0:05
Pro - Two Tables - Number of Shipment 19981:36
Join two tables to count shipments delivered in 1998 by filtering on the ship date.
Pro - Two Tables - Number of Shipment 1998 - Code0:04
Pro - Two Tables - Shipment to Countries2:24
Join orders and customers to count shipments per country, then group by ship country and customer name and sort by shipments and country.
Pro - Two Tables - Shipment to Countries - Code0:05
Pro - Two Tables - Territories Per Region2:56
Pro - Two Tables - Territories Per Region - code0:04
Pro - Two Tables - Territories to Employees2:20
learn to join two tables, territories and employees, on the common territory id, return employee ids for each territory, and use distinct and group by to remove duplicates.
Pro - Two Tables - Territories to Employees - Code0:04
Pro - Territory per Employee3:01
Master SQL joins across 2 to 15 tables to map each employee to their territory, using employee id or full name, and group results with aggregates.
Pro - Territory per Employee - Code0:06
Pro - Categories per Products per Supplier3:24
Master the art of joining 2 to 15 tables: link suppliers, products, and categories to show how many categories each supplier offers, with company names, grouped by supplier.
Pro - Categories per Products per Supplier - Code0:07
Pro - Most Purchased Product7:19
Dive into SQL joins masterclass by counting orders to identify the most purchased product, then join product and category tables to show names and categories.
Pro - Most Purchased Product - Code0:17
Pro - Revenue from each Customer3:36
Pro - Revenue from each Customer - Code0:09
Pro - Revenue from each Customer June 1991:04
Compute revenue per customer for June 1997 using data from the order table, filtering to that month and aggregating totals.
Pro - Revenue from each Customer June 1997 - Code0:10
Pro - Revenue from each Customer in 19960:34
Pro - Revenue from each Customer in 1996 - Code0:10
Pro - List of Products Purchased by Each Customer - Four Tables6:13
Pro - List of Products Purchased by Each Customer - Four Tables - Code0:07
Pro - List of Products Purchased by a Specific Customer in a year- Four Tables1:24
Pro - List of Products Purchased by a Specific Customer in a year- Code0:09
Pro - List of Products Purchased by a Specific Customer - Four Tables1:23
Pro - List of Products Purchased by a Specific Customer - Four Tables - Code0:08
Pro - Searching for a customer with given details - Four tables6:29
Pro - Searching for a customer with given details - Four tables - Code0:15
Pro - Report Involving Five Tables3:10
Join five tables: customers, orders, order details, products, and employees. Apply concatenation, aggregates, and group by to display product names, customer and employee details, order totals.
Pro - Report Involving Five Tables - Code0:14
Pro - Reports on Delayed orders2:26
Pro - Reports on Delayed orders - Code0:14
Pro - Reports on Delayed orders with CASE3:40
Learn to generate reports on delayed orders with case statements in sql, add a point-of-action column, and define actions for delays from 10 to 40 days.
Pro - Reports on Delayed orders with CASE - Code0:22
Understanding the Movie Rental Schema4:53
Please find attached the Schema and the skeletal diagram of the schema. Download and unzip
Pro - 15 Tables Joins6:45
Pro - 15 Tables Joins - Code0:32
Pro - Actors and Movies1:04
Pro - Actors and Movies - Code0:04
Pro - Actors and Movies listed1:13
Pro - Actors and Movies listed - Code0:05
Pro - List of Actors in Each Movie0:57
Pro - List of Actors in Each Movie - Code0:05
Pro - List of Actors in Each Movie & Category0:56
Pro - List of Actors in Each Movie & Category - Code0:09
Pro - Number of Actors Per Movie0:53
Pro - Number of Actors Per Movie - Coce0:10
Pro - Number of Movies Each Actor Acted In0:39
Join multiple tables to count how many movies each actor acted in, using group by and count to attach movie titles to actors.
Pro - Number of Movies Each Actor Acted In - Code0:07
Pro - Actor with the highest number of appearance in movies - Code0:32
Pro - Actor with the highest number of appearance in movies - Code0:07
Pro - First 10 lowest appearance2:16
Pro - First 10 lowest appearance - Code0:15
Pro - History of Rental1:01
Pro - History of Rental - Code0:08
Pro - Revenues1:35
Pro - Revenues - Code0:10

Exercise 1 - employee performance report0:58
Exercise 1 - Code0:17
Exercise 2 - employee performance report II1:00
Generate an employee performance report showing full name, title, revenue with proper dollar formatting, and a list of product categories by month using SQL joins.
Exercise 2 - Code0:16
Exercise 3 - Customers per employee report0:40
Exercise 3 - Code0:09
Exercise 4 - Suppliers and shipper per employee report1:04
Exercise 4 - Code0:12
Exercise 5 - Employees' regions report0:43
Generate a regions report to show the region each employee is assigned to. Observe how removing duplicates affects the regional data and reduces repeated entries.
Exercise 5 - Code0:08
Exercise 6 - Employees' regions report II0:56
Exercise 6 - Code0:08
Exercise 7 - Employee - Region - Customers report0:42
Exercise 7 - Code0:11
Exercise 8 - Orders report0:42
Exercise 9 - Code0:12
Exercise 9 - Orders with the products suppliers1:21
Learn to build a detailed report linking orders with products and suppliers, creating descriptive columns that concatenate product, supplier, and price, while including customer and employee details.
Exercise 9 - Code0:15
Exercise 10 - Orders with the products suppliers II0:54
Exercise 10 - Code0:17

Understanding Intersect1:09
Explore how intersect combines results from two query sets into a single output, highlighting common elements such as 7, 11, and 22.
Understanding Intersect - Code0:01
What is Union0:46
Union - Exercise 11:37
Union - Exercise 1 - Code0:02
Union - Exercise 20:55
Union - Exercise 2 - Code0:02
Union - Exercise 31:52
Union - Exercise 3 - Code0:05
Union - Exercise 41:40
Explore union techniques to pull names from phone numbers across suppliers, customers, and external stakeholders, then group and customize reports with their contact details.
Union - Exercise 4 - Code0:06
Understanding Except2:53
Except - Exercise0:44
Explore the except exercise in SQL joins to determine how results differ when comparing two datasets, identifying what is returned and what is not when reversing the order.
Except - Exercise - CODE0:01

Requirements

Basic SQL knowledge

Description

SQL is a powerful tool for data storage. The ability to analyze the data is a great skill to acquire. What is greater is your ability to use complex SQL queries to fetch out information from multiple tables. That is what this course is all about. In this course, you are going to be acquitted with advanced SQL skills to join multiple tables together and write better reports. This course is going to make Data Analysis (using PostgreSQL) easy for your career advancement.

Everything you will ever need in SQL JOIN for data analytics is covered in this course. This includes but is not limited to:

Types of Join
Cross Join
Inner Join
Left Join
Right Join
Full Join
Natural Join
Self Join
Intersect
Union
Except

To understand the above and work seamlessly with JOIN the following were first introduced:

Select
Select Distinct
Concat
Format
Where
Wildcard
Aggregate
Limit
Fetch
Offset
and many more

This course will take to perform join within a single table and joining multiple tables. At the end of this course, you will be able to join any number of tables at a go!

WHY THIS COURSE?

This course is not rushed over.
It starts from the very basics of SQL Join to advanced multiple table join
This course is taught by an active data scientist with several years of experience
This course is taught by examples with several exercises and solutions
You will not only know the theory but learn to build your own report using SQL
All the students taught by the instructor have moved higher in their careers
No question asked by students is not answered within 48 hours. There is no too simple question or too hard question. All questions are taken very seriously by the instructor

You don't need to take my words for it. See what existing students have to say about my courses:

"This is a great course! It is deep. The instructor didn't leave any stone unturned. It gave me a better understanding of the more advanced concept. Above all, I love the style of teaching with challenges and solutions." - Paul Min

"It's been an amazing time having to learn and understand how python works." - Ana Gil

"Well explained and easy to understand. This is indeed commendable and I appreciate your efforts." - Joanita Anderson

You can check the comment sections of all my courses and see for yourself.

I am not only confident you will love this course, but I am also confident you will spread the love to others. Hence, we are offering you 30 days' FULL money-back. What are you waiting for? Click Buy now and let's get started.

WHO IS THIS COURSE FOR?

Database administrator
Developers
Data Scientist
Programmer
Those with interest in SQL and Data analytics

By the end of this course, you will be very fluent in SQL queries, confident in facing any complex schema and write great reports.

Who this course is for:

Anyone who aspire to advanced in data analytics using SQL

SQL JOINS Masterclass: Learn to join 2 to 15 Tables

What you'll learn

Explore related topics

Course content

Pre - SQL Join Lectures164 lectures • 1hr 58min

SQL Join: From 1 Table to 15 Tables Joins97 lectures • 2hr 50min

Do It Yourself - More Challenges & Solutions20 lectures • 11min

Extra Lectures: Intersect, Union & Except14 lectures • 12min

Bonus Section1 lecture • 1min

Requirements

Description

Who this course is for: