Download SQL JOINS Masterclass: Learn to join 2 to 15 Tables – 2024 Course for Free

Select - All columns

Select - Few Columns

Demo Lecture - 2

Course Content Walkthrough

Demo Lecture - 1

Resource - Creating Databases and Inserting Data

Select - Old Price and New Price

Select - Distinct

Select - Report with Comment

Alias - SQL Alias

Reporting with Concatenation - Title and First Name

Reporting with Concatenation - Customer and Location

Reporting with Concatenation - Customer and Location II

Reporting with Concatenation - Total Value of Products In Stock

Report Formatting - Introduction

Report Formatting - Understanding Format Exercise & Solution 1

Report Formatting - Understanding Format Exercise & Solution 2

Report Formatting - Understanding Format Exercise & Solution 3

Report Formatting - Understanding Format Exercise & Solution 4

Report Formatting - Understanding Format Exercise & Solution 5

Report Formatting - Understanding Format Exercise & Solution 6

Round - Amount Formatting Exercise & Solution 1

Round - Amount Formatting Exercise & Solution 2

Round - Amount Formatting Exercise & Solution 3

Order By - Ascending Exercise & Solution 1

Round - Amount Formatting Exercise & Solution 4

Order By - Ascending and Ascending Exercise & Solution 3

Order By - Ascending and Descending Exercise & Solution 2

Where - Sales Managers' Details

Where - Owners' Details

Where - Searching for a Product with Price

Where - Specific Order ID

Where - Searching for a Product with Price II

Where - Searching for a Customer with ID

Where - Products less than 10

Where - Products above 32.8

Where - Products whose price are 40 and above

Where - Products within a range

Where - Order amount of 10540 or above

Where - Products - Restocking

Where - None Sales Representative

Where - None Mr

Where - Price Between two figures

Where - Not Between

Where - Customers from certain cities

Where - Two Between

Where - Names of certain products with given prices

Where - Every other customers except

Where - Sales Manager & Vice President Details

Where - Customers From France

Where - Searching for a product given certain details

Where - Searching for employee given certain details

Where - Not Null Region

Where - Null Region

Wildcard - Contains Sales

Wildcard - Phone number starts with 171

Wildcard - Contact ends with...

Wildcard - Searching with letter

Wildcard - Searching for a company

Wildcard - Searching for a city with starting and end letters

Wildcard - Searching for a city

Wildcard - NOT

Aggregate - Introduction

Aggregate - Min()

Aggregate - Min() - First Shipment

Aggregate - Count()

Aggregate - Max()

Aggregate - Count() - Number of Orders

Aggregate - Avg()

Aggregate - Avg() - Purchase

Aggregate - SUM() - Total Sales

Aggregate - Sum()

Aggregate - Sum() - Total number of stock

Aggregate - ARRAY AGG() - Customer Names

Aggregate - STRING AGG() - List of Customers

Aggregate - ARRAY AGG()

Understanding Limit, Fetch and Offset

Limit - First Row

Limit - First Three Rows

Offset & Limit - Third to Fifth Rows

Offset & Limit - The Most Expensive Product

Offset & Limit - Productivity

Basics - Type of Join

Basics - Introduction to Join - Purpose of Join

Basics - Cross Join

Basics - Inner Join

Basics - Left Join

Basics - Right Join

Basics - Full Outer Join

Basics - Self Join

Basics - Natural Join

Intermediate - How to choose the right column for the JOIN - Exercise

Intermediate - Understanding USING

Intermediate - Understanding Alias in JOIN

Intermediate - ON and WHERE

Intermediate - Joining Many Tables

Intermediate - How to choose the right column for the JOIN

Group By With Single Table - A requirement for further lesson

Group By With Two Tables - A requirement for further lesson

Pro - Two Tables - The Second to The Cheapest Product

Pro - Two Tables - Better Report

Intermediate - Hits on Joining Many Tables

Pro - Two Tables - Number of Orders Per Employee

Pro - Two Tables - Number of Shipment 1998

Pro - Two Tables - Number of Shipment Per Each Shipping Company

Pro - Two Tables - Shipment to Countries

Pro - Two Tables - Territories to Employees

Pro - Categories per Products per Supplier

Pro - Two Tables - Territories Per Region

Pro - Territory per Employee

Pro - Most Purchased Product

Pro - Revenue from each Customer

Pro - Revenue from each Customer in 1996

Pro - Revenue from each Customer June 199

Pro - List of Products Purchased by a Specific Customer in a year- Four Tables

Pro - List of Products Purchased by a Specific Customer - Four Tables

Pro - List of Products Purchased by Each Customer - Four Tables

Pro - Searching for a customer with given details - Four tables

Pro - Reports on Delayed orders

Pro - Report Involving Five Tables

Understanding the Movie Rental Schema

Pro - Reports on Delayed orders with CASE

Pro - Actors and Movies

Pro - 15 Tables Joins

Pro - Actors and Movies listed

Pro - List of Actors in Each Movie

Pro - Number of Actors Per Movie

Pro - Actor with the highest number of appearance in movies - Code

Pro - List of Actors in Each Movie & Category

Pro - First 10 lowest appearance

Pro - History of Rental

Pro - Number of Movies Each Actor Acted In

Pro - Revenues

Exercise 1 - employee performance report

Exercise 2 - employee performance report II

Exercise 3 - Customers per employee report

Exercise 4 - Suppliers and shipper per employee report

Exercise 5 - Employees' regions report

Exercise 6 - Employees' regions report II

Exercise 7 - Employee - Region - Customers report

Exercise 8 - Orders report

Exercise 10 - Orders with the products suppliers II

Exercise 9 - Orders with the products suppliers

Understanding Intersect

What is Union

Union - Exercise 2

Union - Exercise 4

Union - Exercise 3

Understanding Except

Union - Exercise 1

Except - Exercise