Tags
Language
Tags
June 2025
Su Mo Tu We Th Fr Sa
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 1 2 3 4 5
    Attention❗ To save your time, in order to download anything on this site, you must be registered 👉 HERE. If you do not have a registration yet, it is better to do it right away. ✌

    ( • )( • ) ( ͡⚆ ͜ʖ ͡⚆ ) (‿ˠ‿)
    SpicyMags.xyz

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

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

    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

    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