Udemy SQL JOINS Masterclass Learn to join 2 to 15 Tables 2024

Files Included :

1 Course Content Walkthrough.mp4 (20.39 MB)
MP4
100 Where - Sales Manager & Vice President Details.mp4 (7.98 MB)
MP4
102 Where - Names of certain products with given prices.mp4 (4.02 MB)
MP4
104 Where - Searching for a product given certain details.mp4 (8.56 MB)
MP4
106 Where - Searching for employee given certain details.mp4 (8.4 MB)
MP4
108 Where - Null Region.mp4 (5.98 MB)
MP4
110 Where - Not Null Region.mp4 (3.07 MB)
MP4
112 Wildcard - Contains Sales.mp4 (11.77 MB)
MP4
113 Wildcard - Phone number starts with 171.mp4 (5.52 MB)
MP4
115 Wildcard - Contact ends with.mp4 (10.57 MB)
MP4
117 Wildcard - Searching with letter.mp4 (5.71 MB)
MP4
119 Wildcard - Searching for a company.mp4 (3.5 MB)
MP4
121 Wildcard - Searching for a city.mp4 (3.26 MB)
MP4
123 Wildcard - Searching for a city with starting and end letters.mp4 (4.96 MB)
MP4
125 Wildcard - NOT.mp4 (10.48 MB)
MP4
127 Aggregate - Introduction.mp4 (3.68 MB)
MP4
128 Aggregate - Min().mp4 (3.44 MB)
MP4
13 Select - All columns.mp4 (6.39 MB)
MP4
130 Aggregate - Min() - First Shipment.mp4 (7.76 MB)
MP4
132 Aggregate - Max().mp4 (1.55 MB)
MP4
134 Aggregate - Count().mp4 (3.96 MB)
MP4
136 Aggregate - Count() - Number of Orders.mp4 (11.23 MB)
MP4
138 Aggregate - Avg().mp4 (2.21 MB)
MP4
140 Aggregate - Avg() - Purchase.mp4 (2.34 MB)
MP4
142 Aggregate - Sum().mp4 (4.35 MB)
MP4
144 Aggregate - Sum() - Total number of stock.mp4 (5.09 MB)
MP4
146 Aggregate - SUM() - Total Sales.mp4 (5.13 MB)
MP4
148 Aggregate - ARRAY AGG().mp4 (6.81 MB)
MP4
15 Select - Few Columns.mp4 (8.81 MB)
MP4
150 Aggregate - STRING AGG() - List of Customers.mp4 (8.64 MB)
MP4
152 Aggregate - ARRAY AGG() - Customer Names.mp4 (2.36 MB)
MP4
154 Understanding Limit, Fetch and Offset.mp4 (6.75 MB)
MP4
155 Limit - First Row.mp4 (6.53 MB)
MP4
157 Limit - First Three Rows.mp4 (5.32 MB)
MP4
159 Offset & Limit - Third to Fifth Rows.mp4 (7.81 MB)
MP4
161 Offset & Limit - The Most Expensive Product.mp4 (26.99 MB)
MP4
163 Offset & Limit - Productivity.mp4 (61.47 MB)
MP4
17 Select - Old Price and New Price.mp4 (15.98 MB)
MP4
19 Select - Report with Comment.mp4 (15.14 MB)
MP4
2 Demo Lecture - 1.mp4 (27.04 MB)
MP4
21 Select - Distinct.mp4 (7.06 MB)
MP4
23 Alias - SQL Alias.mp4 (10.94 MB)
MP4
25 Reporting with Concatenation - Title and First Name.mp4 (11.13 MB)
MP4
27 Reporting with Concatenation - Customer and Location.mp4 (7.83 MB)
MP4
29 Reporting with Concatenation - Customer and Location II.mp4 (4.69 MB)
MP4
31 Reporting with Concatenation - Total Value of Products In Stock.mp4 (11.02 MB)
MP4
33 Report Formatting - Introduction.mp4 (15.4 MB)
MP4
34 Report Formatting - Understanding Format Exercise & Solution 1.mp4 (14.45 MB)
MP4
36 Report Formatting - Understanding Format Exercise & Solution 2.mp4 (7.91 MB)
MP4
38 Report Formatting - Understanding Format Exercise & Solution 3.mp4 (5.52 MB)
MP4
4 Demo Lecture - 2.mp4 (22.62 MB)
MP4
40 Report Formatting - Understanding Format Exercise & Solution 4.mp4 (5.24 MB)
MP4
42 Report Formatting - Understanding Format Exercise & Solution 5.mp4 (3.17 MB)
MP4
44 Report Formatting - Understanding Format Exercise & Solution 6.mp4 (12.52 MB)
MP4
46 Round - Amount Formatting Exercise & Solution 1.mp4 (4.98 MB)
MP4
48 Round - Amount Formatting Exercise & Solution 2.mp4 (5.05 MB)
MP4
50 Round - Amount Formatting Exercise & Solution 3.mp4 (3.47 MB)
MP4
52 Round - Amount Formatting Exercise & Solution 4.mp4 (12.52 MB)
MP4
54 Order By - Ascending Exercise & Solution 1.mp4 (11.07 MB)
MP4
56 Order By - Ascending and Descending Exercise & Solution 2.mp4 (11.86 MB)
MP4
58 Order By - Ascending and Ascending Exercise & Solution 3.mp4 (6.04 MB)
MP4
6 Resource - Creating Databases and Inserting Data.mp4 (55.44 MB)
MP4
60 Where - Sales Managers' Details.mp4 (6.14 MB)
MP4
62 Where - Owners' Details.mp4 (14.05 MB)
MP4
64 Where - Specific Order ID.mp4 (5.49 MB)
MP4
66 Where - Searching for a Product with Price.mp4 (5.15 MB)
MP4
68 Where - Searching for a Product with Price II.mp4 (5.09 MB)
MP4
70 Where - Searching for a Customer with ID.mp4 (4.47 MB)
MP4
72 Where - Products above 32 8.mp4 (8.68 MB)
MP4
74 Where - Products less than 10.mp4 (4.54 MB)
MP4
76 Where - Products whose price are 40 and above.mp4 (3.1 MB)
MP4
78 Where - Products within a range.mp4 (8.99 MB)
MP4
80 Where - Products - Restocking.mp4 (9.67 MB)
MP4
82 Where - Order amount of 10540 or above.mp4 (6.97 MB)
MP4
84 Where - None Mr.mp4 (18.91 MB)
MP4
86 Where - None Sales Representative.mp4 (11.51 MB)
MP4
88 Where - Price Between two figures.mp4 (8.83 MB)
MP4
90 Where - Not Between.mp4 (4.32 MB)
MP4
92 Where - Two Between.mp4 (7.37 MB)
MP4
94 Where - Customers from certain cities.mp4 (6.38 MB)
MP4
96 Where - Every other customers except.mp4 (7.44 MB)
MP4
98 Where - Customers From France.mp4 (9.84 MB)
MP4
1 Basics - Introduction to Join - Purpose of Join.mp4 (6.51 MB)
MP4
11 Basics - Full Outer Join.mp4 (16.08 MB)
MP4
13 Basics - Natural Join.mp4 (16.36 MB)
MP4
15 Basics - Self Join.mp4 (30.24 MB)
MP4
17 Intermediate - How to choose the right column for the JOIN.mp4 (84.46 MB)
MP4
18 Intermediate - How to choose the right column for the JOIN - Exercise.mp4 (10.66 MB)
MP4
2 Basics - Type of Join.mp4 (2.26 MB)
MP4
20 Intermediate - Understanding USING.mp4 (4.41 MB)
MP4
22 Intermediate - Understanding Alias in JOIN.mp4 (20.29 MB)
MP4
24 Intermediate - ON and WHERE.mp4 (18.36 MB)
MP4
26 Intermediate - Joining Many Tables.mp4 (43.15 MB)
MP4
27 Intermediate - Hits on Joining Many Tables.mp4 (97.23 MB)
MP4
29 Group By With Single Table - A requirement for further lesson.mp4 (9.35 MB)
MP4
3 Basics - Cross Join.mp4 (9.29 MB)
MP4
31 Group By With Two Tables - A requirement for further lesson.mp4 (12.01 MB)
MP4
33 Pro - Two Tables - The Second to The Cheapest Product.mp4 (11.87 MB)
MP4
35 Pro - Two Tables - Better Report.mp4 (6.99 MB)
MP4
37 Pro - Two Tables - Number of Orders Per Employee.mp4 (31.19 MB)
MP4
39 Pro - Two Tables - Number of Shipment Per Each Shipping Company.mp4 (20.44 MB)
MP4
41 Pro - Two Tables - Number of Shipment 1998.mp4 (11.37 MB)
MP4
43 Pro - Two Tables - Shipment to Countries.mp4 (17.74 MB)
MP4
45 Pro - Two Tables - Territories Per Region.mp4 (17.81 MB)
MP4
47 Pro - Two Tables - Territories to Employees.mp4 (16.75 MB)
MP4
49 Pro - Territory per Employee.mp4 (21.68 MB)
MP4
5 Basics - Inner Join.mp4 (22.43 MB)
MP4
51 Pro - Categories per Products per Supplier.mp4 (20.3 MB)
MP4
53 Pro - Most Purchased Product.mp4 (43.22 MB)
MP4
55 Pro - Revenue from each Customer.mp4 (18.34 MB)
MP4
57 Pro - Revenue from each Customer June 199.mp4 (6.33 MB)
MP4
59 Pro - Revenue from each Customer in 1996.mp4 (3.85 MB)
MP4
61 Pro - List of Products Purchased by Each Customer - Four Tables.mp4 (50.56 MB)
MP4
63 Pro - List of Products Purchased by a Specific Customer in a year- Four Tables.mp4 (12.29 MB)
MP4
65 Pro - List of Products Purchased by a Specific Customer - Four Tables.mp4 (8.95 MB)
MP4
67 Pro - Searching for a customer with given details - Four tables.mp4 (50.04 MB)
MP4
69 Pro - Report Involving Five Tables.mp4 (30.53 MB)
MP4
7 Basics - Left Join.mp4 (27.63 MB)
MP4
71 Pro - Reports on Delayed orders.mp4 (21.85 MB)
MP4
73 Pro - Reports on Delayed orders with CASE.mp4 (32.45 MB)
MP4
75 Understanding the Movie Rental Schema.mp4 (33.68 MB)
MP4
75 1 Schema.zip (463.38 KB)
ZIP
76 Pro - 15 Tables Joins.mp4 (53.57 MB)
MP4
78 Pro - Actors and Movies.mp4 (6.16 MB)
MP4
80 Pro - Actors and Movies listed.mp4 (11.34 MB)
MP4
82 Pro - List of Actors in Each Movie.mp4 (8.27 MB)
MP4
84 Pro - List of Actors in Each Movie & Category.mp4 (8.11 MB)
MP4
86 Pro - Number of Actors Per Movie.mp4 (7.72 MB)
MP4
88 Pro - Number of Movies Each Actor Acted In.mp4 (5.05 MB)
MP4
9 Basics - Right Join.mp4 (10.86 MB)
MP4
90 Pro - Actor with the highest number of appearance in movies - Code.mp4 (3.95 MB)
MP4
92 Pro - First 10 lowest appearance.mp4 (16.63 MB)
MP4
94 Pro - History of Rental.mp4 (8.18 MB)
MP4
96 Pro - Revenues.mp4 (17.12 MB)
MP4
1 Exercise 1 - employee performance report.mp4 (8.81 MB)
MP4
11 Exercise 6 - Employees' regions report II.mp4 (7.46 MB)
MP4
13 Exercise 7 - Employee - Region - Customers report.mp4 (5.74 MB)
MP4
15 Exercise 8 - Orders report.mp4 (6.7 MB)
MP4
17 Exercise 9 - Orders with the products suppliers.mp4 (13.72 MB)
MP4
19 Exercise 10 - Orders with the products suppliers II.mp4 (10.69 MB)
MP4
3 Exercise 2 - employee performance report II.mp4 (9.99 MB)
MP4
5 Exercise 3 - Customers per employee report.mp4 (6.22 MB)
MP4
7 Exercise 4 - Suppliers and shipper per employee report.mp4 (10.71 MB)
MP4
9 Exercise 5 - Employees' regions report.mp4 (6.52 MB)
MP4
1 Understanding Intersect.mp4 (5.22 MB)
MP4
10 Union - Exercise 4.mp4 (15.01 MB)
MP4
12 Understanding Except.mp4 (11.28 MB)
MP4
13 Except - Exercise.mp4 (2.09 MB)
MP4
3 What is Union.mp4 (3.36 MB)
MP4
4 Union - Exercise 1.mp4 (9.62 MB)
MP4
6 Union - Exercise 2.mp4 (5.33 MB)
MP4
8 Union - Exercise 3.mp4 (14.49 MB)
MP4