Udemy SQL MySQL Complete Master Bootcamp Beginner Expert 2024

Files Included :

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