SQL - MySQL for Data Analytics and Business Intelligence

Creation Time	May 14, 2024, 3:33 p.m.
Last Access Time	Oct. 20, 2024, 9:09 p.m.
File Size	2.4 GB
Keywords	and Business for Intelligence SQL - Analytics MySQL Data
Total Requests	13
Total Files	554
Magnet Link	Please wait ...
	Download (Magnet Link) Play (Watch Online)

SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/3. Databases vs spreadsheets.mp4 170.0 MB
SQL - MySQL for Data Analytics and Business Intelligence/20. Combining SQL and Tableau - Introduction/1. The Advantages of Software Integration.mp4 92.4 MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/23. CROSS JOIN.mp4 90.0 MB
SQL - MySQL for Data Analytics and Business Intelligence/4. Installing MySQL and getting acquainted with the interface/1. Installing MySQL.mp4 89.8 MB
SQL - MySQL for Data Analytics and Business Intelligence/20. Combining SQL and Tableau - Introduction/2. Why Combining SQL and Tableau is useful.mp4 85.4 MB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/17. The CASE Statement.mp4 59.4 MB
SQL - MySQL for Data Analytics and Business Intelligence/25. Combining SQL and Tableau - Task 5/1. Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau.mp4 56.0 MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/32. Tips and tricks for joins.mp4 50.9 MB
SQL - MySQL for Data Analytics and Business Intelligence/22. Combining SQL and Tableau - Task 2/5. Chart 2 Visualizing and Analyzing the Solution in Tableau.mp4 48.9 MB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/16. User-defined functions in MySQL.mp4 48.8 MB
SQL - MySQL for Data Analytics and Business Intelligence/4. Installing MySQL and getting acquainted with the interface/7. New Authentication Plugin - Creating a New User.mp4 47.7 MB
SQL - MySQL for Data Analytics and Business Intelligence/21. Combining SQL and Tableau - Task 1/8. Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II.mp4 45.1 MB
SQL - MySQL for Data Analytics and Business Intelligence/21. Combining SQL and Tableau - Task 1/4. Task 1 SQL Solution.mp4 43.2 MB
SQL - MySQL for Data Analytics and Business Intelligence/21. Combining SQL and Tableau - Task 1/7. Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I.mp4 40.5 MB
SQL - MySQL for Data Analytics and Business Intelligence/23. Combining SQL and Tableau - Task 3/5. Chart 3 Visualizing and Analyzing the Solution in Tableau.mp4 40.3 MB
SQL - MySQL for Data Analytics and Business Intelligence/22. Combining SQL and Tableau - Task 2/3. Task 2 SQL Solution.mp4 39.3 MB
SQL - MySQL for Data Analytics and Business Intelligence/21. Combining SQL and Tableau - Task 1/1. Task 1.mp4 33.5 MB
SQL - MySQL for Data Analytics and Business Intelligence/23. Combining SQL and Tableau - Task 3/3. Task 3 SQL Solution.mp4 33.1 MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/15. RIGHT JOIN.mp4 32.1 MB
SQL - MySQL for Data Analytics and Business Intelligence/21. Combining SQL and Tableau - Task 1/6. Transferring a Dataset from SQL to Tableau.mp4 31.4 MB
SQL - MySQL for Data Analytics and Business Intelligence/24. Combining SQL and Tableau - Task 4/3. Task 4 Solution in SQL.mp4 30.3 MB
SQL - MySQL for Data Analytics and Business Intelligence/22. Combining SQL and Tableau - Task 2/1. Task 2.mp4 28.9 MB
SQL - MySQL for Data Analytics and Business Intelligence/20. Combining SQL and Tableau - Introduction/4. Loading the 'employees_mod' Database.mp4 28.5 MB
SQL - MySQL for Data Analytics and Business Intelligence/20. Combining SQL and Tableau - Introduction/3. Installing Tableau Public.mp4 27.4 MB
SQL - MySQL for Data Analytics and Business Intelligence/1. Introduction to databases, SQL, and MySQL/1. What does the course cover.mp4 24.2 MB
SQL - MySQL for Data Analytics and Business Intelligence/24. Combining SQL and Tableau - Task 4/1. Task 4.mp4 23.6 MB
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/1. Relational database essentials.mp4 23.0 MB
SQL - MySQL for Data Analytics and Business Intelligence/24. Combining SQL and Tableau - Task 4/5. Chart 4 Visualizing and Analyzing the Solution in Tableau.mp4 22.3 MB
SQL - MySQL for Data Analytics and Business Intelligence/16. SQL Self Join/1. Self Join.mp4 20.8 MB
SQL - MySQL for Data Analytics and Business Intelligence/15. SQL Subqueries/7. SQL Subqueries nested in SELECT and FROM.mp4 19.9 MB
SQL - MySQL for Data Analytics and Business Intelligence/1. Introduction to databases, SQL, and MySQL/6. Introduction to databases.mp4 19.6 MB
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/5. Database terminology.mp4 19.0 MB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/12. MySQL Indexes.mp4 18.2 MB
SQL - MySQL for Data Analytics and Business Intelligence/17. SQL Views/1. Views.mp4 17.5 MB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/9. Stored procedures with an input parameter.mp4 17.1 MB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/13. Variables.mp4 16.0 MB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/17. IFNULL() and COALESCE().mp4 15.8 MB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/14. NOT NULL Constraint - Part I.mp4 14.9 MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/45. GROUP BY.mp4 14.8 MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/12. LEFT JOIN - Part II.mp4 14.8 MB
SQL - MySQL for Data Analytics and Business Intelligence/1. Introduction to databases, SQL, and MySQL/2. Why SQL.mp4 14.7 MB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/6. FOREIGN KEY constraint - Part II.mp4 14.5 MB
SQL - MySQL for Data Analytics and Business Intelligence/10. SQL INSERT statement/1. The INSERT statement - Part I.mp4 14.4 MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/11. LEFT JOIN - Part I.mp4 14.0 MB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/11. DEFAULT Constraint.mp4 13.1 MB
SQL - MySQL for Data Analytics and Business Intelligence/23. Combining SQL and Tableau - Task 3/1. Task 3.mp4 13.1 MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/10. Duplicate Records.mp4 12.7 MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/56. LIMIT.mp4 12.7 MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/39. Introduction to aggregate functions.mp4 12.7 MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/5. INNER JOIN - Part I.mp4 12.4 MB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/1. PRIMARY KEY constraint.mp4 12.0 MB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/3. Session Variables.mp4 12.0 MB
SQL - MySQL for Data Analytics and Business Intelligence/4. Installing MySQL and getting acquainted with the interface/8. Introduction to the MySQL interface.mp4 11.9 MB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/16. Other useful data types.mp4 11.8 MB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/14. Fixed and floating-point data types.mp4 11.8 MB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/9. UNIQUE Constraint.mp4 11.8 MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/6. INNER JOIN - Part II.mp4 11.6 MB
SQL - MySQL for Data Analytics and Business Intelligence/7. SQL best practices/1. Coding techniques and best practices - Part I.mp4 11.6 MB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/1. Types of MySQL Variables - Local Variables.mp4 11.6 MB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/5. Stored procedures - Example - Part II.mp4 11.2 MB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/5. FOREIGN KEY constraint - Part I.mp4 11.1 MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/33. Other comparison operators.mp4 11.1 MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/1. SELECT - FROM.mp4 11.0 MB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/7. User-Defined vs System Variables.mp4 11.0 MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/29. JOIN more than two tables in SQL.mp4 11.0 MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/9. A Note on Using Joins.mp4 10.8 MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/42. ORDER BY.mp4 10.8 MB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/18. Creating a table.mp4 10.7 MB
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/7. Relational schemas - Primary key.mp4 10.4 MB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/1. Creating a Database - Part I.mp4 10.4 MB
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/9. Relational schemas - Foreign key.mp4 10.4 MB
SQL - MySQL for Data Analytics and Business Intelligence/12. SQL DELETE Statement/1. The DELETE Statement - Part I.mp4 10.3 MB
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/1. SQL as a declarative language.mp4 10.1 MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/52. WHERE vs HAVING- Part I.mp4 10.0 MB
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/7. Data manipulation language (DML).mp4 10.0 MB
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/13. Relationships.mp4 9.7 MB
SQL - MySQL for Data Analytics and Business Intelligence/10. SQL INSERT statement/7. Inserting data INTO a new table.mp4 9.6 MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/21. LIKE - NOT LIKE.mp4 9.6 MB
SQL - MySQL for Data Analytics and Business Intelligence/7. SQL best practices/3. Coding techniques and best practices - Part II.mp4 9.3 MB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/1. COUNT().mp4 9.2 MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/16. The new and the old join syntax.mp4 9.2 MB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/10. String data types.mp4 9.1 MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/49. HAVING.mp4 8.9 MB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/12. Integers.mp4 8.8 MB
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/3. Data definition language (DDL).mp4 8.7 MB
SQL - MySQL for Data Analytics and Business Intelligence/15. SQL Subqueries/4. SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE.mp4 8.6 MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/35. UNION vs UNION ALL.mp4 8.5 MB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/10. Stored procedures with an output parameter.mp4 8.5 MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/13. Operator precedence.mp4 8.5 MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/10. OR.mp4 8.5 MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/16. IN - NOT IN.mp4 8.3 MB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/20. Stored routines - conclusion.mp4 8.2 MB
SQL - MySQL for Data Analytics and Business Intelligence/8. Loading the 'employees' database/1. Loading the 'employees' database.mp4 8.1 MB
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/9. Data control language (DCL).mp4 8.1 MB
SQL - MySQL for Data Analytics and Business Intelligence/11. SQL UPDATE Statement/2. The UPDATE Statement - Part I.mp4 7.9 MB
SQL - MySQL for Data Analytics and Business Intelligence/11. SQL UPDATE Statement/1. TCL's COMMIT and ROLLBACK.mp4 7.8 MB
SQL - MySQL for Data Analytics and Business Intelligence/12. SQL DELETE Statement/5. DROP vs TRUNCATE vs DELETE.mp4 7.5 MB
SQL - MySQL for Data Analytics and Business Intelligence/11. SQL UPDATE Statement/4. The UPDATE Statement - Part II.mp4 7.4 MB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/4. Stored procedures - Example - Part I.mp4 7.2 MB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/1. Introduction to stored routines.mp4 7.2 MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/1. Introduction to JOINs.mp4 7.2 MB
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/11. Transaction control language (TCL).mp4 6.9 MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/53. WHERE vs HAVING- Part II.mp4 6.7 MB
SQL - MySQL for Data Analytics and Business Intelligence/15. SQL Subqueries/1. SQL Subqueries with IN nested inside WHERE.mp4 6.7 MB
SQL - MySQL for Data Analytics and Business Intelligence/10. SQL INSERT statement/2. The INSERT statement - Part II.mp4 6.7 MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/19. JOIN and WHERE Used Together.mp4 6.5 MB
SQL - MySQL for Data Analytics and Business Intelligence/1. Introduction to databases, SQL, and MySQL/4. Why MySQL.mp4 6.5 MB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/21. Using databases and tables.mp4 6.5 MB
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/11. Relational schemas - Unique key and null values.mp4 6.3 MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/28. Using Aggregate Functions with Joins.mp4 6.2 MB
SQL - MySQL for Data Analytics and Business Intelligence/4. Installing MySQL and getting acquainted with the interface/5. Setting up a connection.mp4 6.2 MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/4. WHERE.mp4 6.0 MB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/3. The MySQL syntax for stored procedures.mp4 6.0 MB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/8. Another way to create a procedure.mp4 5.4 MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/46. Using Aliases (AS).mp4 5.3 MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/27. BETWEEN - AND.mp4 5.2 MB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/24. Additional notes on using tables.mp4 5.1 MB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/5. Global Variables.mp4 5.0 MB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/5. Creating a Database - Part II.mp4 4.9 MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/7. AND.mp4 4.8 MB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/13. ROUND().mp4 4.7 MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/36. SELECT DISTINCT.mp4 4.6 MB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/10. AVG().mp4 4.2 MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/30. IS NOT NULL - IS NULL.mp4 3.8 MB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/18. Another Example of Using COALESCE().mp4 3.7 MB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/17. NOT NULL Constraint - Part II.mp4 3.7 MB
SQL - MySQL for Data Analytics and Business Intelligence/12. SQL DELETE Statement/2. The DELETE Statement - Part II.mp4 3.7 MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/24. Wildcard characters.mp4 3.4 MB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/4. SUM().mp4 3.2 MB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/8. Introduction to data types.mp4 3.1 MB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/7. MIN() and MAX().mp4 3.0 MB
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/5. SQL keywords.mp4 2.5 MB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/3.1 Session Variables.pdf 1.8 MB
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/13.1 Relationships.pdf 1.4 MB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/12.1 MySQL Indexes.pdf 1.3 MB
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/3.1 DDL.pdf 1.3 MB
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/7.1 Relational Schemas - Primary Key.pdf 1.3 MB
SQL - MySQL for Data Analytics and Business Intelligence/7. SQL best practices/1.2 Coding Techniques and Best Practices.pdf 1.2 MB
SQL - MySQL for Data Analytics and Business Intelligence/1. Introduction to databases, SQL, and MySQL/2.1 SQL - FAQ.pdf 1.2 MB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/2.3 SQL - FAQ.pdf 1.2 MB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/5.1 FOREIGN KEY Constraint.pdf 1.1 MB
SQL - MySQL for Data Analytics and Business Intelligence/15. SQL Subqueries/1.1 Subqueries IN WHERE.pdf 1.1 MB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/1.1 COUNT().pdf 1.1 MB
SQL - MySQL for Data Analytics and Business Intelligence/12. SQL DELETE Statement/5.1 DROP vs TRUNCATE vs DELETE.pdf 1.0 MB
SQL - MySQL for Data Analytics and Business Intelligence/17. SQL Views/1.1 SQL Views.pdf 1.0 MB
SQL - MySQL for Data Analytics and Business Intelligence/15. SQL Subqueries/4.1 Subqueries EXISTS WHERE.pdf 1.0 MB
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/11.1 TCL.pdf 965.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/9.1 Relational Schemas - Foreign Key.pdf 960.4 KB
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/7.1 DML.pdf 913.2 KB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/3.1 The MySQL Syntax for Stored Procedures.pdf 911.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/1.1 Types of MySQL Variables - Local Variables.pdf 866.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/15.1 RIGHT JOIN.pdf 856.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/35.1 UNION vs UNION ALL.pdf 823.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/1.1 Creating a Database - Part I.pdf 793.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/5.1 INNER JOIN.pdf 778.5 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/1.1 Introduction to Joins.pdf 775.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/11.1 Relational Schemas - Unique Key and Null Values.pdf 773.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/52.1 WHERE vs HAVING.pdf 767.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/11.1 LEFT JOIN.pdf 739.0 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/39.1 Introduction to Aggregate Functions.pdf 737.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/1.1 Introduction to Stored Routines.pdf 729.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/16.1 Other Useful Data Types.pdf 729.0 KB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/9.1 UNIQUE Constraint.pdf 726.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/16.1 The New and the Old Join Syntax.pdf 718.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/13.1 Variables.pdf 718.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/17.1 IFNULL() and COALESCE().pdf 715.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/20.1 Stored Routines - Conclusion.pdf 713.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/16. SQL Self Join/1.1 SQL Self Join.pdf 703.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/14.1 Fixed- and Floating-Point Data Types.pdf 701.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/7.1 User-Defined vs System Variables.pdf 699.4 KB
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/9.1 DCL.pdf 682.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/14.1 NOT NULL Constraint.pdf 680.2 KB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/5.1 Global Variables.pdf 676.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/12.1 Integers.pdf 656.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/27.1 BETWEEN - AND.pdf 655.5 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/29.1 JOIN More Than Two Tables in SQL.pdf 624.2 KB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/16.1 COALESCE() - Preamble.pdf 581.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/11. SQL UPDATE Statement/1.1 TCL's COMMIT and ROLLBACK.pdf 580.2 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/1.1 SELECT - FROM.pdf 572.0 KB
SQL - MySQL for Data Analytics and Business Intelligence/26. Practice SQL – 10 Final Query Questions/1.2 10-Practice-SQL-Final-Query-Questions.pdf 557.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/4. Installing MySQL and getting acquainted with the interface/4.1 The Client-Server Model.pdf 556.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/9.1 Stored Procedures with an Input Parameter.pdf 547.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/1.1 PRIMARY KEY Constraint.pdf 547.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/18.1 Creating a Table.pdf 543.0 KB
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/5.1 SQL Keywords.pdf 533.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/21.1 Using Databases and Tables.pdf 529.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/7. SQL best practices/1.1 MySQL_Workbench_Shortcuts.pdf 515.2 KB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/11.1 DEFAULT Constraint.pdf 514.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/16.1 User-Defined Functions in MySQL.pdf 512.0 KB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/8.1 Introduction to Data Types.pdf 496.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/4.1 SUM().pdf 494.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/7.1 AND.pdf 489.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/32.1 Tips and Tricks for Joins.pdf 479.2 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/49.1 HAVING.pdf 463.2 KB
SQL - MySQL for Data Analytics and Business Intelligence/11. SQL UPDATE Statement/2.1 The UPDATE Statement.pdf 455.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/45.1 GROUP BY.pdf 455.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/10.1 String Data Types.pdf 443.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/10.1 AVG().pdf 442.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/10.1 Stored Procedures with an Output Parameter.pdf 429.4 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/13.1 Operator Precedence.pdf 420.4 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/4.1 WHERE.pdf 413.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/24.1 Wildcard Characters.pdf 406.4 KB
SQL - MySQL for Data Analytics and Business Intelligence/15. SQL Subqueries/7.1 Subqueries SELECT FROM.pdf 403.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/19.1 JOIN and WHERE Used Together.pdf 398.0 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/36.1 SELECT DISTINCT.pdf 382.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/24.1 Additional Notes on Using Tables.pdf 382.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/10. SQL INSERT statement/1.1 The INSERT Statement.pdf 371.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/12. SQL DELETE Statement/1.1 The DELETE Statement.pdf 360.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/30.1 IS NOT NULL - IS NULL.pdf 357.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/10.1 OR.pdf 351.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/33.1 Other Comparison Operators.pdf 340.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/10.1 Duplicate Records.pdf 337.0 KB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/13.1 ROUND().pdf 334.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/23.1 CROSS JOIN.pdf 313.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/10. SQL INSERT statement/7.1 Inserting Data INTO a New Table.pdf 312.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/17.1 The CASE Statement.pdf 302.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/56.1 LIMIT.pdf 297.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/7.1 MIN() and MAX().pdf 284.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/1.2 employees_db.pdf 178.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/1.2 sales_db.pdf 140.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/20. Combining SQL and Tableau - Introduction/4.1 employees_mod_db.pdf 129.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/20. Combining SQL and Tableau - Introduction/5.2 employees_mod_db.pdf 129.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/2.2 MySQL for Data Analytics and BI - Lecture Code and Tasks Solutions.sql 60.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/2.1 MySQL for Data Analytics and BI - Lecture Code.sql 42.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/4. Installing MySQL and getting acquainted with the interface/1. Installing MySQL.srt 12.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/3. Databases vs spreadsheets.srt 11.5 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/23. CROSS JOIN.srt 9.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/9.1 MySQL Triggers.sql 9.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/16. SQL Self Join/1. Self Join.srt 8.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/15. SQL Subqueries/7. SQL Subqueries nested in SELECT and FROM.srt 8.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/12. MySQL Indexes.srt 8.2 KB
SQL - MySQL for Data Analytics and Business Intelligence/17. SQL Views/1. Views.srt 8.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/16. Other useful data types.srt 7.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/9. Stored procedures with an input parameter.srt 7.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/13. Variables.srt 7.5 KB
SQL - MySQL for Data Analytics and Business Intelligence/21. Combining SQL and Tableau - Task 1/7. Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I.srt 7.5 KB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/17. IFNULL() and COALESCE().srt 7.4 KB
SQL - MySQL for Data Analytics and Business Intelligence/22. Combining SQL and Tableau - Task 2/5. Chart 2 Visualizing and Analyzing the Solution in Tableau.srt 7.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/16. User-defined functions in MySQL.srt 7.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/14. Fixed and floating-point data types.srt 7.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/1. Creating a Database - Part I.srt 7.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/21. Combining SQL and Tableau - Task 1/1. Task 1.srt 7.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/20. Combining SQL and Tableau - Introduction/1. The Advantages of Software Integration.srt 7.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/1. Introduction to databases, SQL, and MySQL/6. Introduction to databases.srt 7.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/12. LEFT JOIN - Part II.srt 7.0 KB
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/7. Relational schemas - Primary key.srt 7.0 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/45. GROUP BY.srt 7.0 KB
SQL - MySQL for Data Analytics and Business Intelligence/10. SQL INSERT statement/1. The INSERT statement - Part I.srt 6.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/26. Practice SQL – 10 Final Query Questions/1.1 10-Practice-Final-Query-Questions - SOLUTIONS.sql 6.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/9. Data control language (DCL).srt 6.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/9. Relational schemas - Foreign key.srt 6.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/17. The CASE Statement.srt 6.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/32. Tips and tricks for joins.srt 6.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/21. Combining SQL and Tableau - Task 1/8. Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II.srt 6.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/5. INNER JOIN - Part I.srt 6.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/1. PRIMARY KEY constraint.srt 6.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/14. NOT NULL Constraint - Part I.srt 6.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/7. SQL best practices/1. Coding techniques and best practices - Part I.srt 6.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/18. Creating a table.srt 6.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/4. Installing MySQL and getting acquainted with the interface/7. New Authentication Plugin - Creating a New User.srt 6.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/25. Combining SQL and Tableau - Task 5/1. Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau.srt 6.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/39. Introduction to aggregate functions.srt 6.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/1. Relational database essentials.srt 6.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/6. INNER JOIN - Part II.srt 6.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/1. Introduction to databases, SQL, and MySQL/1. What does the course cover.srt 6.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/3. Session Variables.srt 6.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/5. FOREIGN KEY constraint - Part I.srt 6.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/11. DEFAULT Constraint.srt 6.5 KB
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/7. Data manipulation language (DML).srt 6.4 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/35. UNION vs UNION ALL.srt 6.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/10. String data types.srt 6.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/20. Combining SQL and Tableau - Introduction/2. Why Combining SQL and Tableau is useful.srt 6.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/4. Installing MySQL and getting acquainted with the interface/8. Introduction to the MySQL interface.srt 6.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/13. Relationships.srt 6.2 KB
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/3. Data definition language (DDL).srt 6.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/5. Stored procedures - Example - Part II.srt 6.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/5. Database terminology.srt 6.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/56. LIMIT.srt 5.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/23. Combining SQL and Tableau - Task 3/5. Chart 3 Visualizing and Analyzing the Solution in Tableau.srt 5.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/11. LEFT JOIN - Part I.srt 5.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/6. FOREIGN KEY constraint - Part II.srt 5.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/1. Types of MySQL Variables - Local Variables.srt 5.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/1. SELECT - FROM.srt 5.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/3. The MySQL syntax for stored procedures.srt 5.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/21. Combining SQL and Tableau - Task 1/4. Task 1 SQL Solution.srt 5.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/9. UNIQUE Constraint.srt 5.4 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/16. The new and the old join syntax.srt 5.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/10. Duplicate Records.srt 5.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/1. COUNT().srt 5.2 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/15. RIGHT JOIN.srt 5.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/12. Integers.srt 5.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/1. Introduction to JOINs.srt 5.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/7. User-Defined vs System Variables.srt 5.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/21. Combining SQL and Tableau - Task 1/6. Transferring a Dataset from SQL to Tableau.srt 5.0 KB
SQL - MySQL for Data Analytics and Business Intelligence/15. SQL Subqueries/1. SQL Subqueries with IN nested inside WHERE.srt 5.0 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/9. A Note on Using Joins.srt 5.0 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/33. Other comparison operators.srt 5.0 KB
SQL - MySQL for Data Analytics and Business Intelligence/12. SQL DELETE Statement/1. The DELETE Statement - Part I.srt 4.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/29. JOIN more than two tables in SQL.srt 4.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/7. SQL best practices/3. Coding techniques and best practices - Part II.srt 4.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/52. WHERE vs HAVING- Part I.srt 4.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/1. Introduction to databases, SQL, and MySQL/2. Why SQL.srt 4.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/20. Stored routines - conclusion.srt 4.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/22. Combining SQL and Tableau - Task 2/1. Task 2.srt 4.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/1. Introduction to stored routines.srt 4.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/10. SQL INSERT statement/7. Inserting data INTO a new table.srt 4.5 KB
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/11. Relational schemas - Unique key and null values.srt 4.4 KB
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/11. Transaction control language (TCL).srt 4.4 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/21. LIKE - NOT LIKE.srt 4.4 KB
SQL - MySQL for Data Analytics and Business Intelligence/22. Combining SQL and Tableau - Task 2/3. Task 2 SQL Solution.srt 4.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/42. ORDER BY.srt 4.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/13. Operator precedence.srt 4.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/15. SQL Subqueries/4. SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE.srt 4.2 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/49. HAVING.srt 4.2 KB
SQL - MySQL for Data Analytics and Business Intelligence/20. Combining SQL and Tableau - Introduction/4. Loading the 'employees_mod' Database.srt 4.0 KB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/10. Stored procedures with an output parameter.srt 4.0 KB
SQL - MySQL for Data Analytics and Business Intelligence/12. SQL DELETE Statement/5. DROP vs TRUNCATE vs DELETE.srt 4.0 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/53. WHERE vs HAVING- Part II.srt 3.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/10. OR.srt 3.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/23. Combining SQL and Tableau - Task 3/3. Task 3 SQL Solution.srt 3.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/16. IN - NOT IN.srt 3.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/24. Combining SQL and Tableau - Task 4/5. Chart 4 Visualizing and Analyzing the Solution in Tableau.srt 3.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/11. SQL UPDATE Statement/2. The UPDATE Statement - Part I.srt 3.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/8. Another way to create a procedure.srt 3.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/24. Combining SQL and Tableau - Task 4/1. Task 4.srt 3.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/11. SQL UPDATE Statement/1. TCL's COMMIT and ROLLBACK.srt 3.5 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/19. JOIN and WHERE Used Together.srt 3.5 KB
SQL - MySQL for Data Analytics and Business Intelligence/11. SQL UPDATE Statement/4. The UPDATE Statement - Part II.srt 3.4 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/20. Important – Prevent Error Code 1055!.html 3.4 KB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/5. Creating a Database - Part II.srt 3.4 KB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/4. Stored procedures - Example - Part I.srt 3.4 KB
SQL - MySQL for Data Analytics and Business Intelligence/4. Installing MySQL and getting acquainted with the interface/5. Setting up a connection.srt 3.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/21. Using databases and tables.srt 3.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/24. Combining SQL and Tableau - Task 4/3. Task 4 Solution in SQL.srt 3.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/1. SQL as a declarative language.srt 3.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/4. WHERE.srt 3.0 KB
SQL - MySQL for Data Analytics and Business Intelligence/1. Introduction to databases, SQL, and MySQL/4. Why MySQL.srt 2.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/8. Introduction to data types.srt 2.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/23. Combining SQL and Tableau - Task 3/1. Task 3.srt 2.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/17. Error Code 1418..html 2.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/28. Using Aggregate Functions with Joins.srt 2.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/8. Loading the 'employees' database/1. Loading the 'employees' database.srt 2.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/5. Global Variables.srt 2.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/46. Using Aliases (AS).srt 2.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/4. Installing MySQL and getting acquainted with the interface/3. Installing MySQL on macOS and Unix systems.html 2.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/4. PRIMARY KEY constraint - solution.html 2.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/24. Additional notes on using tables.srt 2.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/36. SELECT DISTINCT.srt 2.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/13. ROUND().srt 2.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/10. SQL INSERT statement/2. The INSERT statement - Part II.srt 2.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/10. AVG().srt 2.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/7. AND.srt 2.5 KB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/17. NOT NULL Constraint - Part II.srt 2.5 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/24. Wildcard characters.srt 2.4 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/31. Join more than two tables in SQL - solution.html 2.4 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/27. BETWEEN - AND.srt 2.4 KB
SQL - MySQL for Data Analytics and Business Intelligence/20. Combining SQL and Tableau - Introduction/3. Installing Tableau Public.srt 2.2 KB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/18. Another Example of Using COALESCE().srt 2.0 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/30. IS NOT NULL - IS NULL.srt 1.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/27. BONUS LECTURE/1. Bonus Lecture Next Steps.html 1.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/4. SUM().srt 1.9 KB
SQL - MySQL for Data Analytics and Business Intelligence/15. SQL Subqueries/11.1 Subqueries SELECT FROM Solution.sql 1.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/5. SQL keywords.srt 1.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/12. SQL DELETE Statement/2. The DELETE Statement - Part II.srt 1.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/19. User-defined functions in MySQL - solution.html 1.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/21. The CASE Statement - solution 2.html 1.8 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/37. UNION vs UNION ALL - solution.html 1.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/12. Stored procedures with an output parameter - solution.html 1.7 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/4. Intro to JOINs - exercise 2.html 1.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/3. Intro to JOINs - solution 1.html 1.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/7. MIN() and MAX().srt 1.6 KB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/3. PRIMARY KEY constraint - exercise.html 1.5 KB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/10. UNIQUE Constraint - exercise.html 1.4 KB
SQL - MySQL for Data Analytics and Business Intelligence/10. SQL INSERT statement/3. The INSERT statement - exercise 1.html 1.4 KB
SQL - MySQL for Data Analytics and Business Intelligence/21. Combining SQL and Tableau - Task 1/3. Important clarification!.html 1.4 KB
SQL - MySQL for Data Analytics and Business Intelligence/11. SQL UPDATE Statement/3. ROLLBACK; ARTICLE.html 1.4 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/29. BETWEEN - AND- solution.html 1.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/11. MySQL Triggers - solution.html 1.3 KB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/18. The new and the old join syntax - solution.html 1.2 KB
SQL - MySQL for Data Analytics and Business Intelligence/10. SQL INSERT statement/4. The INSERT statement - solution 1.html 1.2 KB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/2. SQL files.html 1.2 KB
SQL - MySQL for Data Analytics and Business Intelligence/10. SQL INSERT statement/6. The INSERT statement - solution 2.html 1.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/15. SQL Subqueries/10. SQL Subqueries nested in SELECT and FROM - exercise 2.html 1.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/7. Stored procedures - Example - Part II - solution.html 1.1 KB
SQL - MySQL for Data Analytics and Business Intelligence/26. Practice SQL – 10 Final Query Questions/1. Practice SQL – 10 Final Query Questions.html 1.0 KB
SQL - MySQL for Data Analytics and Business Intelligence/4. Installing MySQL and getting acquainted with the interface/6. Read me!!!.html 1.0 KB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/23. LIKE - NOT LIKE - solution.html 997 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/50. HAVING - exercise.html 987 bytes
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/2. Intro to JOINs - exercise 1.html 974 bytes
SQL - MySQL for Data Analytics and Business Intelligence/8. Loading the 'employees' database/2. Loading the 'employees' database.html 955 bytes
SQL - MySQL for Data Analytics and Business Intelligence/15. SQL Subqueries/6. SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - solution.html 900 bytes
SQL - MySQL for Data Analytics and Business Intelligence/4. Installing MySQL and getting acquainted with the interface/2. Additional note – Installing – Visual C.html 835 bytes
SQL - MySQL for Data Analytics and Business Intelligence/22. Combining SQL and Tableau - Task 2/4. Task 2 SQL Solution - Code.html 787 bytes
SQL - MySQL for Data Analytics and Business Intelligence/15. SQL Subqueries/3. SQL Subqueries with IN nested inside WHERE - solution.html 785 bytes
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/23. The CASE Statement - solution 3.html 744 bytes
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/19. The CASE Statement - solution 1.html 737 bytes
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/22. JOIN and WHERE Used Together - solution.html 722 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/35. Other comparison operators - solution.html 702 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/51. HAVING - solution.html 697 bytes
SQL - MySQL for Data Analytics and Business Intelligence/24. Combining SQL and Tableau - Task 4/4. Task 4 Solution in SQL - Code.html 697 bytes
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/16. MySQL Indexes - solution 2.html 683 bytes
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/20. Creating a table - solution.html 657 bytes
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/14. LEFT JOIN - Part II - solution.html 657 bytes
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/8. INNER JOIN - Part II - solution.html 621 bytes
SQL - MySQL for Data Analytics and Business Intelligence/20. Combining SQL and Tableau - Introduction/5. Loading the 'employees_mod' Database.html 613 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/26. Wildcard characters - solution.html 583 bytes
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/22. Another example of using COALESCE() - solution 2.html 570 bytes
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/27. CROSS JOIN - solution 2.html 566 bytes
SQL - MySQL for Data Analytics and Business Intelligence/17. SQL Views/3. Views - solution.html 566 bytes
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/9. MySQL Triggers.html 537 bytes
SQL - MySQL for Data Analytics and Business Intelligence/21. Combining SQL and Tableau - Task 1/5. Task 1 SQL Solution - Code.html 537 bytes
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/25. CROSS JOIN - solution 1.html 504 bytes
SQL - MySQL for Data Analytics and Business Intelligence/23. Combining SQL and Tableau - Task 3/4. Task 3 SQL Solution - Code.html 502 bytes
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/13. DEFAULT Constraint - solution.html 488 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/41. Introduction to aggregate functions - solution.html 486 bytes
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/12. DEFAULT Constraint - exercise.html 471 bytes
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/9. MIN() and MAX() - solution.html 471 bytes
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/13. LEFT JOIN - Part II - exercise.html 455 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/22. LIKE - NOT LIKE - exercise.html 439 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/55. WHERE vs HAVING - Part II - solution.html 436 bytes
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/18. User-defined functions in MySQL - exercise.html 434 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/48. Using Aliases (AS) - solution.html 418 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/3. SELECT - FROM - solution.html 411 bytes
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/22. The CASE Statement - exercise 3.html 411 bytes
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/34. Tips and tricks for joins - solution.html 408 bytes
SQL - MySQL for Data Analytics and Business Intelligence/READ_ME.txt 407 bytes
SQL - MySQL for Data Analytics and Business Intelligence/1. Introduction to databases, SQL, and MySQL/READ_ME.txt 407 bytes
READ_ME.txt 407 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/9. AND - solution.html 385 bytes
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/20. Another example of using COALESCE() - solution 1.html 383 bytes
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/20. The CASE Statement - exercise 2.html 376 bytes
SQL - MySQL for Data Analytics and Business Intelligence/10. SQL INSERT statement/5. The INSERT statement - exercise 2.html 372 bytes
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/19. Creating a table - exercise.html 366 bytes
SQL - MySQL for Data Analytics and Business Intelligence/15. SQL Subqueries/9. SQL Subqueries nested in SELECT and FROM - solution 1.html 366 bytes
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/18. The CASE Statement - exercise 1.html 362 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/37. SELECT DISTINCT - exercise.html 350 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/47. Using Aliases (AS) - exercise.html 348 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/28. BETWEEN - AND - exercise.html 339 bytes
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/16. NOT NULL Constraint - Part I - solution.html 335 bytes
SQL - MySQL for Data Analytics and Business Intelligence/24. Combining SQL and Tableau - Task 4/2. Task 4 - Text.html 325 bytes
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/21. Another example of using COALESCE() - exercise 2.html 320 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/15. Operator precedence - solution.html 319 bytes
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/12. AVG() - solution.html 307 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/12. OR - solution.html 306 bytes
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/14. Variables - exercise.html 305 bytes
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/15. ROUND() - solution.html 301 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/20. IN - NOT IN - solution 2.html 299 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/18. IN - NOT IN - solution 1.html 296 bytes
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/6. SUM() - solution.html 291 bytes
SQL - MySQL for Data Analytics and Business Intelligence/17. SQL Views/2. Views - exercise.html 288 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/32. IS NOT NULL - IS NULL - solution.html 284 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/6. WHERE - solution.html 283 bytes
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/26. Additional notes on using tables - exercise.html 275 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/34. Other comparison operators - exercise.html 273 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/40. Introduction to aggregate functions - exercise.html 264 bytes
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/22. Using databases and tables - exercise.html 263 bytes
SQL - MySQL for Data Analytics and Business Intelligence/11. SQL UPDATE Statement/6. The UPDATE Statement – Part II - solution.html 257 bytes
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/15. MySQL Indexes - exercise 2.html 255 bytes
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/19. Another example of using COALESCE() - exercise 1.html 238 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/38. SELECT DISTINCT - solution.html 234 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/44. ORDER BY - solution.html 230 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/25. Wildcard characters - exercise.html 221 bytes
SQL - MySQL for Data Analytics and Business Intelligence/15. SQL Subqueries/8. SQL Subqueries nested in SELECT and FROM - exercise 1.html 215 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/58. LIMIT - solution.html 214 bytes
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/7. FOREIGN KEY constraint - Part II - exercise.html 212 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/54. WHERE vs HAVING - Part II - exercise.html 211 bytes
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/3. COUNT() - solution.html 196 bytes
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/8. FOREIGN KEY constraint - Part II - solution.html 192 bytes
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/17. The new and the old join syntax - exercise.html 192 bytes
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/10. MySQL Triggers - exercise.html 191 bytes
SQL - MySQL for Data Analytics and Business Intelligence/15. SQL Subqueries/5. SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - exercise.html 185 bytes
SQL - MySQL for Data Analytics and Business Intelligence/10. SQL INSERT statement/8. Inserting Data INTO a New Table - exercise.html 181 bytes
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/36. UNION vs UNION ALL - exercise.html 179 bytes
SQL - MySQL for Data Analytics and Business Intelligence/11. SQL UPDATE Statement/5. The UPDATE Statement – Part II - exercise.html 172 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/2. SELECT - FROM - exercise.html 170 bytes
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/21. JOIN and WHERE Used Together - exercise.html 169 bytes
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/15. NOT NULL Constraint - Part I - exercise.html 167 bytes
SQL - MySQL for Data Analytics and Business Intelligence/23. Combining SQL and Tableau - Task 3/2. Task 3 - Text.html 167 bytes
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/25. Additional notes on using tables.html 165 bytes
SQL - MySQL for Data Analytics and Business Intelligence/12. SQL DELETE Statement/6. DROP vs TRUNCATE vs DELETE.html 165 bytes
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/23. Another example of using COALESCE().html 165 bytes
SQL - MySQL for Data Analytics and Business Intelligence/16. SQL Self Join/2. Self join.html 165 bytes
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/2. Introduction to Stored Routines.html 165 bytes
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/21. Stored routines - conclusion.html 165 bytes
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/2. Types of MySQL Variables - Local Variables.html 165 bytes
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/4. Session Variables.html 165 bytes
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/6. Global Variables.html 165 bytes
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/8. User-Defined vs System Variables.html 165 bytes
SQL - MySQL for Data Analytics and Business Intelligence/1. Introduction to databases, SQL, and MySQL/3. Why SQL.html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/1. Introduction to databases, SQL, and MySQL/5. Why MySQL.html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/1. Introduction to databases, SQL, and MySQL/7. Introduction to databases.html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/2. SQL as a declarative language.html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/4. Data definition language (DDL).html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/6. SQL keywords.html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/8. Data manipulation language (DML).html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/10. Data control language (DCL).html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/12. Transaction control language (TCL).html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/2. Relational database essentials.html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/4. Databases vs spreadsheets.html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/6. Database terminology.html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/8. Relational schemas - Primary key.html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/10. Relational schemas - Foreign key.html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/12. Relational Schemas - Unique key.html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/14. Relational Schemas – Relationships.html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/9. Introduction to data types.html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/11. String data types.html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/13. Integers.html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/15. Fixed and floating-point data types.html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/17. Other useful data types.html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/2. PRIMARY KEY Constraint.html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/7. SQL best practices/2. Coding techniques and best practices – Part I.html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/7. SQL best practices/4. Coding techniques and best practices – Part II.html 164 bytes
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/26. CROSS JOIN - exercise 2.html 162 bytes
SQL - MySQL for Data Analytics and Business Intelligence/15. SQL Subqueries/2. SQL Subqueries with IN nested inside WHERE - exercise.html 162 bytes
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/15. Variables - solution.html 162 bytes
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/14. MySQL Indexes - solution 1.html 159 bytes
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/14. ROUND() - exercise.html 155 bytes
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/3. Creating a Database - Part I - exercise.html 152 bytes
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/11. Stored procedures with an output parameter - exercise.html 152 bytes
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/24. CROSS JOIN - exercise 1.html 150 bytes
SQL - MySQL for Data Analytics and Business Intelligence/21. Combining SQL and Tableau - Task 1/2. Task 1 - Text.html 149 bytes
SQL - MySQL for Data Analytics and Business Intelligence/12. SQL DELETE Statement/4. The DELETE Statement – Part II - solution.html 148 bytes
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/7. INNER JOIN - Part II - exercise.html 144 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/17. IN - NOT IN - exercise 1.html 140 bytes
SQL - MySQL for Data Analytics and Business Intelligence/22. Combining SQL and Tableau - Task 2/2. Task 2 - Text.html 137 bytes
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/1.1 Course Notes SQL - MySQL for Data Analytics and Business Intelligence.html 134 bytes
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/8. MIN() and MAX() - exercise.html 130 bytes
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/5. SUM() - exercise.html 127 bytes
SQL - MySQL for Data Analytics and Business Intelligence/20. Combining SQL and Tableau - Introduction/4.2 The 'employees_mod' Database.html 125 bytes
SQL - MySQL for Data Analytics and Business Intelligence/20. Combining SQL and Tableau - Introduction/5.1 The 'employees_mod' database.html 125 bytes
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/2. COUNT() - exercise.html 123 bytes
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/4. Creating a Database - Part I - solution.html 122 bytes
SQL - MySQL for Data Analytics and Business Intelligence/8. Loading the 'employees' database/2.1 The 'employees' database.html 121 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/19. IN - NOT IN - exercise 2.html 118 bytes
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/6. Stored procedures - Example - Part II - exercise.html 116 bytes
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/11. AVG() - exercise.html 112 bytes
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/30. Join more than two tables in SQL - exercise.html 109 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/43. ORDER BY - exercise.html 106 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/5. WHERE - exercise.html 93 bytes
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/33. Tips and tricks for joins - exercise.html 93 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/14. Operator precedence - exercise.html 92 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/11. OR - exercise.html 85 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/31. IS NOT NULL - IS NULL - exercise.html 85 bytes
SQL - MySQL for Data Analytics and Business Intelligence/10. SQL INSERT statement/9. Inserting Data INTO a New Table - solution.html 85 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/8. AND - exercise.html 82 bytes
SQL - MySQL for Data Analytics and Business Intelligence/12. SQL DELETE Statement/3. The DELETE Statement – Part II - exercise.html 79 bytes
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/23. Using databases and tables - solution.html 78 bytes
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/57. LIMIT - exercise.html 69 bytes
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/6. Creating a Database - Part II - exercise.html 57 bytes
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/13. MySQL Indexes - exercise 1.html 40 bytes
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/7. Creating a Database - Part II - solution.html 34 bytes
SQL - MySQL for Data Analytics and Business Intelligence/4. Installing MySQL and getting acquainted with the interface/4. The Client-Server Model.html 30 bytes
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/16. COALESCE() - Preamble.html 28 bytes
SQL - MySQL for Data Analytics and Business Intelligence/15. SQL Subqueries/11. SQL Subqueries nested in SELECT and FROM - solution 2.html 15 bytes

SQL - MySQL for Data Analytics and Business Intelligence

File List

Download Torrent

Related Resources

Copyright Infringement