https://img100.pixhost.to/images/404/537368816_que-es-udemy-analisis-opiniones.jpg
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
Видео
