MJ AcademyStream Masterclass

Roadmaps & Blog Browse Library Explore Courses

Databases & Data EngineeringUdemy2023-12 Edition100% Free Video Course

SQL JOINS Masterclass: Learn to join 2 to 15 Tables – 2024

SQL JOINS Masterclass: Learn to join 2 to 15 Tables – 2024 is a JOIN command training course in Sqval (SQL) published by Udemy Online Academy. SQL JOIN is used to combine rows from two or more tables based on the related column between them. There are different types of JOIN operations, each serving a different purpose. SQL is a powerful tool for data storage. In this course, you’ll use advanced SQL skills to join multiple tables and write better reports. This course is going to make data analysis easy for you to advance your career. This tutorial covers everything you need to know about SQL JOINs for data analysis.During this training course, you will not only be exposed to educational videos that teach you the theory of topics, but you will also be exposed to various types of exercises that will help you gain a high level of knowledge and practical experience. do. This course is recommended for database administrators, developers, data scientists, programmers, and those interested in SQL and data analysis. After completing this training course, you will have high knowledge and skills about the JOIN command in SQL.

151 Video Lessons

•

15.2 Hours On-Demand

Created by Senior Industry Specialist

Uploaded Sep 2026

English

SQL JOINS Masterclass: Learn to join 2 to 15 Tables – 2024

Preview This Course

Free$129.99100% Free

Instant high-definition streaming with zero paywalls.

Start Learning Now Download Course Videos (Free)

Course Features:

15.2 hours on-demand video

151 complete lectures

1 downloadable project zip file(s)

Streamable on mobile, tablet & desktop

Self-paced curriculum with progress tracking

Direct MP4 downloads & offline video access

Verified course archives hosted on cloud infrastructure.

What You'll Master in this Course

Familiarity with advanced and complex SQL Join

Creating a compelling report using SQL

Improving data analysis skills

And …

Course Curriculum151 Lectures

4 sections • 15.2 hours total length

Prefer offline learning? Download all 151 video lectures and project files 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

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

Requirements

Basic enthusiasm to learn and follow along with lessons
A computer or mobile device with a modern internet connection

Description

SQL JOINS Masterclass: Learn to join 2 to 15 Tables – 2024 is a JOIN command training course in Sqval (SQL) published by Udemy Online Academy. SQL JOIN is used to combine rows from two or more tables based on the related column between them. There are different types of JOIN operations, each serving a different purpose. SQL is a powerful tool for data storage. In this course, you’ll use advanced SQL skills to join multiple tables and write better reports. This course is going to make data analysis easy for you to advance your career. This tutorial covers everything you need to know about SQL JOINs for data analysis.During this training course, you will not only be exposed to educational videos that teach you the theory of topics, but you will also be exposed to various types of exercises that will help you gain a high level of knowledge and practical experience. do. This course is recommended for database administrators, developers, data scientists, programmers, and those interested in SQL and data analysis. After completing this training course, you will have high knowledge and skills about the JOIN command in SQL.

Instructor

S

Senior Industry Specialist

Specialist in Databases & Data Engineering

Passionate educator focused on real-world practical skills, modern frameworks, and production-ready engineering practices. Delivering step-by-step masterclasses accessible to learners globally on MJ Accedemy.

SQL JOINS Masterclass: Learn to join 2 to 15 Tables – 2024

Preview This Course

Free$129.99100% Free

Instant high-definition streaming with zero paywalls.

Start Learning Now Download Course Videos (Free)

Course Features:

15.2 hours on-demand video

151 complete lectures

1 downloadable project zip file(s)

Streamable on mobile, tablet & desktop

Self-paced curriculum with progress tracking

Direct MP4 downloads & offline video access

Verified course archives hosted on cloud infrastructure.

Recommended Curriculum

Students Also Viewed

Databases & Data EngineeringUdemy

SQL–MySQL Complete Master Bootcamp | Beginner-Expert (2024)

Industry Specialist

HD StreamAll Levels

Databases & Data EngineeringUdemy

2022-10 Edition

101 Practice SQL Questions: Basic to Advanced

Industry Specialist

HD StreamAll Levels

Databases & Data EngineeringUdemy

Master Apache Spark using Spark SQL and PySpark 3

Industry Specialist

Databases & Data EngineeringUdemy

2025 Mastering dbt (Data Build Tool) – From Beginner to Pro

Industry Specialist

HD StreamAll Levels