13.55 GB | 24min 57s | mp4 | 1920X1080 | 16:9
Genre:eLearning |Language:English

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