SQL-MySQL Complete Master Bootcamp Beginner-Expert (2024)

[0dayddl]

Download Free Download : SQL-MySQL Complete Master Bootcamp Beginner-Expert (2024)
mp4 | Video: h264,1920X1080 | Audio: AAC, 44.1 KHz
Genre:eLearning | Language: English | Size:13.55 GB

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

Contenido oculto. Ha de estar registrado, y pulsar el botón "Gracias" para visualizar sus enlaces de descarga.
Si trás registrarse todavía no visualiza el botón de "gracias", pulse la tecla F5, para refrescar la página.

Contenido oculto. Ha de estar registrado, y pulsar el botón "Gracias" para visualizar sus enlaces de descarga.
Si trás registrarse todavía no visualiza el botón de "gracias", pulse la tecla F5, para refrescar la página.

Free search engine download: SQL-MySQL Complete Master Bootcamp Beginner-Expert (2024)