Files Included :
2 – Introduction to SQL.mp4 (857.31 MB)
3 – Installation Introduction.mp4 (72.7 MB)
6 – Installation Installation of MySQL on MacOS.mp4 (89.55 MB)
8 – Installation How to fix Cannot Connect to MySQL Server MacOS.mp4 (30.58 MB)
9 – Installation Installation of MySQL Server and Workbench on Windows.mp4 (41.51 MB)
10 – Installation How to fix Cannot Connect to MySQL Server Windows.mp4 (23.64 MB)
11 – Database Database as a house Introduction.mp4 (56.99 MB)
12 – Database Creating a Database.mp4 (20.98 MB)
13 – Database Creating a Database with IF NOT EXISTS.mp4 (56.71 MB)
14 – Database How to use a Database.mp4 (12.39 MB)
15 – Database Finding Out the Currently Selected Database.mp4 (15.93 MB)
16 – Database Checking If a Database Exists.mp4 (24.96 MB)
17 – Database Deleting a Database.mp4 (13.14 MB)
18 – Database Deleting a Database If It Exists.mp4 (14.95 MB)
21 – Select Understanding Select Statement.mp4 (462.93 MB)
23 – Resources How to Run the Resources.mp4 (8.18 MB)
24 – CRUD Understanding CRUD.mp4 (25.18 MB)
27 – Table Introduction and Creating Basic Table in MySQL.mp4 (424.78 MB)
28 – Data Types Introduction.mp4 (136.64 MB)
29 – SELECT Understanding Select for Absolute beginners.mp4 (109.47 MB)
30 – Database vs Table In SQL Laymans Explanation Challenge Solution.mp4 (19.7 MB)
31 – Creating A Database Challenge Solution 1.mp4 (1.62 MB)
33 – IF NOT EXISTS with CREATE DATABASE Challenge Solution 2.mp4 (7.14 MB)
35 – How To Check For Existing Databases Challenge Solution 3.mp4 (3.98 MB)
37 – How To Delete A Database Challenges Solution 4.mp4 (5.86 MB)
39 – Using A Database Challenge Solution 5.mp4 (9.91 MB)
41 – How To Check For The Selected Database in Use Challenge Solution 6.mp4 (2.7 MB)
43 – Introduction to MySQL Numeric Data Types.mp4 (136.3 MB)
44 – Integer Types INTEGER or INT SMALLINT TINYINT MEDIUMINT BIGINT.mp4 (116.27 MB)
45 – Clients Integer Data Types Requirement Scenario.mp4 (158.74 MB)
47 – Boolean Type tinyint1.mp4 (88.04 MB)
51 – FixedPoint Types DECIMAL NUMERIC.mp4 (72.48 MB)
52 – Clients FixedPoint Data Types Requirement Scenario.mp4 (24.13 MB)
56 – FloatingPoint Types FLOAT DOUBLE.mp4 (64.56 MB)
57 – Clients FloatingPoint Data Types Requirement Scenario.mp4 (9.59 MB)
61 – BitValue Type BIT.mp4 (14.79 MB)
62 – Clients Bit Data Types Requirement Scenario.mp4 (17.5 MB)
66 – Introduction to MySQL String Data Types.mp4 (21.24 MB)
67 – The CHAR and VARCHAR Types.mp4 (35.19 MB)
68 – Clients CHAR and VARCHAR Types Requirement Scenario.mp4 (42.93 MB)
72 – The BINARY and VARBINARY Types.mp4 (22.25 MB)
73 – Clients BINARY and VARBINARY Types Requirement Scenario.mp4 (14.65 MB)
77 – The BLOB and TEXT Types.mp4 (86.2 MB)
78 – Clients BLOB and TEXT Types Requirement Scenario.mp4 (73.54 MB)
82 – ENUM Type.mp4 (27.17 MB)
83 – Clients ENUM Types Requirement Scenario.mp4 (111.35 MB)
87 – SET Type.mp4 (40.54 MB)
88 – Clients SET Types Requirement Scenario.mp4 (42.67 MB)
92 – Introduction to MySQL Date Time.mp4 (9.36 MB)
93 – DATE TIME Types.mp4 (87.94 MB)
94 – Clients Date and Time Types Requirement Scenario.mp4 (39.94 MB)
98 – Introduction to MySQL Spatial Types.mp4 (17.49 MB)
99 – Spatial Data Types.mp4 (57.67 MB)
100 – Clients Spatial Types Requirement Scenario.mp4 (92.34 MB)
104 – Understanding JSON Data Type in MySQL.mp4 (17.51 MB)
105 – Clients JSON Types Requirement Scenario.mp4 (92.3 MB)
109 – Type of Data in MySQL.mp4 (3.51 MB)
110 – MySQL Numeric Types.mp4 (5.33 MB)
111 – TINYINT SMALLINT MEDIUMINT INTEGER BIGINT Exact Numeric Data Types in MySQL.mp4 (123.35 MB)
112 – DECIMAL NUMERIC Fixed Point Data Types in MySQL Approximate Numeric I.mp4 (21.86 MB)
113 – DECIMAL NUMERIC Fixed Point Data Types in MySQL Approximate Numeric II.mp4 (73.86 MB)
114 – REAL FLOAT DOUBLE Floating Point Data Type in MySQL.mp4 (24.23 MB)
115 – CHAR vs VARCHAR String Data Types in MySQL.mp4 (12.37 MB)
116 – BINARY VARBINARY String Data Types in MySQL.mp4 (8.39 MB)
117 – BLOB TEXT String Data Types in MySQL.mp4 (2.66 MB)
118 – ENUM String Data Types in MySQL.mp4 (15.21 MB)
119 – SET String Data Types in MySQL.mp4 (14.47 MB)
120 – DATE TIME DATETIME TIMESTAMP YEAR Date and Time Data Types in MySQL.mp4 (5.67 MB)
121 – MySQL Auto Increment.mp4 (40.78 MB)
122 – MySQL Default.mp4 (48.05 MB)
123 – MySQL Null and NOT Null.mp4 (75.92 MB)
124 – WHERE A brief Intro.mp4 (51.51 MB)
125 – SQL Basic Insert.mp4 (7.06 MB)
126 – SQL Inserting Multiple Rows at Once.mp4 (2.86 MB)
127 – SQL Inserting Data from Another Table.mp4 (26.74 MB)
128 – SQL Inserting with a Set Clause.mp4 (8.63 MB)
129 – Inserting A Single Line of Data Into Table 1st Method.mp4 (13.25 MB)
131 – Inserting A Single Line of Data Into Table 2nd Method.mp4 (6.9 MB)
133 – Inserting Multiple Lines of Data Into Table 1st Method.mp4 (7.94 MB)
135 – Inserting Multiple Lines of Data Into Table 2nd Method.mp4 (17.63 MB)
137 – Inserting Multiple Lines of Data Into Table 3rd Method.mp4 (9.65 MB)
139 – Inserting Null Value and Empty White Space Into Table.mp4 (36.17 MB)
141 – Introductions to Keys in SQL.mp4 (75.93 MB)
142 – Unique Key in SQL.mp4 (444.64 MB)
143 – Primary Key in SQL.mp4 (130.21 MB)
144 – Candidate and Alternate Keys in SQL.mp4 (135.27 MB)
145 – Composite Compound Key in SQL.mp4 (13.72 MB)
146 – Natural Key in SQL.mp4 (23.41 MB)
147 – Surrogate Key in SQL.mp4 (42.46 MB)
148 – Super Key in SQL.mp4 (43.86 MB)
149 – Foreign Key in SQL.mp4 (303.36 MB)
152 – Candidate Key In SQL.mp4 (25.59 MB)
153 – Surrogate Key In SQL.mp4 (15.94 MB)
154 – Primary Key Alternative Key In SQL.mp4 (36.86 MB)
155 – Foreign Key In SQL.mp4 (47.02 MB)
156 – Alter Table Intro Adding a New Column.mp4 (39.66 MB)
157 – Alter Table Dropping an Existing Column.mp4 (9.49 MB)
158 – Alter Table Modify Column Type and Size.mp4 (10.7 MB)
159 – Alter Table Drop Primary Key.mp4 (7.67 MB)
160 – Alter Table Add Primary Key.mp4 (3.96 MB)
161 – Alter Table Add Unique Constraint.mp4 (7.85 MB)
162 – Alter Table Rename Column.mp4 (7.61 MB)
163 – Alter Table Add Foreign Key.mp4 (37.51 MB)
164 – Alter Table Rename Table.mp4 (6.17 MB)
165 – Alter Table Add Default to Column.mp4 (15.07 MB)
166 – Alter Table Drop Default from a Column.mp4 (8.52 MB)
167 – Alter Table Drop Foreign Key.mp4 (56.54 MB)
168 – Introduction to delete Deleting Specific Records.mp4 (31.83 MB)
169 – Delete multiple records.mp4 (14.3 MB)
170 – Delete all records.mp4 (5.62 MB)
171 – Truncate Table.mp4 (7.08 MB)
172 – Deleting a Table.mp4 (6.23 MB)
173 – Delete Cascade.mp4 (176.45 MB)
174 – Assigning A PRIMARY KEY Three Methods Challenge Solution 1.mp4 (33.8 MB)
176 – Deleting A PRIMARY KEY Challenge Solution 2.mp4 (22.59 MB)
178 – Adding A PRIMARY KEY To Existing Column Challenge Solution 3.mp4 (12.79 MB)
180 – Assigning A FOREIGN KEY Challenge Solution 4.mp4 (54.96 MB)
182 – Assigning A CONSTRAINT NAME To A FOREIGN KEY Challenge Solution 5.mp4 (25.07 MB)
184 – Adding A FOREIGN KEY To Existing Table Challenge Solution 6.mp4 (24.5 MB)
186 – Challenge Solution 7 CONSTRAINT NAME FOREIGN KEY To Existing Table.mp4 (21.57 MB)
188 – Deleting A REFERENCED Parent Table Challenge Solution 8.mp4 (19.63 MB)
190 – Deleting A Column From A Table Challenge Solution 9.mp4 (9.36 MB)
192 – Deleting A REFERENCED or CONSTRAINT Column Challenge Solution 10.mp4 (25.07 MB)
194 – Select All Rows and Columns Challenge Solution 1.mp4 (21.01 MB)
196 – Select Specific Columns Challenge Solution 2.mp4 (7.63 MB)
198 – Manager Demands for All Customers Detail Challenge Solution 3.mp4 (4.79 MB)
200 – Specific Customers Details Challenge Solution 4.mp4 (3.59 MB)
202 – ALIAS AS Introduction.mp4 (25.39 MB)
204 – Alias Challenge Solution.mp4 (9.29 MB)
206 – CONCAT Introduction.mp4 (4.59 MB)
208 – CONCAT Challenge Solution 1.mp4 (2.4 MB)
210 – CONCAT Challenge Solution 2.mp4 (15.09 MB)
212 – ORDER BY Introduction.mp4 (10.88 MB)
213 – ORDER BY ASC Challenge Solution 1.mp4 (15.56 MB)
215 – ORDER BY DESC Challenge Solution 2.mp4 (12.84 MB)
217 – ORDER BY DESC CONCAT Challenge Solution 3.mp4 (20.23 MB)
219 – ORDER BY ASC Challenge Solution 4.mp4 (9.82 MB)
221 – LIMIT Challenge Solution 1.mp4 (6.9 MB)
223 – LIMIT Challenge Solution 2.mp4 (11.36 MB)
225 – LIMIT Challenge Solution 3.mp4 (4.5 MB)
227 – ORDER BY with RAND Challenge Solution.mp4 (10.8 MB)
229 – SINGLE MULTILINE COMMENTS in SQLMySQL.mp4 (20.59 MB)
230 – Introduction to WHERE.mp4 (9.44 MB)
232 – UK Customers filter Challenge Solution 1.mp4 (28.74 MB)
234 – Specific Customer filter Challenge Solution 2.mp4 (2.38 MB)
236 – Specific Employee filter Challenge Solution 3.mp4 (2.3 MB)
238 – Product with specific Price filter Challenge Solution 4.mp4 (3.31 MB)
240 – Getting a list of Sales Representatives Challenge Solution 5.mp4 (6.39 MB)
242 – None Spanish Customers using Challenge Solution 6.mp4 (19.26 MB)
244 – Products Supplied by a Specific Customer Challenge Solution 7.mp4 (3.92 MB)
246 – All Suppliers Except using NOT Challenge Solution 8.mp4 (12.33 MB)
248 – Products above certain Price Greater Than Challenge Solution 9.mp4 (5.71 MB)
250 – Products Below Certain Price Less Than Challenge Solution 10.mp4 (5.57 MB)
252 – Unit In Stock Less Than Challenge Solution 11.mp4 (5.59 MB)
254 – Minimum Wages Less Than Challenge Solution 12.mp4 (4.36 MB)
256 – Gifts for Customers Greater Than Challenge Solution 13.mp4 (12.5 MB)
258 – Units In Stock Less Than Challenge Solution 14.mp4 (9.37 MB)
260 – San Francisco Customers AND Challenge Solution 15.mp4 (15.46 MB)
262 – Specific Mexico Customers AND Challenge Solution 16.mp4 (10.78 MB)
264 – None USA and UK Customers NOT Challenge Solution 17.mp4 (21.8 MB)
266 – Brazil and Venezuela Customers OR Challenge Solution 18.mp4 (10.7 MB)
268 – Range of Suppliers BETWEEN Challenges Solution 19.mp4 (7.8 MB)
270 – Suppliers Combining OR Challenge Solution 20.mp4 (4.01 MB)
272 – Range of Suppliers using BETWEEN Challenge Solution 21.mp4 (7.6 MB)
274 – NOT BETWEEN Challenge Solution 22.mp4 (4.41 MB)
276 – Customers in Paris Nantes France Challenge Solution 23.mp4 (19.33 MB)
278 – Product List BETWEEN CONCAT FORMAT ORDER BY Challenge Solution 24.mp4 (10.01 MB)
280 – NULL values IS NULL IS NOT NULL Challenge Solution 25.mp4 (8.54 MB)
282 – Employees Report to 2 IS NOT NULL Challenge Solution 26.mp4 (15.3 MB)
284 – IN and WHERE Challenge Solution 27.mp4 (12.62 MB)
286 – NOT IN UK Germany France Customers Challenge Solution 28.mp4 (13.88 MB)
288 – Introduction to MySQL Index.mp4 (18.64 MB)
289 – Creating Index Along a Table.mp4 (4.91 MB)
291 – Creating Index on Existing Column.mp4 (3.02 MB)
293 – Understanding Primary or Clustered Index.mp4 (30.19 MB)
294 – Unique Key vs Index.mp4 (6.12 MB)
295 – Key vs Index.mp4 (15.77 MB)
296 – Verifying Index.mp4 (11.36 MB)
298 – Confirming the Power of Index.mp4 (48.94 MB)
300 – Deleting Index.mp4 (20.66 MB)
302 – Introduction to MySQL Wildcards.mp4 (85.5 MB)
303 – MySQL Wildcard Customers Start With P Challenges Solution 1.mp4 (8.08 MB)
305 – MySQL Wildcard Employees In Sales Challenges Solution 2.mp4 (13.54 MB)
307 – MySQL Wildcard Phone Number Pattern Challenges Solution 3.mp4 (26.4 MB)
309 – MySQL Wildcard Customers In Restaurant Business Challenges Solution 4.mp4 (2.25 MB)
311 – MySQL Wildcard NOT LIKE Challenges Solution 5.mp4 (7.15 MB)
313 – Updating a Single Value in a Table.mp4 (29.08 MB)
315 – Updating Multiple Values in a Table.mp4 (11.61 MB)
317 – Using UPDATE with REPLACE.mp4 (35.63 MB)
319 – What is Storage Engine Lets Digress a little.mp4 (16.68 MB)
320 – DISTINCT How it works.mp4 (18.08 MB)
322 – DISTINCT ORDER BY DESC WHERE IS NOT Challenge Solution.mp4 (17.35 MB)
324 – How Format Function Works.mp4 (8.52 MB)
326 – Data Cleaning Format Challenge Solution.mp4 (6.59 MB)
328 – GROUP BY True Meaning.mp4 (57.8 MB)
329 – MIN MAX AVG SUM GROUP BY Challenge Solution 1.mp4 (27.2 MB)
331 – GROUP BY SUMMINAVG CONCAT FORMAT Challenge Solution 2.mp4 (13.36 MB)
333 – Region Count GROUP BY COUNT Challenge Solution 3.mp4 (10.19 MB)
335 – Row Unique Value Count GROUP BY COUNT Challenge Solution 4.mp4 (14.09 MB)
337 – Product Count COUNT GROUP BY ORDER BY Challenge Solution 5.mp4 (35.55 MB)
339 – Product Sold SUM GROUP BY Challenge Solution 6.mp4 (12.99 MB)
341 – Most Hardworking Employee Challenge Solution 7.mp4 (18.17 MB)
344 – Purpose of JOIN in SQL.mp4 (17.02 MB)
345 – Type of JOIN in SQL.mp4 (3.66 MB)
346 – Understanding INNER JOIN.mp4 (16.52 MB)
347 – Understanding LEFT JOIN.mp4 (23.96 MB)
348 – Understanding RIGHT JOIN.mp4 (23.3 MB)
349 – Understanding FULL JOIN.mp4 (18.35 MB)
350 – Overview of Tables Code for JOIN Demonstration.mp4 (6.97 MB)
352 – INNER JOIN DEEP DIVE.mp4 (103.17 MB)
354 – LEFT JOIN DEEP DIVE.mp4 (57.17 MB)
356 – RIGHT JOIN DEEP DIVE.mp4 (30.04 MB)
358 – More On RIGHT JOIN and LEFT JOIN with Shipper Orders tables.mp4 (53.48 MB)
360 – TableColumn vs Column only.mp4 (93.05 MB)
361 – ON vs WHERE in INNER LEFT RIGHT JOIN.mp4 (53.58 MB)
362 – ON vs USING in SQL JOIN Statement.mp4 (27.04 MB)
363 – JOIN for Orders HandledManaged By Employee Challenge Solution 1.mp4 (64.73 MB)
365 – Using JOIN for Products Their Suppliers Challenge Solution 2.mp4 (44.94 MB)
367 – JOIN for Customers and Shippers Challenge Solution 3.mp4 (9.02 MB)
369 – JOIN Many Tables Customers and Names of Shipper Challenge Solution 4.mp4 (52.53 MB)
373 – Simplifying the Schema used for JOIN in the following sections.mp4 (70.26 MB)
374 – SelfJoin One Table Join Challenge and Solution 1.mp4 (104.55 MB)
376 – Two Tables Join Challenge and Solution 2.mp4 (5.97 MB)
378 – Two Tables Join Challenge and Solution 3.mp4 (21.93 MB)
380 – Two Tables Join Challenge and Solution 4.mp4 (13.99 MB)
382 – Two Tables Join Challenge and Solution 5.mp4 (23.88 MB)
384 – Three Table Joins Challenge and Solution 6.mp4 (10.99 MB)
386 – Three Tables Join Challenge and Solution 7.mp4 (6.11 MB)
388 – Four Tables Join Challenge and Solution 8.mp4 (51.99 MB)
390 – Five Tables Join Challenge and Solution 9.mp4 (52.12 MB)
392 – Five Tables Join Challenge and Solution 10.mp4 (25.65 MB)
394 – Six Tables Join Challenge and Solution 11.mp4 (15.5 MB)
396 – Seven Tables Join Challenge and Solution 12.mp4 (9.69 MB)
398 – Eight Tables Join Challenge and Solution 13.mp4 (13.5 MB)
400 – Nine Tables Join Challenge and Solution 14.mp4 (24.95 MB)
402 – Ten Tables Join Challenge and Solution For Demonstration Purpose.mp4 (19.76 MB)
404 – Offset Limit Challenge Solution 1.mp4 (38.19 MB)
406 – Offset Limit Third Highest Purchase Challenge Solution 2.mp4 (18.15 MB)
408 – Offset Limit First Three Highest Salary Challenge Solution 3.mp4 (6.34 MB)
410 – Offset Limit Fourth to the Lowest Salary Challenge Solution 4.mp4 (6.78 MB)
412 – OFFSET LIMIT First and Third Bestselling Products Challenge Solution 5.mp4 (12.76 MB)
414 – Understanding MySQL CASE.mp4 (57.41 MB)
416 – CASE with IS NULL.mp4 (22.14 MB)
418 – CASE FOR TYPE OF CUSTOMERS.mp4 (57.26 MB)
420 – CAST FROM STRING to DATE.mp4 (3.57 MB)
422 – CAST FROM INTEGER to CHAR Challenge Solution 2.mp4 (1.39 MB)
424 – CAST FROM STRING to DATE TIME Challenge Solution 3.mp4 (5.07 MB)
426 – CAST FROM STRING to TIME Challenge Solution 4.mp4 (2.02 MB)
428 – CAST Order Date Without time Challenge Solution 5.mp4 (7.58 MB)
430 – CAST FROM DATE to DATETIME Challenge Solution 6.mp4 (15.37 MB)
432 – Introduction to subqueries.mp4 (33.77 MB)
433 – Aggregate Function with Subqueries.mp4 (29.73 MB)
434 – Nested Subquery Challenge Solution 1.mp4 (32.65 MB)
435 – Many Subqueries Challenges Solution 2.mp4 (45 MB)
436 – Exists Operator.mp4 (7.37 MB)
437 – Subquery Exists Challenge Solution 1.mp4 (32.68 MB)
439 – Subquery Exists Challenge Solution 2.mp4 (45.75 MB)
441 – Difference Between Nested and Correlated Subqueries.mp4 (86.24 MB)
442 – SPACE FUNCTION Challenge Solution 1.mp4 (3.46 MB)
443 – SPACE FUNCTION Challenge Solution 2.mp4 (5.9 MB)
444 – REPEAT FUNCTION Challenge Solution 3.mp4 (3.05 MB)
445 – REPEAT FUNCTION Challenge Solution 4.mp4 (17.09 MB)
446 – REPLACE FUNCTION Challenge Solution 5.mp4 (4.56 MB)
447 – REPLACE FUNCTION Challenge Solution 6.mp4 (3.98 MB)
448 – REPLACE FUNCTION Challenge Solution 7.mp4 (14.88 MB)
449 – REVERSE FUNCTION Challenge Solution 8.mp4 (3.39 MB)
450 – REVERSE FUNCTION Challenge Solution 9.mp4 (13.87 MB)
451 – LEFT FUNCTION Challenge Solution 10.mp4 (6.4 MB)
452 – LEFT FUNCTION Challenge Solution 11.mp4 (8.42 MB)
453 – RIGHT FUNCTION Challenge Solution 12.mp4 (2.78 MB)
454 – RIGHT FUNCTION Challenge Solution 13.mp4 (15.4 MB)
455 – RPAD FUNCTION Challenge Solution 14.mp4 (5.16 MB)
456 – RPAD FUNCTION Challenge Solution 15.mp4 (20.47 MB)
457 – LPAD FUNCTION Challenge Solution 16.mp4 (10.79 MB)
458 – LPAD FUNCTION Challenge Solution 17.mp4 (6.25 MB)
459 – LPAD FUNCTION Challenge Solution 18.mp4 (41.91 MB)
460 – POSITION LOCATION FUNCTIONS Challenge Solution 19.mp4 (7.56 MB)
461 – POSITION LOCATION FUNCTIONS Challenge Solution 20.mp4 (7.2 MB)
462 – SUBSTRINGSUBSTR FUNCTION Challenge Solution 21.mp4 (11.92 MB)
463 – SUBSTRINGSUBSTR FUNCTION Challenge Solution 22.mp4 (21.37 MB)
464 – SUBSTRINGSUBSTR FUNCTION Challenge Solution 23.mp4 (21.65 MB)
465 – SUBSTRINGSUBSTR FUNCTION Challenge Solution 24.mp4 (5.87 MB)
466 – SUBSTRINGINDEX FUNCTION Challenge Solution 25.mp4 (8.24 MB)
467 – SUBSTRINGINDEX FUNCTION Challenge Solution 26.mp4 (4.84 MB)
468 – SUBSTRINGINDEX FUNCTION Challenge Solution 27.mp4 (6.13 MB)
469 – SUBSTRINGINDEX FUNCTION Challenge Solution 28.mp4 (5.48 MB)
470 – SUBSTRINGINDEX FUNCTION Challenge Solution 29.mp4 (16.41 MB)
471 – MID FUNCTION Challenge Solution 30.mp4 (3.96 MB)
472 – MID FUNCTION Challenge Solution 31.mp4 (6.25 MB)
473 – INSERT FUNCTION Challenge Solution 32.mp4 (12.92 MB)
474 – INSERT FUNCTION Challenge Solution 33.mp4 (8.7 MB)
475 – INSTR FUNCTION Challenge Solution 34.mp4 (6.22 MB)
476 – INSTR FUNCTION Challenge Solution 35.mp4 (6.18 MB)
477 – LCASE LOWER FUNCTION Challenge Solution 35.mp4 (3.9 MB)
478 – LCASE LOWER FUNCTION Challenge Solution 36.mp4 (2.55 MB)
479 – UCASE UPPER FUNCTION Challenge Solution 37.mp4 (2.37 MB)
480 – UCASE UPPER FUNCTION Challenge Solution 38.mp4 (5.89 MB)
481 – UCASE UPPER FUNCTION Challenge Solution 39.mp4 (4.72 MB)
482 – LENGTH FUNCTION Challenge Solution 40.mp4 (4.03 MB)
483 – LENGTH FUNCTION Challenge Solution 41.mp4 (5.28 MB)
484 – LTRIM FUNCTION Challenge Solution 42.mp4 (7.67 MB)
485 – LTRIM FUNCTION Challenge Solution 43.mp4 (6.64 MB)
486 – RTRIM FUNCTION Challenge Solution 44.mp4 (4.56 MB)
487 – RTRIM FUNCTION Challenge Solution 45.mp4 (6.43 MB)
488 – TRIM FUNCTION Challenge Solution 45.mp4 (7.09 MB)
489 – TRIM FUNCTION Challenge Solution 46.mp4 (3.91 MB)
490 – Understanding MySQL Session.mp4 (19.99 MB)
492 – Table Locking Intro.mp4 (5.75 MB)
493 – Table Locking Demonstration.mp4 (43.19 MB)
495 – Brief Introduction to SQL Transaction.mp4 (27.53 MB)
496 – TRANSACTION components START BEGIN BEGIN WORK COMMIT ROLLBACK SET.mp4 (7.09 MB)
498 – TRANSACTION By Example.mp4 (68.26 MB)
500 – NOT USING TRANSACTION.mp4 (16.09 MB)
502 – ROLLBACK.mp4 (42.16 MB)
504 – Meaning of VIEW.mp4 (31.35 MB)
506 – VIEW for Sales Manager Challenge Solution 1.mp4 (14.57 MB)
508 – VIEW for Employees hired in 1994 Challenge Solution 2.mp4 (19.85 MB)
510 – Updating VIEW Challenge Solution 3.mp4 (18.2 MB)
512 – A Mistake In VIEW Challenge Solution 4.mp4 (18.08 MB)
514 – Deleting a VIEW Challenge Solution 5.mp4 (7.97 MB)
516 – VIEW for Japan Suppliers Challenge Solution 6.mp4 (6.47 MB)
518 – WHERE with Normal Table VIEW Table Challenge Solution 7.mp4 (37.87 MB)
520 – INNER JOIN with Normal Table VIEW Table Challenge Solution 8.mp4 (13.58 MB)
522 – What is the meaning and purpose of Stored Procedure.mp4 (44.5 MB)
524 – How to create STORED PROCEDURE for cars table Challenge Solution 2.mp4 (61.8 MB)
526 – How to Modify STORED PROCEDURE Tesla Vehicles Challenge Solution 3.mp4 (54.61 MB)
528 – How to check for STORED PROCEDURE across databases Challenge Soln 4.mp4 (6.69 MB)
530 – Check for STORED PROCEDURE in the current database Challenge Solution 5.mp4 (10.86 MB)
532 – Check for STORED PROCEDURE in a specified database Challenge Soln 6.mp4 (14.18 MB)
534 – Deleting a STORED PROCEDURE Challenge Solution 7.mp4 (9.04 MB)
536 – STORED PROCEDURE Helping Purchasing Manager Challenge Solution 8.mp4 (96.86 MB)
538 – STORED PROCEDURE for Most Expensive Car Challenge Solution 9.mp4 (60.95 MB)
540 – STORED PROCEDURE for DATA INSERT to a table Challenge Solution 10.mp4 (41.25 MB)
542 – What is FUNCTION in SQL.mp4 (9.49 MB)
544 – Creating Addition FUNCTION Challenge Solution 2.mp4 (45.2 MB)
546 – How to check for FUNCTION Challenge Solution 3.mp4 (11.03 MB)
548 – Creating Pythagoras Theorem FUNCTION Challenge Solution 4.mp4 (21.32 MB)
550 – Altering or Updating FUNCTION Challenge Solution 5.mp4 (28.04 MB)
552 – Creating FUNCTION for Order details Line Total Challenge Solution 6.mp4 (37.35 MB)
554 – Deleting a FUNCTION Challenge Solution 7.mp4 (12.77 MB)
556 – The Purpose The How and Types of TRIGGER.mp4 (17.21 MB)
557 – TRIGGER More Explanation With Diagram.mp4 (9.08 MB)
558 – Steps to Creating a TRIGGER Challenge Solution 1a.mp4 (27.52 MB)
559 – Creating After Update TRIGGER Challenge Solution 1b.mp4 (114.32 MB)
561 – How to Check and Delete a TRIGGER Challenge Solution 1c.mp4 (2.07 MB)
563 – Creating After Update TRIGGER Another Method Challenge Solution 1d.mp4 (105.82 MB)
565 – Creating Conditional Update TRIGGER Different Names Challenge Solution 2.mp4 (137.44 MB)
567 – Creating AfterUpdate MySQL TRIGGER Above USD5k Challenge Solution 3.mp4 (81.92 MB)
569 – After Insert Error Message MySQL TRIGGER Challenge Solution 4.mp4 (59.47 MB)
571 – TRIGGER with SIGNAL SQLSTATE for Null Value Challenge Solution 5.mp4 (114.46 MB)
573 – Multiple lines of TRIGGER Many in One Challenge Solution 6.mp4 (117.05 MB)
575 – SQL SIGNAL SQLSTATE ERROR MESSAGE TRIGGER Challenge Solution 7.mp4 (20.34 MB)
577 – Fraud Detection After Delete TRIGGER Challenge Solution 8.mp4 (21.52 MB)
579 – Setting up database for challenges with attached downloadable resource.mp4 (14.62 MB)
580 – Nested Subquery JOIN methods 1million Challenge Solution 1.mp4 (29.76 MB)
582 – Nested Subquery Budget above average Challenge Solution 2.mp4 (10.27 MB)
584 – Nested Subquery More Query Tweaking Challenge Solution 3.mp4 (97.44 MB)
586 – Nested Subquery INNER JOIN GROUP BY HAVING Challenge Solution 4.mp4 (68.64 MB)
588 – Intro.mp4 (6.15 MB)
589 – CarShop Resource Details.mp4 (18.97 MB)
590 – Fetching Names of Cars Challenge Solution 1.mp4 (3.19 MB)
591 – Names Price of Cars Challenge Solution 2.mp4 (1.86 MB)
592 – Cars at a specific price Challenge Solution 3.mp4 (2.26 MB)
593 – Between two prices of cars Challenge Solution 4.mp4 (9.4 MB)
594 – Counting Cars Challenge Solution 5.mp4 (3.05 MB)
595 – Price List of Cars Challenge Solution 6.mp4 (8.25 MB)
596 – Price List For Cambodia Customers Challenge Solution 7.mp4 (56.2 MB)
597 – Car Average Price Challenge Solution 8.mp4 (2.63 MB)
598 – The most expensive car Challenge Solution 9.mp4 (5.51 MB)
599 – Most Expensive Cars Challenge Solution 10.mp4 (37.56 MB)
600 – Honda Toyota Challenge Solution 11.mp4 (15.96 MB)
601 – All details from two tables Challenge Solution 12.mp4 (9.21 MB)
602 – Specific fields from two tables Challenge Solution 13.mp4 (9.5 MB)
603 – Counting Cars Per Manufacturer Challenge Solution 14.mp4 (28.57 MB)
604 – Average Price Per Manufacturer Challenge Solution 15.mp4 (11.05 MB)
605 – Manufacturer Average Car Price Above 35000 Challenge Solution 16.mp4 (8.85 MB)
606 – The Cheapest Car Challenge Solution 17.mp4 (10.68 MB)
607 – The Most Expensive Car Challenge Solution 18.mp4 (35.97 MB)
608 – Data Insert Challenge Solution 19.mp4 (12.19 MB)
609 – Correcting Wrong Data Challenge Solution 20.mp4 (4.81 MB)
610 – Discounted Prices I Challenge Solution 21.mp4 (12.44 MB)
611 – Discounted Price II Challenge Solution 22.mp4 (4.98 MB)
612 – VIEW for price list Challenge Solution 23.mp4 (40.47 MB)
614 – What is the current database selected Assignment 1.mp4 (254.07 KB)
615 – What is the current database selected Assignment 1 Solution.mp4 (3.71 MB)
616 – What are the available tables in the database Assignment 2.mp4 (267.79 KB)
617 – What are the available tables in the database Assignment 2 Solution.mp4 (1.59 MB)
618 – Display the details of each of the table in the database Assignment 3.mp4 (478.97 KB)
619 – Display the details of each of the table in the database Assignment 3 Solution.mp4 (11.34 MB)
620 – SQL Query to retrieve data from one table Assignment 4.mp4 (350.75 KB)
621 – SQL Query to retrieve data from one table Solution to Assignment 4.mp4 (2.28 MB)
622 – Using Alias Assignment 5.mp4 (536.16 KB)
623 – Using Alias Solution to Assignment 5.mp4 (6.2 MB)
624 – Retrieving data across two tables using JOIN Assignment 6.mp4 (5.66 MB)
625 – Retrieving data across two tables using JOIN Solution to Assignment 6.mp4 (20.04 MB)
626 – Retrieving data across three tables using JOIN Assignment 7.mp4 (3.8 MB)
627 – Retrieving data across three tables using JOIN Solution to Assignment 7.mp4 (19.39 MB)
628 – Aggregate sum average minimum maximum Assignment 8.mp4 (942.7 KB)
629 – Aggregate sum average minimum maximum Solution to Assignment 8.mp4 (15.89 MB)
630 – GROUP BY Average Assignment 9.mp4 (754.79 KB)
631 – GROUP BY Average Solution to Assignment 9.mp4 (24.75 MB)
632 – GROUP BY RIGHT LEFT INNER NO JOIN Assignment 10.mp4 (6.75 MB)
633 – GROUP BY RIGHT LEFT INNER NO JOIN Solution to Assignment 10.mp4 (55.07 MB)
634 – VIEW for three tables JOIN Assignment 11.mp4 (1.9 MB)
635 – VIEW for three tables JOIN Solution to Assignment 11.mp4 (19.13 MB)
636 – INNER JOIN Subquery EXISTS Assignment 12.mp4 (435.52 KB)
637 – INNER JOIN Subquery EXISTS Solution to Assignment 12.mp4 (18.38 MB)
638 – Updating Table with 5 Increase in Salary Assignment 13.mp4 (425.9 KB)
639 – Updating Table with 5 Increase in Salary Solution Assignment 13.mp4 (2.43 MB)
640 – INNER JOIN and SubQuery Assignment 14.mp4 (16.17 MB)
641 – INNER JOIN and SubQuery Solution Assignment 14.mp4 (42 MB)
642 – INNER JOIN AND Assignment 15.mp4 (399.37 KB)
643 – INNER JOIN AND Solution Assignment 15.mp4 (10.3 MB)
644 – INNER JOIN SubQuery Assignment 16.mp4 (368.34 KB)
645 – INNER JOIN SubQuery Solution to Assignment 16.mp4 (10.95 MB)
646 – SUBQUERY LIMIT Assignment 17.mp4 (372.3 KB)
647 – SUBQUERY LIMIT Solution to Assignment 17.mp4 (15.56 MB)
648 – UCASE Assignment 18.mp4 (352.82 KB)
649 – UCASE Solution to Assignment 18.mp4 (1.1 MB)
651 – Employees With Same Salary Task 1.mp4 (290.38 KB)
652 – Solution Employees With Same Salary Task 1.mp4 (75.05 MB)
654 – Duplicate Title Task 2.mp4 (248.4 KB)
655 – Solution Duplicate Title Task 2.mp4 (4.02 MB)
657 – Excluding Titles Task 3.mp4 (422.58 KB)
658 – Solution Excluding Titles Task 3.mp4 (2.59 MB)
660 – Eight Last Alphabet n Task 4.mp4 (394.91 KB)
661 – Solution Eight Last Alphabet n Task 4.mp4 (2.53 MB)
663 – Even Rows Task 5.mp4 (197.86 KB)
664 – Solution Even Rows Task 5.mp4 (3.68 MB)
666 – Odd Rows Task 6.mp4 (147.17 KB)
667 – Solution Odd Rows Task 6.mp4 (3.77 MB)
669 – Second to Fourth Task 7.mp4 (301.24 KB)
670 – Solution Second to Fourth Task 7.mp4 (2.01 MB)
672 – Counting Employee with SALES Task 8.mp4 (175.26 KB)
673 – Solution Counting Employee with SALES Task 8.mp4 (845.39 KB)
675 – Using Sub Query Second to the Highest Salary Task 9.mp4 (529.39 KB)
676 – Solution Using Sub Query Second to the Highest Salary Task 9.mp4 (13.7 MB)
678 – Tricky Exercise Task 10.mp4 (362.81 KB)
679 – Solution Tricky Exercise Task 10.mp4 (3.71 MB)
681 – Tricky Exercise Task 11.mp4 (1.36 MB)
682 – Solution Tricky Exercise Task 11.mp4 (38.96 MB)
684 – Tricky Exercise Task 12.mp4 (360.43 KB)
685 – Solution Tricky Exercise Task 12.mp4 (77.12 MB)
687 – Tricky Exercise Task 12b.mp4 (794.75 KB)
688 – Solution Tricky Exercise Task 12b.mp4 (2.96 MB)
690 – Tricky Exercise Task 13.mp4 (565.78 KB)
691 – Solution Tricky Exercise Task 13.mp4 (38.45 MB)
693 – Tricky Exercise Task 14.mp4 (430.53 KB)
694 – Solution Tricky Exercise Task 14.mp4 (30.75 MB)
696 – Using Fewer Columns From SUBQUERY With JOIN.mp4 (80.75 MB)
698 – Using WITH SUBQUERY INNER JOIN.mp4 (13.27 MB)
700 – Tricky Exercise Task 15.mp4 (1.91 MB)
701 – Solution Tricky Exercise Task 15.mp4 (49.06 MB)
703 – Tricky Exercise task 16.mp4 (291.16 KB)
704 – Solution Tricky Exercise task 16.mp4 (1.92 MB)
706 – Tricky Exercise Task 17.mp4 (522.77 KB)
707 – Solution Tricky Exercise Task 17.mp4 (102.9 MB)
709 – Introduction.mp4 (4.31 MB)
710 – Day of the Week.mp4 (11.54 MB)
711 – Day of the Month.mp4 (5.25 MB)
712 – Day of the Year.mp4 (3.52 MB)
713 – Week of the Year.mp4 (6.31 MB)
714 – Month of the Year.mp4 (3.87 MB)
715 – Year from given DateTime.mp4 (1.09 MB)
716 – Second Minute Hour AM and PM from DateTime.mp4 (7.86 MB)
717 – Tricky Exercise Task 18.mp4 (1.81 MB)
718 – Solution Tricky Exercise Task 18.mp4 (39.96 MB)
720 – Introduction to Combining SQL and Python.mp4 (4.87 MB)
721 – Installation of MySQL Connector for Python.mp4 (18.12 MB)
723 – Creating Database Show Databases From Python.mp4 (50.2 MB)
725 – Creating a Table Show Table Describe Table.mp4 (10.78 MB)
727 – Insert A Row of Data Into A Table Select.mp4 (25.24 MB)
729 – Insert Multiple Rows of Data Into A Table.mp4 (34.27 MB)
731 – Counting the numbers of rows.mp4 (2.7 MB)
733 – FetchOne vs FetchAll.mp4 (6.09 MB)
735 – Select Filter with Python.mp4 (5.66 MB)
737 – SQL Wildcard with Python.mp4 (31.22 MB)
740 – Business Intelligence Introduction Definition.mp4 (12.56 MB)
741 – Business Intelligence Process.mp4 (10.54 MB)
742 – How to Download and Install Tableau.mp4 (10.29 MB)
743 – Tableau WhatIsWhat In Tableau I.mp4 (7.95 MB)
744 – Tableau WhatIsWhat In Tableau II.mp4 (24.15 MB)
745 – Tableau WhatIsWhat In Tableau III.mp4 (4.3 MB)
746 – Connecting MySQL to Tableau.mp4 (21.34 MB)
747 – Tableau MySQL Querying SQL Database from Tableau.mp4 (4.97 MB)
748 – Tableau MySQL Visualising CarShop Dataset.mp4 (45.58 MB)
749 – Tableau SQL Challenge Gross Sales and Net Sales Report.mp4 (24.62 MB)]
Screenshot
MixWithTheMasters – Teezio mixing ‘Freak’ by Chris Brown (1.65 GB)
The Sandbox
