| 1. Introduction to databases, SQL, and MySQL | |||
| 1. What does the course cover.mp4 | 24.26 MB | ||
| 1. What does the course cover.srt | 6.57 KB | ||
| 2. Why SQL.mp4 | 14.75 MB | ||
| 2. Why SQL.srt | 4.73 KB | ||
| 2.1 SQL - FAQ.pdf.pdf | 1.16 MB | ||
| 3. Why SQL.html | 164 B | ||
| 4. Why MySQL.mp4 | 6.54 MB | ||
| 4. Why MySQL.srt | 2.88 KB | ||
| 5. Why MySQL.html | 164 B | ||
| 6. Introduction to databases.mp4 | 19.6 MB | ||
| 6. Introduction to databases.srt | 7.07 KB | ||
| 7. Introduction to databases.html | 164 B | ||
| 10. SQL INSERT statement | |||
| 1. The INSERT statement - Part I.mp4 | 14.42 MB | ||
| 1. The INSERT statement - Part I.srt | 6.93 KB | ||
| 1.1 The INSERT Statement.pdf.pdf | 371.78 KB | ||
| 2. The INSERT statement - Part II.mp4 | 6.67 MB | ||
| 2. The INSERT statement - Part II.srt | 2.58 KB | ||
| 3. The INSERT statement - exercise 1.html | 1.43 KB | ||
| 4. The INSERT statement - solution 1.html | 1.23 KB | ||
| 5. The INSERT statement - exercise 2.html | 372 B | ||
| 6. The INSERT statement - solution 2.html | 1.12 KB | ||
| 7. Inserting data INTO a new table.mp4 | 9.62 MB | ||
| 7. Inserting data INTO a new table.srt | 4.52 KB | ||
| 7.1 Inserting Data INTO a New Table.pdf.pdf | 302.31 KB | ||
| 8. Inserting Data INTO a New Table - exercise.html | 181 B | ||
| 9. Inserting Data INTO a New Table - solution.html | 85 B | ||
| 11. SQL UPDATE Statement | |||
| 1. TCL's COMMIT and ROLLBACK.mp4 | 7.82 MB | ||
| 1. TCL's COMMIT and ROLLBACK.srt | 3.12 MB | ||
| 1.1 TCL's COMMIT and ROLLBACK.pdf.pdf | 580.19 KB | ||
| 2. The UPDATE Statement - Part I.mp4 | 7.91 MB | ||
| 2. The UPDATE Statement - Part I.srt | 3.63 KB | ||
| 2.1 The UPDATE Statement.pdf.pdf | 455.86 KB | ||
| 3. ROLLBACK; ARTICLE.html | 1.36 KB | ||
| 4. The UPDATE Statement - Part II.mp4 | 7.39 MB | ||
| 4. The UPDATE Statement - Part II.srt | 3.42 KB | ||
| 5. The UPDATE Statement – Part II - exercise.html | 172 B | ||
| 6. The UPDATE Statement – Part II - solution.html | 257 B | ||
| 12. SQL DELETE Statement | |||
| 1. The DELETE Statement - Part I.mp4 | 10.31 MB | ||
| 1. The DELETE Statement - Part I.srt | 4.89 KB | ||
| 1.1 The DELETE Statement.pdf.pdf | 360.6 KB | ||
| 2. The DELETE Statement - Part II.mp4 | 3.69 MB | ||
| 2. The DELETE Statement - Part II.srt | 1.79 KB | ||
| 3. The DELETE Statement – Part II - exercise.html | 79 B | ||
| 4. The DELETE Statement – Part II - solution.html | 148 B | ||
| 5. DROP vs TRUNCATE vs DELETE.mp4 | 7.48 MB | ||
| 5. DROP vs TRUNCATE vs DELETE.srt | 3.97 KB | ||
| 5.1 DROP vs TRUNCATE vs DELETE.pdf.pdf | 1.02 MB | ||
| 6. DROP vs TRUNCATE vs DELETE.html | 165 B | ||
| 13. MySQL - Aggregate functions | |||
| 1. COUNT().mp4 | 9.24 MB | ||
| 1. COUNT().srt | 5.21 KB | ||
| 1.1 COUNT().pdf.pdf | 1.07 MB | ||
| 10. AVG().mp4 | 4.16 MB | ||
| 10. AVG().srt | 2.56 KB | ||
| 10.1 AVG().pdf.pdf | 442.81 KB | ||
| 11. AVG() - exercise.html | 112 B | ||
| 12. AVG() - solution.html | 307 B | ||
| 13. ROUND().mp4 | 4.74 MB | ||
| 13. ROUND().srt | 2.58 KB | ||
| 13.1 ROUND().pdf.pdf | 334.72 KB | ||
| 14. ROUND() - exercise.html | 155 B | ||
| 15. ROUND() - solution.html | 301 B | ||
| 16. COALESCE() - Preamble.html | 28 B | ||
| 16.1 COALESCE() - Preamble.pdf.pdf | 581.89 KB | ||
| 17. IFNULL() and COALESCE().mp4 | 15.76 MB | ||
| 17. IFNULL() and COALESCE().srt | 7.4 KB | ||
| 17.1 IFNULL() and COALESCE().pdf.pdf | 715.62 KB | ||
| 18. Another Example of Using COALESCE().mp4 | 3.7 MB | ||
| 18. Another Example of Using COALESCE().srt | 1.96 KB | ||
| 19. Another example of using COALESCE() - exercise 1.html | 238 B | ||
| 2. COUNT() - exercise.html | 123 B | ||
| 20. Another example of using COALESCE() - solution 1.html | 383 B | ||
| 21. Another example of using COALESCE() - exercise 2.html | 320 B | ||
| 22. Another example of using COALESCE() - solution 2.html | 570 B | ||
| 23. Another example of using COALESCE().html | 165 B | ||
| 3. COUNT() - solution.html | 196 B | ||
| 4. SUM().mp4 | 3.23 MB | ||
| 4. SUM().srt | 1.86 KB | ||
| 4.1 SUM().pdf.pdf | 494.07 KB | ||
| 5. SUM() - exercise.html | 127 B | ||
| 6. SUM() - solution.html | 291 B | ||
| 7. MIN() and MAX().mp4 | 2.97 MB | ||
| 7. MIN() and MAX().srt | 1.56 KB | ||
| 7.1 MIN() and MAX().pdf.pdf | 284.85 KB | ||
| 8. MIN() and MAX() - exercise.html | 130 B | ||
| 9. MIN() and MAX() - solution.html | 471 B | ||
| 14. SQL Joins | |||
| 1. Introduction to JOINs.mp4 | 7.23 MB | ||
| 1. Introduction to JOINs.srt | 5.08 KB | ||
| 1.1 Introduction to Joins.pdf.pdf | 775.87 KB | ||
| 10. Duplicate Records.mp4 | 12.73 MB | ||
| 10. Duplicate Records.srt | 5.26 KB | ||
| 10.1 Duplicate Records.pdf.pdf | 336.98 KB | ||
| 11. LEFT JOIN - Part I.mp4 | 14.02 MB | ||
| 11. LEFT JOIN - Part I.srt | 5.8 KB | ||
| 11.1 LEFT JOIN.pdf.pdf | 739.04 KB | ||
| 12. LEFT JOIN - Part II.mp4 | 14.83 MB | ||
| 12. LEFT JOIN - Part II.srt | 6.99 KB | ||
| 13. LEFT JOIN - Part II - exercise.html | 455 B | ||
| 14. LEFT JOIN - Part II - solution.html | 657 B | ||
| 15. RIGHT JOIN.mp4 | 32.09 MB | ||
| 15. RIGHT JOIN.srt | 5.1 KB | ||
| 15.1 RIGHT JOIN.pdf.pdf | 856.26 KB | ||
| 16. The new and the old join syntax.mp4 | 9.18 MB | ||
| 16. The new and the old join syntax.srt | 5.33 KB | ||
| 16.1 The New and the Old Join Syntax.pdf.pdf | 718.72 KB | ||
| 17. The new and the old join syntax - exercise.html | 192 B | ||
| 18. The new and the old join syntax - solution.html | 1.25 KB | ||
| 19. JOIN and WHERE Used Together.mp4 | 6.55 MB | ||
| 19. JOIN and WHERE Used Together.srt | 3.47 KB | ||
| 19.1 JOIN and WHERE Used Together.pdf.pdf | 397.99 KB | ||
| 2. Intro to JOINs - exercise 1.html | 974 B | ||
| 20. Important – Prevent Error Code 1055!.html | 3.42 KB | ||
| 21. JOIN and WHERE Used Together - exercise.html | 169 B | ||
| 22. JOIN and WHERE Used Together - solution.html | 722 B | ||
| 23. CROSS JOIN.mp4 | 89.99 MB | ||
| 23. CROSS JOIN.srt | 9.89 KB | ||
| 23.1 CROSS JOIN.pdf.pdf | 313.67 KB | ||
| 24. CROSS JOIN - exercise 1.html | 150 B | ||
| 25. CROSS JOIN - solution 1.html | 407 B | ||
| 26. CROSS JOIN - exercise 2.html | 162 B | ||
| 27. CROSS JOIN - solution 2.html | 566 B | ||
| 28. Using Aggregate Functions with Joins.mp4 | 6.22 MB | ||
| 28. Using Aggregate Functions with Joins.srt | 2.79 KB | ||
| 29. JOIN more than two tables in SQL.mp4 | 10.94 MB | ||
| 29. JOIN more than two tables in SQL.srt | 4.83 KB | ||
| 29.1 JOIN More Than Two Tables in SQL.pdf.pdf | 624.23 KB | ||
| 3. Intro to JOINs - solution 1.html | 1.59 KB | ||
| 30. Join more than two tables in SQL - exercise.html | 109 B | ||
| 31. Join more than two tables in SQL - solution.html | 2.42 KB | ||
| 32. Tips and tricks for joins.mp4 | 50.92 MB | ||
| 32. Tips and tricks for joins.srt | 6.84 KB | ||
| 32.1 Tips and Tricks for Joins.pdf.pdf | 479.19 KB | ||
| 33. Tips and tricks for joins - exercise.html | 93 B | ||
| 34. Tips and tricks for joins - solution.html | 408 B | ||
| 35. UNION vs UNION ALL.mp4 | 8.54 MB | ||
| 35. UNION vs UNION ALL.srt | 6.33 KB | ||
| 35.1 UNION vs UNION ALL.pdf.pdf | 823.75 KB | ||
| 36. UNION vs UNION ALL - exercise.html | 179 B | ||
| 37. UNION vs UNION ALL - solution.html | 1.73 KB | ||
| 4. Intro to JOINs - exercise 2.html | 1.63 KB | ||
| 5. INNER JOIN - Part I.mp4 | 12.42 MB | ||
| 5. INNER JOIN - Part I.srt | 6.78 KB | ||
| 5.1 INNER JOIN.pdf.pdf | 778.46 KB | ||
| 6. INNER JOIN - Part II.mp4 | 11.62 MB | ||
| 6. INNER JOIN - Part II.srt | 6.64 KB | ||
| 7. INNER JOIN - Part II - exercise.html | 144 B | ||
| 8. INNER JOIN - Part II - solution.html | 621 B | ||
| 9. A Note on Using Joins.mp4 | 10.77 MB | ||
| 9. A Note on Using Joins.srt | 5.01 KB | ||
| 15. SQL Subqueries | |||
| 1. SQL Subqueries with IN nested inside WHERE.mp4 | 6.72 MB | ||
| 1. SQL Subqueries with IN nested inside WHERE.srt | 5.04 KB | ||
| 1.1 Subqueries IN WHERE.pdf.pdf | 1.07 MB | ||
| 10. SQL Subqueries nested in SELECT and FROM - exercise 2.html | 1.11 KB | ||
| 11. SQL Subqueries nested in SELECT and FROM - solution 2.html | 15 B | ||
| 11.1 Subqueries SELECT FROM Solution.sql.sql | 1.85 KB | ||
| 2. SQL Subqueries with IN nested inside WHERE - exercise.html | 162 B | ||
| 3. SQL Subqueries with IN nested inside WHERE - solution.html | 785 B | ||
| 4. SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE.mp4 | 8.65 MB | ||
| 4. SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE.srt | 4.21 KB | ||
| 4.1 Subqueries EXISTS WHERE.pdf.pdf | 1 MB | ||
| 5. SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - exercise.html | 185 B | ||
| 6. SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - solution.html | 900 B | ||
| 7. SQL Subqueries nested in SELECT and FROM.mp4 | 19.91 MB | ||
| 7. SQL Subqueries nested in SELECT and FROM.srt | 8.63 KB | ||
| 7.1 Subqueries SELECT FROM.pdf.pdf | 403.81 KB | ||
| 8. SQL Subqueries nested in SELECT and FROM - exercise 1.html | 215 B | ||
| 9. SQL Subqueries nested in SELECT and FROM - solution 1.html | 366 B | ||
| 16. SQL Self Join | |||
| 1. Self Join.mp4 | 20.83 MB | ||
| 1. Self Join.srt | 8.65 KB | ||
| 1.1 SQL Self Join.pdf.pdf | 703.86 KB | ||
| 2. Self join.html | 165 B | ||
| 17. SQL Views | |||
| 1. Views.mp4 | 17.48 MB | ||
| 1. Views.srt | 8.13 KB | ||
| 1.1 SQL Views.pdf.pdf | 1.01 MB | ||
| 2. Views - exercise.html | 288 B | ||
| 3. Views - solution.html | 566 B | ||
| 18. Stored routines | |||
| 1. Introduction to stored routines.mp4 | 7.24 MB | ||
| 1. Introduction to stored routines.srt | 4.56 KB | ||
| 1.1 Introduction to Stored Routines.pdf.pdf | 729.67 KB | ||
| 10. Stored procedures with an output parameter.mp4 | 8.52 MB | ||
| 10. Stored procedures with an output parameter.srt | 4 KB | ||
| 10.1 Stored Procedures with an Output Parameter.pdf.pdf | 429.39 KB | ||
| 11. Stored procedures with an output parameter - exercise.html | 152 B | ||
| 12. Stored procedures with an output parameter - solution.html | 1.68 KB | ||
| 13. Variables.mp4 | 15.97 MB | ||
| 13. Variables.srt | 7.5 KB | ||
| 13.1 Variables.pdf.pdf | 718.33 KB | ||
| 14. Variables - exercise.html | 305 B | ||
| 15. Variables - solution.html | 162 B | ||
| 16. User-defined functions in MySQL.mp4 | 48.76 MB | ||
| 16. User-defined functions in MySQL.srt | 7.32 KB | ||
| 16.1 User-Defined Functions in MySQL.pdf.pdf | 511.99 KB | ||
| 17. Error Code 1418..html | 2.84 KB | ||
| 18. User-defined functions in MySQL - exercise.html | 434 B | ||
| 19. User-defined functions in MySQL - solution.html | 1.78 KB | ||
| 2. Introduction to Stored Routines.html | 37.84 MB | ||
| 20. Stored routines - conclusion.mp4 | 8.18 MB | ||
| 20. Stored routines - conclusion.srt | 4.69 KB | ||
| 20.1 Stored Routines - Conclusion.pdf.pdf | 723.87 KB | ||
| 21. Stored routines - conclusion.html | 165 B | ||
| 3. The MySQL syntax for stored procedures.mp4 | 5.97 MB | ||
| 3. The MySQL syntax for stored procedures.srt | 5.7 KB | ||
| 3.1 The MySQL Syntax for Stored Procedures.pdf.pdf | 911.08 KB | ||
| 4. Stored procedures - Example - Part I.mp4 | 7.24 MB | ||
| 4. Stored procedures - Example - Part I.srt | 3.35 KB | ||
| 5. Stored procedures - Example - Part II.mp4 | 11.17 MB | ||
| 5. Stored procedures - Example - Part II.srt | 6.13 KB | ||
| 6. Stored procedures - Example - Part II - exercise.html | 116 B | ||
| 7. Stored procedures - Example - Part II - solution.html | 1.09 KB | ||
| 8. Another way to create a procedure.mp4 | 5.43 MB | ||
| 8. Another way to create a procedure.srt | 3.62 KB | ||
| 9. Stored procedures with an input parameter.mp4 | 17.07 MB | ||
| 9. Stored procedures with an input parameter.srt | 7.56 KB | ||
| 9.1 Stored Procedures with an Input Parameter.pdf.pdf | 547.71 KB | ||
| 19. Advanced SQL Topics | |||
| 1. Types of MySQL Variables - Local Variables.mp4 | 11.58 MB | ||
| 1. Types of MySQL Variables - Local Variables.srt | 5.73 KB | ||
| 1.1 Types of MySQL Variables - Local Variables.pdf.pdf | 866.29 KB | ||
| 10. MySQL Triggers - exercise.html | 191 B | ||
| 11. MySQL Triggers - solution.html | 1.29 KB | ||
| 12. MySQL Indexes.mp4 | 18.21 MB | ||
| 12. MySQL Indexes.srt | 8.25 KB | ||
| 12.1 MySQL Indexes.pdf.pdf | 1.29 MB | ||
| 13. MySQL Indexes - exercise 1.html | 40 B | ||
| 14. MySQL Indexes - solution 1.html | 159 B | ||
| 15. MySQL Indexes - exercise 2.html | 255 B | ||
| 16. MySQL Indexes - solution 2.html | 683 B | ||
| 17. The CASE Statement.mp4 | 59.41 MB | ||
| 17. The CASE Statement.srt | 6.86 KB | ||
| 17.1 The CASE Statement.pdf.pdf | 302.12 KB | ||
| 18. The CASE Statement - exercise 1.html | 362 B | ||
| 19. The CASE Statement - solution 1.html | 737 B | ||
| 2. Types of MySQL Variables - Local Variables.html | 165 B | ||
| 20. The CASE Statement - exercise 2.html | 376 B | ||
| 21. The CASE Statement - solution 2.html | 1.76 KB | ||
| 22. The CASE Statement - exercise 3.html | 411 B | ||
| 23. The CASE Statement - solution 3.html | 744 B | ||
| 3. Session Variables.mp4 | 11.97 MB | ||
| 3. Session Variables.srt | 6.56 KB | ||
| 3.1 Session Variables.pdf.pdf | 1.82 MB | ||
| 4. Session Variables.html | 165 B | ||
| 5. Global Variables.mp4 | 5.01 MB | ||
| 5. Global Variables.srt | 2.72 KB | ||
| 5.1 Global Variables.pdf.pdf | 676.25 KB | ||
| 6. Global Variables.html | 165 B | ||
| 7. User-Defined vs System Variables.mp4 | 10.96 MB | ||
| 7. User-Defined vs System Variables.srt | 5.07 KB | ||
| 7.1 User-Defined vs System Variables.pdf.pdf | 699.41 KB | ||
| 8. User-Defined vs System Variables.html | 165 B | ||
| 9. MySQL Triggers.html | 537 B | ||
| 9.1 MySQL Triggers.sql.sql | 9.73 KB | ||
| 2. SQL theory | |||
| 1. SQL as a declarative language.mp4 | 10.09 MB | ||
| 1. SQL as a declarative language.srt | 3.07 KB | ||
| 1.1 Course Notes SQL - MySQL for Data Analytics and Business Intelligence.html | 134 B | ||
| 10. Data control language (DCL).html | 164 B | ||
| 11. Transaction control language (TCL).mp4 | 6.87 MB | ||
| 11. Transaction control language (TCL).srt | 4.42 KB | ||
| 11.1 TCL.pdf.pdf | 965.74 KB | ||
| 12. Transaction control language (TCL).html | 164 B | ||
| 2. SQL as a declarative language.html | 164 B | ||
| 3. Data definition language (DDL).mp4 | 8.69 MB | ||
| 3. Data definition language (DDL).srt | 6.15 KB | ||
| 3.1 DDL.pdf.pdf | 1.26 MB | ||
| 4. Data definition language (DDL).html | 164 B | ||
| 5. SQL keywords.mp4 | 2.48 MB | ||
| 5. SQL keywords.srt | 1.79 KB | ||
| 5.1 SQL Keywords.pdf.pdf | 533.09 KB | ||
| 6. SQL keywords.html | 164 B | ||
| 7. Data manipulation language (DML).mp4 | 9.99 MB | ||
| 7. Data manipulation language (DML).srt | 6.37 KB | ||
| 7.1 DML.pdf.pdf | 913.21 KB | ||
| 8. Data manipulation language (DML).html | 164 B | ||
| 9. Data control language (DCL).mp4 | 8.06 MB | ||
| 9. Data control language (DCL).srt | 6.9 KB | ||
| 9.1 DCL.pdf.pdf | 682.67 KB | ||
| 20. Combining SQL and Tableau - Introduction | |||
| 1. The Advantages of Software Integration.mp4 | 92.4 MB | ||
| 1. The Advantages of Software Integration.srt | 7.08 KB | ||
| 2. Why Combining SQL and Tableau is useful.mp4 | 85.35 MB | ||
| 2. Why Combining SQL and Tableau is useful.srt | 6.28 KB | ||
| 3. Installing Tableau Public.mp4 | 27.36 MB | ||
| 3. Installing Tableau Public.srt | 2.24 KB | ||
| 4. Loading the 'employees_mod' Database.mp4 | 28.53 MB | ||
| 4. Loading the 'employees_mod' Database.srt | 4 KB | ||
| 4.1 employees_mod_db.pdf.pdf | 129.65 KB | ||
| 4.2 The 'employees_mod' Database.html | 125 B | ||
| 5. Loading the 'employees_mod' Database.html | 613 B | ||
| 5.1 The 'employees_mod' database.html | 125 B | ||
| 5.2 employees_mod_db.pdf.pdf | 129.65 KB | ||
| 21. Combining SQL and Tableau - Task 1 | |||
| 1. Task 1.mp4 | 33.53 MB | ||
| 1. Task 1.srt | 7.13 KB | ||
| 2. Task 1 - Text.html | 149 B | ||
| 3. Important clarification!.html | 1.41 KB | ||
| 4. Task 1 SQL Solution.mp4 | 43.16 MB | ||
| 4. Task 1 SQL Solution.srt | 5.62 KB | ||
| 5. Task 1 SQL Solution - Code.html | 537 B | ||
| 6. Transferring a Dataset from SQL to Tableau.mp4 | 31.43 MB | ||
| 6. Transferring a Dataset from SQL to Tableau.srt | 5.05 KB | ||
| 7. Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I.mp4 | 40.54 MB | ||
| 7. Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I.srt | 7.46 KB | ||
| 8. Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II.mp4 | 45.1 MB | ||
| 8. Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II.srt | 6.8 KB | ||
| 22. Combining SQL and Tableau - Task 2 | |||
| 1. Task 2.mp4 | 28.85 MB | ||
| 1. Task 2.srt | 4.64 KB | ||
| 2. Task 2 - Text.html | 137 B | ||
| 3. Task 2 SQL Solution.mp4 | 39.28 MB | ||
| 3. Task 2 SQL Solution.srt | 4.28 KB | ||
| 4. Task 2 SQL Solution - Code.html | 787 B | ||
| 5. Chart 2 Visualizing and Analyzing the Solution in Tableau.mp4 | 48.93 MB | ||
| 5. Chart 2 Visualizing and Analyzing the Solution in Tableau.srt | 7.33 KB | ||
| 23. Combining SQL and Tableau - Task 3 | |||
| 1. Task 3.mp4 | 13.07 MB | ||
| 1. Task 3.srt | 2.84 KB | ||
| 2. Task 3 - Text.html | 167 B | ||
| 3. Task 3 SQL Solution.mp4 | 33.12 MB | ||
| 3. Task 3 SQL Solution.srt | 3.88 KB | ||
| 4. Task 3 SQL Solution - Code.html | 502 B | ||
| 5. Chart 3 Visualizing and Analyzing the Solution in Tableau.mp4 | 40.32 MB | ||
| 5. Chart 3 Visualizing and Analyzing the Solution in Tableau.srt | 5.81 KB | ||
| 24. Combining SQL and Tableau - Task 4 | |||
| 1. Task 4.mp4 | 23.57 MB | ||
| 1. Task 4.srt | 3.6 KB | ||
| 2. Task 4 - Text.html | 325 B | ||
| 3. Task 4 Solution in SQL.mp4 | 30.26 MB | ||
| 3. Task 4 Solution in SQL.srt | 3.14 KB | ||
| 4. Task 4 Solution in SQL - Code.html | 697 B | ||
| 5. Chart 4 Visualizing and Analyzing the Solution in Tableau.mp4 | 22.28 MB | ||
| 5. Chart 4 Visualizing and Analyzing the Solution in Tableau.srt | 3.78 KB | ||
| 25. Combining SQL and Tableau - Task 5 | |||
| 1. Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau.mp4 | 55.98 MB | ||
| 1. Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau.srt | 6.69 KB | ||
| 26. Practice SQL – 10 Final Query Questions | |||
| 1. Practice SQL – 10 Final Query Questions.html | 1.02 KB | ||
| 1.1 Practice SQL – 10 Final Query Questions - SOLUTIONS.sql.sql | 7.04 KB | ||
| 1.2 Practice SQL - 10 Final Query Questions.pdf.pdf | 557.57 KB | ||
| 27. BONUS LECTURE | |||
| 1. Bonus Lecture Next Steps.html | 1.96 KB | ||
| 3. Basic database terminology | |||
| 1. Relational database essentials.mp4 | 22.98 MB | ||
| 1. Relational database essentials.srt | 6.67 KB | ||
| 10. Relational schemas - Foreign key.html | 164 B | ||
| 11. Relational schemas - Unique key and null values.mp4 | 6.35 MB | ||
| 11. Relational schemas - Unique key and null values.srt | 4.42 KB | ||
| 11.1 Relational Schemas - Unique Key and Null Values.pdf.pdf | 773.82 KB | ||
| 12. Relational Schemas - Unique key.html | 164 B | ||
| 13. Relationships.mp4 | 9.74 MB | ||
| 13. Relationships.srt | 6.24 KB | ||
| 13.1 Relationships.pdf.pdf | 1.36 MB | ||
| 14. Relational Schemas – Relationships.html | 164 B | ||
| 2. Relational database essentials.html | 164 B | ||
| 3. Databases vs spreadsheets.mp4 | 169.95 MB | ||
| 3. Databases vs spreadsheets.srt | 11.55 KB | ||
| 4. Databases vs spreadsheets.html | 164 B | ||
| 5. Database terminology.mp4 | 18.97 MB | ||
| 5. Database terminology.srt | 6.1 KB | ||
| 6. Database terminology.html | 164 B | ||
| 7. Relational schemas - Primary key.mp4 | 10.42 MB | ||
| 7. Relational schemas - Primary key.srt | 6.96 KB | ||
| 7.1 Relational Schemas - Primary Key.pdf.pdf | 1.26 MB | ||
| 8. Relational schemas - Primary key.html | 164 B | ||
| 9. Relational schemas - Foreign key.mp4 | 10.36 MB | ||
| 9. Relational schemas - Foreign key.srt | 6.88 KB | ||
| 9.1 Relational Schemas - Foreign Key.pdf.pdf | 960.36 KB | ||
| 4. Installing MySQL and getting acquainted with the interface | |||
| 1. Installing MySQL.mp4 | 89.8 MB | ||
| 1. Installing MySQL.srt | 12.65 KB | ||
| 2. Additional note – Installing – Visual C.html | 835 B | ||
| 3. Installing MySQL on macOS and Unix systems.html | 2.07 KB | ||
| 4. The Client-Server Model.html | 30 B | ||
| 4.1 The Client-Server Model.pdf.pdf | 556.9 KB | ||
| 5. Setting up a connection.mp4 | 6.14 MB | ||
| 5. Setting up a connection.srt | 3.33 KB | ||
| 6. Read me!!!.html | 1 KB | ||
| 7. New Authentication Plugin - Creating a New User.mp4 | 47.72 MB | ||
| 7. New Authentication Plugin - Creating a New User.srt | 6.73 KB | ||
| 8. Introduction to the MySQL interface.mp4 | 11.91 MB | ||
| 8. Introduction to the MySQL interface.srt | 6.27 KB | ||
| 5. First steps in SQL | |||
| 1. Creating a Database - Part I.mp4 | 10.36 MB | ||
| 1. Creating a Database - Part I.srt | 7.15 KB | ||
| 1.1 Creating a Database - Part I.pdf.pdf | 793.56 KB | ||
| 10. String data types.mp4 | 9.14 MB | ||
| 10. String data types.srt | 6.29 KB | ||
| 10.1 String Data Types.pdf.pdf | 443.28 KB | ||
| 11. String data types.html | 164 B | ||
| 12. Integers.mp4 | 8.83 MB | ||
| 12. Integers.srt | 5.09 KB | ||
| 12.1 Integers.pdf.pdf | 656.05 KB | ||
| 13. Integers.html | 164 B | ||
| 14. Fixed and floating-point data types.mp4 | 11.78 MB | ||
| 14. Fixed and floating-point data types.srt | 7.25 KB | ||
| 14.1 Fixed- and Floating-Point Data Types.pdf.pdf | 701.7 KB | ||
| 15. Fixed and floating-point data types.html | 164 B | ||
| 16. Other useful data types.mp4 | 11.8 MB | ||
| 16. Other useful data types.srt | 7.81 KB | ||
| 16.1 Other Useful Data Types.pdf.pdf | 729.04 KB | ||
| 17. Other useful data types.html | 164 B | ||
| 18. Creating a table.mp4 | 10.67 MB | ||
| 18. Creating a table.srt | 6.73 KB | ||
| 18.1 Creating a Table.pdf.pdf | 542.97 KB | ||
| 19. Creating a table - exercise.html | 366 B | ||
| 2. SQL files.html | 1.22 KB | ||
| 2.1 MySQL for Data Analytics and BI - Lecture Code and Tasks Solutions.sql.sql | 60.75 KB | ||
| 2.2 MySQL for Data Analytics and BI - Lecture Code.sql.sql | 42.72 KB | ||
| 2.3 SQL - FAQ.pdf.pdf | 1.16 MB | ||
| 20. Creating a table - solution.html | 657 B | ||
| 21. Using databases and tables.mp4 | 6.52 MB | ||
| 21. Using databases and tables.srt | 3.28 KB | ||
| 21.1 Using Databases and Tables.pdf.pdf | 529.82 KB | ||
| 22. Using databases and tables - exercise.html | 263 B | ||
| 23. Using databases and tables - solution.html | 78 B | ||
| 24. Additional notes on using tables.mp4 | 5.07 MB | ||
| 24. Additional notes on using tables.srt | 2.61 KB | ||
| 24.1 Additional Notes on Using Tables.pdf.pdf | 382.34 KB | ||
| 25. Additional notes on using tables.html | 165 B | ||
| 26. Additional notes on using tables - exercise.html | 275 B | ||
| 3. Creating a Database - Part I - exercise.html | 152 B | ||
| 4. Creating a Database - Part I - solution.html | 122 B | ||
| 5. Creating a Database - Part II.mp4 | 4.87 MB | ||
| 5. Creating a Database - Part II.srt | 3.36 KB | ||
| 6. Creating a Database - Part II - exercise.html | 57 B | ||
| 7. Creating a Database - Part II - solution.html | 34 B | ||
| 8. Introduction to data types.mp4 | 3.1 MB | ||
| 8. Introduction to data types.srt | 2.86 KB | ||
| 8.1 Introduction to Data Types.pdf.pdf | 496.65 KB | ||
| 9. Introduction to data types.html | 164 B | ||
| 6. MySQL constraints | |||
| 1. PRIMARY KEY constraint.mp4 | 11.98 MB | ||
| 1. PRIMARY KEY constraint.srt | 6.78 KB | ||
| 1.1 sales_db.pdf.pdf | 140.67 KB | ||
| 1.2 PRIMARY KEY Constraint.pdf.pdf | 547.08 KB | ||
| 10. UNIQUE Constraint - exercise.html | 1.44 KB | ||
| 11. DEFAULT Constraint.mp4 | 13.12 MB | ||
| 11. DEFAULT Constraint.srt | 6.54 KB | ||
| 11.1 DEFAULT Constraint.pdf.pdf | 514.9 KB | ||
| 12. DEFAULT Constraint - exercise.html | 471 B | ||
| 13. DEFAULT Constraint - solution.html | 488 B | ||
| 14. NOT NULL Constraint - Part I.mp4 | 14.92 MB | ||
| 14. NOT NULL Constraint - Part I.srt | 6.75 KB | ||
| 14.1 NOT NULL Constraint.pdf.pdf | 680.16 KB | ||
| 15. NOT NULL Constraint - Part I - exercise.html | 167 B | ||
| 16. NOT NULL Constraint - Part I - solution.html | 335 B | ||
| 17. NOT NULL Constraint - Part II.mp4 | 3.68 MB | ||
| 17. NOT NULL Constraint - Part II.srt | 2.47 KB | ||
| 2. PRIMARY KEY Constraint.html | 164 B | ||
| 3. PRIMARY KEY constraint - exercise.html | 1.52 KB | ||
| 4. PRIMARY KEY constraint - solution.html | 2.63 KB | ||
| 5. FOREIGN KEY constraint - Part I.mp4 | 11.06 MB | ||
| 5. FOREIGN KEY constraint - Part I.srt | 6.55 KB | ||
| 5.1 FOREIGN KEY Constraint.pdf.pdf | 1.08 MB | ||
| 6. FOREIGN KEY constraint - Part II.mp4 | 14.55 MB | ||
| 6. FOREIGN KEY constraint - Part II.srt | 5.79 KB | ||
| 7. FOREIGN KEY constraint - Part II - exercise.html | 212 B | ||
| 8. FOREIGN KEY constraint - Part II - solution.html | 192 B | ||
| 9. UNIQUE Constraint.mp4 | 11.75 MB | ||
| 9. UNIQUE Constraint.srt | 5.39 KB | ||
| 9.1 UNIQUE Constraint.pdf.pdf | 726.56 KB | ||
| 7. SQL best practices | |||
| 1. Coding techniques and best practices - Part I.mp4 | 11.56 MB | ||
| 1. Coding techniques and best practices - Part I.srt | 6.74 KB | ||
| 1.1 Coding Techniques and Best Practices.pdf.pdf | 1.25 MB | ||
| 1.2 MySQL_Workbench_Shortcuts.pdf.pdf | 515.23 KB | ||
| 2. Coding techniques and best practices – Part I.html | 164 B | ||
| 3. Coding techniques and best practices - Part II.mp4 | 9.27 MB | ||
| 3. Coding techniques and best practices - Part II.srt | 4.82 KB | ||
| 4. Coding techniques and best practices – Part II.html | 164 B | ||
| 8. Loading the 'employees' database | |||
| 1. Loading the 'employees' database.mp4 | 8.15 MB | ||
| 1. Loading the 'employees' database.srt | 6.75 MB | ||
| 2. Loading the 'employees' database.html | 955 B | ||
| 2.1 The 'employees' database.html | 121 B | ||
| 9. SQL SELECT statement | |||
| 1. SELECT - FROM.mp4 | 10.97 MB | ||
| 1. SELECT - FROM.srt | 5.71 KB | ||
| 1.1 SELECT - FROM.pdf.pdf | 571.98 KB | ||
| 1.2 employees_db.pdf.pdf | 178.82 KB | ||
| 10. OR.mp4 | 8.48 MB | ||
| 10. OR.srt | 3.89 KB | ||
| 10.1 OR.pdf.pdf | 351.28 KB | ||
| 11. OR - exercise.html | 85 B | ||
| 12. OR - solution.html | 306 B | ||
| 13. Operator precedence.mp4 | 8.49 MB | ||
| 13. Operator precedence.srt | 4.26 KB | ||
| 13.1 Operator Precedence.pdf.pdf | 420.38 KB | ||
| 14. Operator precedence - exercise.html | 92 B | ||
| 15. Operator precedence - solution.html | 319 B | ||
| 16. IN - NOT IN.mp4 | 8.26 MB | ||
| 16. IN - NOT IN.srt | 3.84 KB | ||
| 17. IN - NOT IN - exercise 1.html | 140 B | ||
| 18. IN - NOT IN - solution 1.html | 296 B | ||
| 19. IN - NOT IN - exercise 2.html | 118 B | ||
| 2. SELECT - FROM - exercise.html | 170 B | ||
| 20. IN - NOT IN - solution 2.html | 299 B | ||
| 21. LIKE - NOT LIKE.mp4 | 9.6 MB | ||
| 21. LIKE - NOT LIKE.srt | 4.39 KB | ||
| 22. LIKE - NOT LIKE - exercise.html | 439 B | ||
| 23. LIKE - NOT LIKE - solution.html | 997 B | ||
| 24. Wildcard characters.mp4 | 3.35 MB | ||
| 24. Wildcard characters.srt | 2.43 KB | ||
| 24.1 Wildcard Characters.pdf.pdf | 406.42 KB | ||
| 25. Wildcard characters - exercise.html | 221 B | ||
| 26. Wildcard characters - solution.html | 583 B | ||
| 27. BETWEEN - AND.mp4 | 5.19 MB | ||
| 27. BETWEEN - AND.srt | 2.38 KB | ||
| 27.1 BETWEEN - AND.pdf.pdf | 655.54 KB | ||
| 28. BETWEEN - AND - exercise.html | 339 B | ||
| 29. BETWEEN - AND- solution.html | 1.32 KB | ||
| 3. SELECT - FROM - solution.html | 411 B | ||
| 30. IS NOT NULL - IS NULL.mp4 | 3.83 MB | ||
| 30. IS NOT NULL - IS NULL.srt | 1.91 KB | ||
| 30.1 IS NOT NULL - IS NULL.pdf.pdf | 357.26 KB | ||
| 31. IS NOT NULL - IS NULL - exercise.html | 85 B | ||
| 32. IS NOT NULL - IS NULL - solution.html | 284 B | ||
| 33. Other comparison operators.mp4 | 11.06 MB | ||
| 33. Other comparison operators.srt | 4.99 KB | ||
| 33.1 Other Comparison Operators.pdf.pdf | 340.07 KB | ||
| 34. Other comparison operators - exercise.html | 273 B | ||
| 35. Other comparison operators - solution.html | 702 B | ||
| 36. SELECT DISTINCT.mp4 | 4.59 MB | ||
| 36. SELECT DISTINCT.srt | 2.59 KB | ||
| 36.1 SELECT DISTINCT.pdf.pdf | 382.83 KB | ||
| 37. SELECT DISTINCT - exercise.html | 350 B | ||
| 38. SELECT DISTINCT - solution.html | 234 B | ||
| 39. Introduction to aggregate functions.mp4 | 12.66 MB | ||
| 39. Introduction to aggregate functions.srt | 6.69 KB | ||
| 39.1 Introduction to Aggregate Functions.pdf.pdf | 737.29 KB | ||
| 4. WHERE.mp4 | 6.04 MB | ||
| 4. WHERE.srt | 2.98 KB | ||
| 4.1 WHERE.pdf.pdf | 413.79 KB | ||
| 40. Introduction to aggregate functions - exercise.html | 264 B | ||
| 41. Introduction to aggregate functions - solution.html | 486 B | ||
| 42. ORDER BY.mp4 | 10.78 MB | ||
| 42. ORDER BY.srt | 4.27 KB | ||
| 43. ORDER BY - exercise.html | 106 B | ||
| 44. ORDER BY - solution.html | 230 B | ||
| 45. GROUP BY.mp4 | 14.83 MB | ||
| 45. GROUP BY.srt | 6.95 KB | ||
| 45.1 GROUP BY.pdf.pdf | 455.07 KB | ||
| 46. Using Aliases (AS).mp4 | 5.26 MB | ||
| 46. Using Aliases (AS).srt | 2.66 KB | ||
| 47. Using Aliases (AS) - exercise.html | 348 B | ||
| 48. Using Aliases (AS) - solution.html | 418 B | ||
| 49. HAVING.mp4 | 8.93 MB | ||
| 49. HAVING.srt | 4.16 KB | ||
| 49.1 HAVING.pdf.pdf | 463.17 KB | ||
| 5. WHERE - exercise.html | 93 B | ||
| 50. HAVING - exercise.html | 987 B | ||
| 51. HAVING - solution.html | 697 B | ||
| 52. WHERE vs HAVING- Part I.mp4 | 9.99 MB | ||
| 52. WHERE vs HAVING- Part I.srt | 4.81 KB | ||
| 52.1 WHERE vs HAVING.pdf.pdf | 767.6 KB | ||
| 53. WHERE vs HAVING- Part II.mp4 | 6.75 MB | ||
| 53. WHERE vs HAVING- Part II.srt | 3.94 KB | ||
| 54. WHERE vs HAVING - Part II - exercise.html | 211 B | ||
| 55. WHERE vs HAVING - Part II - solution.html | 436 B | ||
| 56. LIMIT.mp4 | 12.7 MB | ||
| 56. LIMIT.srt | 5.9 KB | ||
| 56.1 LIMIT.pdf.pdf | 297.28 KB | ||
| 57. LIMIT - exercise.html | 69 B | ||
| 58. LIMIT - solution.html | 214 B | ||
| 6. WHERE - solution.html | 283 B | ||
| 7. AND.mp4 | 4.82 MB | ||
| 7. AND.srt | 2.52 KB | ||
| 7.1 AND.pdf.pdf | 489.72 KB | ||
| 8. AND - exercise.html | 82 B | ||
| 9. AND - solution.html | 385 B | ||
| [CourseClub.Me].url | 48 B | ||
| [DesireCourse.Net].url | 51 B | ||
| [FreeCourseWorld.Com].url | 54 B | ||
| ▲ 554 total files | |||
SQL - MySQL for Data Analytics and Business Intelligence
SQL that will get you hired – SQL for Business Analysis, Marketing, and Data Management
For More Courses Visit: https://desirecourse.net
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 274.1 MB | freecoursewb | 1 week | 17 | 1 | |
|
Udemy - Data Analytics for Beginners - Excel, SQL, and AI Dashboards Posted by
freecoursewb in Other
|
2.1 GB | freecoursewb | 4 weeks | 0 | 0 |
|
Udemy - Databricks Spark Streaming, Delta Lake and SQL, AI Analytics Posted by
freecoursewb in Other
|
3.3 GB | freecoursewb | 4 weeks | 1 | 5 |
| 2.5 GB | freecoursewb | 4 weeks | 26 | 4 | |
| 1.6 GB | freecoursewb | 1 month | 9 | 8 |
All Comments