Sql Joins Masterclass™: Learn To Join 2 To 15 Tables - 2023

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

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

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 JoinCross JoinInner JoinLeft JoinRight JoinFull JoinNatural JoinSelf JoinIntersectUnionExceptTo understand the above and work seamlessly with JOIN the following were first introduced:SelectSelect DistinctConcat FormatWhereWildcardAggregateLimitFetchOffsetand many moreThis 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 joinThis course is taught by an active data scientist with several years of experienceThis course is taught by examples with several exercises and solutionsYou will not only know the theory but learn to build your own report using SQLAll the students taught by the instructor have moved higher in their careersNo 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 instructorYou 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 AndersonYou 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 administratorDevelopersData ScientistProgrammerThose with interest in SQL and Data analyticsBy the end of this course, you will be very fluent in SQL queries, confident in facing any complex schema and write great reports.

Overview

Section 1: Pre - SQL Join Lectures

Lecture 1 Course Content Walkthrough

Lecture 2 Demo Lecture - 1 (A Sample of what to expect)

Lecture 3 Demo Lecture - 1 Code

Lecture 4 Demo Lecture - 2 (A Sample of what to expect)

Lecture 5 Demo Lecture - 2 Code

Lecture 6 Resource - Creating Databases and Inserting Data

Lecture 7 Resource - AB Database - Create & Insert

Lecture 8 Resource - PersonCash Database - Create & Insert

Lecture 9 Resource - Northwind Database - Create

Lecture 10 Resource - Northwind Database - Insert

Lecture 11 Resource - DVD Rental Database - Create

Lecture 12 Resource - DVD Rental Database - Insert

Lecture 13 Select - All columns

Lecture 14 Select - All columns - Code

Lecture 15 Select - Few Columns

Lecture 16 Select - Few Columns - Code

Lecture 17 Select - Old Price and New Price

Lecture 18 Select - Old Price and New Price - Code

Lecture 19 Select - Report with Comment

Lecture 20 Select - Report with Comment - Code

Lecture 21 Select - Distinct

Lecture 22 Select - Distinct - Code

Lecture 23 Alias - SQL Alias

Lecture 24 Alias - SQL Alias - Code

Lecture 25 Reporting with Concatenation - Title and First Name

Lecture 26 Reporting with Concatenation - Title and First Name - Code

Lecture 27 Reporting with Concatenation - Customer and Location

Lecture 28 Reporting with Concatenation - Customer and Location - Code

Lecture 29 Reporting with Concatenation - Customer and Location II

Lecture 30 Reporting with Concatenation - Customer and Location II - Code

Lecture 31 Reporting with Concatenation - Total Value of Products In Stock

Lecture 32 Reporting with Concatenation - Total Value of Products In Stock - Code

Lecture 33 Report Formatting - Introduction

Lecture 34 Report Formatting - Understanding Format Exercise & Solution 1

Lecture 35 Report Formatting - Understanding Format Exercise & Solution 1 - Code

Lecture 36 Report Formatting - Understanding Format Exercise & Solution 2

Lecture 37 Report Formatting - Understanding Format Exercise & Solution 2 - Code

Lecture 38 Report Formatting - Understanding Format Exercise & Solution 3

Lecture 39 Report Formatting - Understanding Format Exercise & Solution 3 - code

Lecture 40 Report Formatting - Understanding Format Exercise & Solution 4

Lecture 41 Report Formatting - Understanding Format Exercise & Solution 4 - Code

Lecture 42 Report Formatting - Understanding Format Exercise & Solution 5

Lecture 43 Report Formatting - Understanding Format Exercise & Solution 5 - Code

Lecture 44 Report Formatting - Understanding Format Exercise & Solution 6

Lecture 45 Report Formatting - Understanding Format Exercise & Solution 6 - Code

Lecture 46 Round - Amount Formatting Exercise & Solution 1

Lecture 47 Round - Amount Formatting Exercise & Solution 1 - Code

Lecture 48 Round - Amount Formatting Exercise & Solution 2

Lecture 49 Round - Amount Formatting Exercise & Solution 2 - Code

Lecture 50 Round - Amount Formatting Exercise & Solution 3

Lecture 51 Round - Amount Formatting Exercise & Solution 3 - Code

Lecture 52 Round - Amount Formatting Exercise & Solution 4

Lecture 53 Round - Amount Formatting Exercise & Solution 4 - Code

Lecture 54 Order By - Ascending Exercise & Solution 1

Lecture 55 Order By - Ascending Exercise & Solution 1 - Code

Lecture 56 Order By - Ascending and Descending Exercise & Solution 2

Lecture 57 Order By - Ascending and Descending Exercise & Solution 2 - Code

Lecture 58 Order By - Ascending and Ascending Exercise & Solution 3

Lecture 59 Order By - Ascending and Ascending Exercise & Solution 3 - Code

Lecture 60 Where - Sales Managers' Details

Lecture 61 Where - Sales Managers' Details - Code

Lecture 62 Where - Owners' Details

Lecture 63 Where - Owners' Details - Code

Lecture 64 Where - Specific Order ID

Lecture 65 Where - Specific Order ID - Code

Lecture 66 Where - Searching for a Product with Price

Lecture 67 Where - Searching for a Product with Price - Code

Lecture 68 Where - Searching for a Product with Price II

Lecture 69 Where - Searching for a Product with Price II - Code

Lecture 70 Where - Searching for a Customer with ID

Lecture 71 Where - Searching for a Customer with ID - Code

Lecture 72 Where - Products above 32.8

Lecture 73 Where - Products above 32.8 - Code

Lecture 74 Where - Products less than 10

Lecture 75 Where - Products less than 10 - Code

Lecture 76 Where - Products whose price are 40 and above

Lecture 77 Where - Products whose price are 40 and above - Code

Lecture 78 Where - Products within a range

Lecture 79 Where - Products within a range - Code

Lecture 80 Where - Products - Restocking

Lecture 81 Where - Products - Restocking - Code

Lecture 82 Where - Order amount of 10540 or above

Lecture 83 Where - Order amount of 10540 or above - Code

Lecture 84 Where - None Mr

Lecture 85 Where - None Mr - Code

Lecture 86 Where - None Sales Representative

Lecture 87 Where - None Sales Representative - Code

Lecture 88 Where - Price Between two figures

Lecture 89 Where - Price Between two figures - Code

Lecture 90 Where - Not Between

Lecture 91 Where - Not Between - Code

Lecture 92 Where - Two Between

Lecture 93 Where - Two Between - Code

Lecture 94 Where - Customers from certain cities

Lecture 95 Where - Customers from certain cities - Code

Lecture 96 Where - Every other customers except

Lecture 97 Where - Every other customers except - Code

Lecture 98 Where - Customers From France

Lecture 99 Where - Customers From France - Code

Lecture 100 Where - Sales Manager & Vice President Details

Lecture 101 Where - Sales Manager & Vice President Details - Code

Lecture 102 Where - Names of certain products with given prices

Lecture 103 Where - Names of certain products with given prices - Code

Lecture 104 Where - Searching for a product given certain details

Lecture 105 Where - Searching for a product given certain details - Code

Lecture 106 Where - Searching for employee given certain details

Lecture 107 Where - Searching for employee given certain details - Code

Lecture 108 Where - Null Region

Lecture 109 Where - Null Region - Code

Lecture 110 Where - Not Null Region

Lecture 111 Where - Not Null Region - Code

Lecture 112 Wildcard - Contains "Sales"

Lecture 113 Wildcard - Phone number starts with 171

Lecture 114 Wildcard - Phone number starts with 171 - Code

Lecture 115 Wildcard - Contact ends with…

Lecture 116 Wildcard - Contact ends with… - Code

Lecture 117 Wildcard - Searching with letter

Lecture 118 Wildcard - Searching with letter - Code

Lecture 119 Wildcard - Searching for a company

Lecture 120 Wildcard - Searching for a company - Code

Lecture 121 Wildcard - Searching for a city

Lecture 122 Wildcard - Searching for a city - Code

Lecture 123 Wildcard - Searching for a city with starting and end letters

Lecture 124 Wildcard - Searching for a city with starting and end letters - Code

Lecture 125 Wildcard - NOT

Lecture 126 Wildcard - NOT - Code

Lecture 127 Aggregate - Introduction

Lecture 128 Aggregate - Min()

Lecture 129 Aggregate - Min() - Code

Lecture 130 Aggregate - Min() - First Shipment

Lecture 131 Aggregate - Min() - First Shipment - Code

Lecture 132 Aggregate - Max()

Lecture 133 Aggregate - Max() - Code

Lecture 134 Aggregate - Count()

Lecture 135 Aggregate - Count() - Code

Lecture 136 Aggregate - Count() - Number of Orders

Lecture 137 Aggregate - Count() - Number of Orders- Code

Lecture 138 Aggregate - Avg()

Lecture 139 Aggregate - Avg() - Code

Lecture 140 Aggregate - Avg() - Purchase

Lecture 141 Aggregate - Avg() - Purchase - Code

Lecture 142 Aggregate - Sum()

Lecture 143 Aggregate - Sum() - Code

Lecture 144 Aggregate - Sum() - Total number of stock

Lecture 145 Aggregate - Sum() - Total number of stock - Code

Lecture 146 Aggregate - SUM() - Total Sales

Lecture 147 Aggregate - SUM() - Total Sales - Code

Lecture 148 Aggregate - ARRAY_AGG()

Lecture 149 Aggregate - ARRAY_AGG() - Code

Lecture 150 Aggregate - STRING_AGG() - List of Customers

Lecture 151 Aggregate - STRING_AGG() - List of Customers - Code

Lecture 152 Aggregate - ARRAY_AGG() - Customer Names

Lecture 153 Aggregate - ARRAY_AGG() - Customer Names - Code

Lecture 154 Understanding Limit, Fetch and Offset

Lecture 155 Limit - First Row

Lecture 156 Limit - First Row - Code

Lecture 157 Limit - First Three Rows

Lecture 158 Limit - First Three Rows - Code

Lecture 159 Offset & Limit - Third to Fifth Rows

Lecture 160 Offset & Limit - Third to Fifth Rows - Code

Lecture 161 Offset & Limit - The Most Expensive Product

Lecture 162 Offset & Limit - The Most Expensive Product - Code

Lecture 163 Offset & Limit - Productivity

Lecture 164 Offset & Limit - Productivity - Code

Section 2: SQL Join: From 1 Table to 15 Tables Joins

Lecture 165 Basics - Introduction to Join - Purpose of Join

Lecture 166 Basics - Type of Join

Lecture 167 Basics - Cross Join

Lecture 168 Basics - Cross Join Code

Lecture 169 Basics - Inner Join

Lecture 170 Basics - Inner Join Code

Lecture 171 Basics - Left Join

Lecture 172 Basics - Left Join Code

Lecture 173 Basics - Right Join

Lecture 174 Basics - Right Join Code

Lecture 175 Basics - Full Outer Join

Lecture 176 Basics - Full Outer Join Code

Lecture 177 Basics - Natural Join

Lecture 178 Basics - Natural Join Code

Lecture 179 Basics - Self Join

Lecture 180 Basics - Self Join Code

Lecture 181 Intermediate - How to choose the right column for the JOIN

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

Lecture 183 Intermediate - How to choose the right column for the JOIN - Exercise - Code

Lecture 184 Intermediate - Understanding "USING"

Lecture 185 Intermediate - Understanding "USING" - Code

Lecture 186 Intermediate - Understanding Alias in JOIN

Lecture 187 Intermediate - Understanding Alias in JOIN - Code

Lecture 188 Intermediate - ON and WHERE

Lecture 189 Intermediate - ON and WHERE - Code

Lecture 190 Intermediate - Joining Many Tables

Lecture 191 Intermediate - Hits on Joining Many Tables

Lecture 192 Intermediate - Hits on Joining Many Tables - Code

Lecture 193 Group By With Single Table - A requirement for further lesson

Lecture 194 Group By With Single Table - A requirement for further lesson - Code

Lecture 195 Group By With Two Tables - A requirement for further lesson

Lecture 196 Group By With Two Tables - A requirement for further lesson - Code

Lecture 197 Pro - Two Tables - The Second to The Cheapest Product

Lecture 198 Pro - Two Tables - The Second to The Cheapest Product - Code

Lecture 199 Pro - Two Tables - Better Report

Lecture 200 Pro - Two Tables - Better Report - Code

Lecture 201 Pro - Two Tables - Number of Orders Per Employee

Lecture 202 Pro - Two Tables - Number of Orders Per Employee - Code

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

Lecture 204 Pro - Two Tables - Number of Shipment Per Each Shipping Company - Code

Lecture 205 Pro - Two Tables - Number of Shipment 1998

Lecture 206 Pro - Two Tables - Number of Shipment 1998 - Code

Lecture 207 Pro - Two Tables - Shipment to Countries

Lecture 208 Pro - Two Tables - Shipment to Countries - Code

Lecture 209 Pro - Two Tables - Territories Per Region

Lecture 210 Pro - Two Tables - Territories Per Region - code

Lecture 211 Pro - Two Tables - Territories to Employees

Lecture 212 Pro - Two Tables - Territories to Employees - Code

Lecture 213 Pro - Territory per Employee

Lecture 214 Pro - Territory per Employee - Code

Lecture 215 Pro - Categories per Products per Supplier

Lecture 216 Pro - Categories per Products per Supplier - Code

Lecture 217 Pro - Most Purchased Product

Lecture 218 Pro - Most Purchased Product - Code

Lecture 219 Pro - Revenue from each Customer

Lecture 220 Pro - Revenue from each Customer - Code

Lecture 221 Pro - Revenue from each Customer June 199

Lecture 222 Pro - Revenue from each Customer June 1997 - Code

Lecture 223 Pro - Revenue from each Customer in 1996

Lecture 224 Pro - Revenue from each Customer in 1996 - Code

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

Lecture 226 Pro - List of Products Purchased by Each Customer - Four Tables - Code

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

Lecture 228 Pro - List of Products Purchased by a Specific Customer in a year- Code

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

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

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

Lecture 232 Pro - Searching for a customer with given details - Four tables - Code

Lecture 233 Pro - Report Involving Five Tables

Lecture 234 Pro - Report Involving Five Tables - Code

Lecture 235 Pro - Reports on Delayed orders

Lecture 236 Pro - Reports on Delayed orders - Code

Lecture 237 Pro - Reports on Delayed orders with CASE

Lecture 238 Pro - Reports on Delayed orders with CASE - Code

Lecture 239 Understanding the Movie Rental Schema

Lecture 240 Pro - 15 Tables Joins

Lecture 241 Pro - 15 Tables Joins - Code

Lecture 242 Pro - Actors and Movies

Lecture 243 Pro - Actors and Movies - Code

Lecture 244 Pro - Actors and Movies listed

Lecture 245 Pro - Actors and Movies listed - Code

Lecture 246 Pro - List of Actors in Each Movie

Lecture 247 Pro - List of Actors in Each Movie - Code

Lecture 248 Pro - List of Actors in Each Movie & Category

Lecture 249 Pro - List of Actors in Each Movie & Category - Code

Lecture 250 Pro - Number of Actors Per Movie

Lecture 251 Pro - Number of Actors Per Movie - Coce

Lecture 252 Pro - Number of Movies Each Actor Acted In

Lecture 253 Pro - Number of Movies Each Actor Acted In - Code

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

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

Lecture 256 Pro - First 10 lowest appearance

Lecture 257 Pro - First 10 lowest appearance - Code

Lecture 258 Pro - History of Rental

Lecture 259 Pro - History of Rental - Code

Lecture 260 Pro - Revenues

Lecture 261 Pro - Revenues - Code

Section 3: Do It Yourself - More Challenges & Solutions

Lecture 262 Exercise 1 - employee performance report

Lecture 263 Exercise 1 - Code

Lecture 264 Exercise 2 - employee performance report II

Lecture 265 Exercise 2 - Code

Lecture 266 Exercise 3 - Customers per employee report

Lecture 267 Exercise 3 - Code

Lecture 268 Exercise 4 - Suppliers and shipper per employee report

Lecture 269 Exercise 4 - Code

Lecture 270 Exercise 5 - Employees' regions report

Lecture 271 Exercise 5 - Code

Lecture 272 Exercise 6 - Employees' regions report II

Lecture 273 Exercise 6 - Code

Lecture 274 Exercise 7 - Employee - Region - Customers report

Lecture 275 Exercise 7 - Code

Lecture 276 Exercise 8 - Orders report

Lecture 277 Exercise 9 - Code

Lecture 278 Exercise 9 - Orders with the products suppliers

Lecture 279 Exercise 9 - Code

Lecture 280 Exercise 10 - Orders with the products suppliers II

Lecture 281 Exercise 10 - Code

Section 4: Extra Lectures: Intersect, Union & Except

Lecture 282 Understanding Intersect

Lecture 283 Understanding Intersect - Code

Lecture 284 What is Union

Lecture 285 Union - Exercise 1

Lecture 286 Union - Exercise 1 - Code

Lecture 287 Union - Exercise 2

Lecture 288 Union - Exercise 2 - Code

Lecture 289 Union - Exercise 3

Lecture 290 Union - Exercise 3 - Code

Lecture 291 Union - Exercise 4

Lecture 292 Union - Exercise 4 - Code

Lecture 293 Understanding Except

Lecture 294 Except - Exercise

Lecture 295 Except - Exercise - CODE

Section 5: Bonus Section

Lecture 296 Check out my other courses

Anyone who aspire to advanced in data analytics using SQL