download скачать Free download скачать : SQL JOINS Masterclass Learn to join 2 to 15 Tables - 2024
mp4 | Video: h264,1280X720 | Audio: AAC, 44.1 KHz
Genre:eLearning | Language: English | Size:1.96 GB

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
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

 https://rapidgator.net/file/5a60c3c587dc19fac656927ae8b4caba/SQL_JOINS_Masterclass_Learn_to_join_2_to_15_Tables_-_2024.zip

 https://voltupload.com/u1x0icylf0ze/SQL_JOINS_Masterclass_Learn_to_join_2_to_15_Tables_-_2024.zip

Free search engine download скачать: SQL JOINS Masterclass Learn to join 2 to 15 Tables - 2024