Sql Joins Masterclass™: Learn To Join 2 To 15 Tables - 2023
Last updated 1/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.02 GB | Duration: 5h 12m
Last updated 1/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.02 GB | Duration: 5h 12m
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