SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/3. Databases vs spreadsheets.mp4169.95MB
SQL - MySQL for Data Analytics and Business Intelligence/1. Introduction to databases, SQL, and MySQL/1. What does the course cover.mp424.25MB
SQL - MySQL for Data Analytics and Business Intelligence/1. Introduction to databases, SQL, and MySQL/2. Why SQL.mp414.75MB
SQL - MySQL for Data Analytics and Business Intelligence/1. Introduction to databases, SQL, and MySQL/4. Why MySQL.mp46.54MB
SQL - MySQL for Data Analytics and Business Intelligence/1. Introduction to databases, SQL, and MySQL/6. Introduction to databases.mp419.6MB
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/1. SQL as a declarative language.mp410.08MB
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/3. Data definition language (DDL).mp48.69MB
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/5. SQL keywords.mp42.48MB
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/7. Data manipulation language (DML).mp49.99MB
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/9. Data control language (DCL).mp48.06MB
SQL - MySQL for Data Analytics and Business Intelligence/2. SQL theory/11. Transaction control language (TCL).mp46.87MB
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/1. Relational database essentials.mp422.97MB
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/5. Database terminology.mp418.96MB
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/7. Relational schemas - Primary key.mp410.42MB
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/9. Relational schemas - Foreign key.mp410.35MB
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/11. Relational schemas - Unique key and null values.mp46.34MB
SQL - MySQL for Data Analytics and Business Intelligence/3. Basic database terminology/13. Relationships.mp49.74MB
SQL - MySQL for Data Analytics and Business Intelligence/4. Installing MySQL and getting acquainted with the interface/1. Installing MySQL.mp489.8MB
SQL - MySQL for Data Analytics and Business Intelligence/4. Installing MySQL and getting acquainted with the interface/5. Setting up a connection.mp46.15MB
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.mp447.72MB
SQL - MySQL for Data Analytics and Business Intelligence/4. Installing MySQL and getting acquainted with the interface/8. Introduction to the MySQL interface.mp411.9MB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/1. Creating a Database - Part I.mp410.36MB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/5. Creating a Database - Part II.mp44.87MB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/8. Introduction to data types.mp43.09MB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/10. String data types.mp49.14MB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/12. Integers.mp48.83MB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/14. Fixed and floating-point data types.mp411.77MB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/16. Other useful data types.mp411.81MB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/18. Creating a table.mp410.67MB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/21. Using databases and tables.mp46.53MB
SQL - MySQL for Data Analytics and Business Intelligence/5. First steps in SQL/24. Additional notes on using tables.mp45.07MB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/1. PRIMARY KEY constraint.mp411.98MB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/5. FOREIGN KEY constraint - Part I.mp411.07MB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/6. FOREIGN KEY constraint - Part II.mp414.54MB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/9. UNIQUE Constraint.mp411.75MB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/11. DEFAULT Constraint.mp413.12MB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/14. NOT NULL Constraint - Part I.mp414.92MB
SQL - MySQL for Data Analytics and Business Intelligence/6. MySQL constraints/17. NOT NULL Constraint - Part II.mp43.69MB
SQL - MySQL for Data Analytics and Business Intelligence/7. SQL best practices/1. Coding techniques and best practices - Part I.mp411.57MB
SQL - MySQL for Data Analytics and Business Intelligence/7. SQL best practices/3. Coding techniques and best practices - Part II.mp49.28MB
SQL - MySQL for Data Analytics and Business Intelligence/8. Loading the 'employees' database/1. Loading the 'employees' database.mp48.14MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/1. SELECT - FROM.mp410.97MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/4. WHERE.mp46.04MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/7. AND.mp44.82MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/10. OR.mp48.47MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/13. Operator precedence.mp48.49MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/16. IN - NOT IN.mp48.25MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/21. LIKE - NOT LIKE.mp49.61MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/24. Wildcard characters.mp43.35MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/27. BETWEEN - AND.mp45.19MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/30. IS NOT NULL - IS NULL.mp43.83MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/33. Other comparison operators.mp411.05MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/36. SELECT DISTINCT.mp44.58MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/39. Introduction to aggregate functions.mp412.66MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/42. ORDER BY.mp410.77MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/45. GROUP BY.mp414.83MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/46. Using Aliases (AS).mp45.26MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/49. HAVING.mp48.92MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/52. WHERE vs HAVING- Part I.mp49.99MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/53. WHERE vs HAVING- Part II.mp46.74MB
SQL - MySQL for Data Analytics and Business Intelligence/9. SQL SELECT statement/56. LIMIT.mp412.7MB
SQL - MySQL for Data Analytics and Business Intelligence/10. SQL INSERT statement/1. The INSERT statement - Part I.mp414.42MB
SQL - MySQL for Data Analytics and Business Intelligence/10. SQL INSERT statement/2. The INSERT statement - Part II.mp46.66MB
SQL - MySQL for Data Analytics and Business Intelligence/10. SQL INSERT statement/7. Inserting data INTO a new table.mp49.62MB
SQL - MySQL for Data Analytics and Business Intelligence/11. SQL UPDATE Statement/1. TCL's COMMIT and ROLLBACK.mp47.82MB
SQL - MySQL for Data Analytics and Business Intelligence/11. SQL UPDATE Statement/2. The UPDATE Statement - Part I.mp47.91MB
SQL - MySQL for Data Analytics and Business Intelligence/11. SQL UPDATE Statement/4. The UPDATE Statement - Part II.mp47.39MB
SQL - MySQL for Data Analytics and Business Intelligence/12. SQL DELETE Statement/1. The DELETE Statement - Part I.mp410.31MB
SQL - MySQL for Data Analytics and Business Intelligence/12. SQL DELETE Statement/2. The DELETE Statement - Part II.mp43.68MB
SQL - MySQL for Data Analytics and Business Intelligence/12. SQL DELETE Statement/5. DROP vs TRUNCATE vs DELETE.mp47.48MB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/1. COUNT().mp49.24MB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/4. SUM().mp43.22MB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/7. MIN() and MAX().mp42.97MB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/10. AVG().mp44.16MB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/13. ROUND().mp44.74MB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/17. IFNULL() and COALESCE().mp415.75MB
SQL - MySQL for Data Analytics and Business Intelligence/13. MySQL - Aggregate functions/18. Another Example of Using COALESCE().mp43.71MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/1. Introduction to JOINs.mp47.22MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/5. INNER JOIN - Part I.mp412.43MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/6. INNER JOIN - Part II.mp411.62MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/9. A Note on Using Joins.mp410.77MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/10. Duplicate Records.mp412.73MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/11. LEFT JOIN - Part I.mp414.02MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/12. LEFT JOIN - Part II.mp414.82MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/15. RIGHT JOIN.mp432.09MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/16. The new and the old join syntax.mp49.17MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/19. JOIN and WHERE Used Together.mp46.55MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/23. CROSS JOIN.mp489.99MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/28. Using Aggregate Functions with Joins.mp46.22MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/29. JOIN more than two tables in SQL.mp410.95MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/32. Tips and tricks for joins.mp450.91MB
SQL - MySQL for Data Analytics and Business Intelligence/14. SQL Joins/35. UNION vs UNION ALL.mp48.54MB
SQL - MySQL for Data Analytics and Business Intelligence/15. SQL Subqueries/1. SQL Subqueries with IN nested inside WHERE.mp46.72MB
SQL - MySQL for Data Analytics and Business Intelligence/15. SQL Subqueries/4. SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE.mp48.64MB
SQL - MySQL for Data Analytics and Business Intelligence/15. SQL Subqueries/7. SQL Subqueries nested in SELECT and FROM.mp419.91MB
SQL - MySQL for Data Analytics and Business Intelligence/16. SQL Self Join/1. Self Join.mp420.83MB
SQL - MySQL for Data Analytics and Business Intelligence/17. SQL Views/1. Views.mp417.48MB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/1. Introduction to stored routines.mp47.23MB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/3. The MySQL syntax for stored procedures.mp45.96MB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/4. Stored procedures - Example - Part I.mp47.24MB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/5. Stored procedures - Example - Part II.mp411.18MB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/8. Another way to create a procedure.mp45.43MB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/9. Stored procedures with an input parameter.mp417.07MB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/10. Stored procedures with an output parameter.mp48.52MB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/13. Variables.mp415.97MB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/16. User-defined functions in MySQL.mp448.76MB
SQL - MySQL for Data Analytics and Business Intelligence/18. Stored routines/20. Stored routines - conclusion.mp48.18MB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/1. Types of MySQL Variables - Local Variables.mp411.57MB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/3. Session Variables.mp411.97MB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/5. Global Variables.mp45.01MB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/7. User-Defined vs System Variables.mp410.96MB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/12. MySQL Indexes.mp418.21MB
SQL - MySQL for Data Analytics and Business Intelligence/19. Advanced SQL Topics/17. The CASE Statement.mp459.41MB
SQL - MySQL for Data Analytics and Business Intelligence/20. Combining SQL and Tableau - Introduction/1. The Advantages of Software Integration.mp492.4MB
SQL - MySQL for Data Analytics and Business Intelligence/20. Combining SQL and Tableau - Introduction/2. Why Combining SQL and Tableau is useful.mp485.35MB
SQL - MySQL for Data Analytics and Business Intelligence/20. Combining SQL and Tableau - Introduction/3. Installing Tableau Public.mp427.36MB
SQL - MySQL for Data Analytics and Business Intelligence/20. Combining SQL and Tableau - Introduction/4. Loading the 'employees_mod' Database.mp428.53MB
SQL - MySQL for Data Analytics and Business Intelligence/21. Combining SQL and Tableau - Task 1/1. Task 1.mp433.52MB
SQL - MySQL for Data Analytics and Business Intelligence/21. Combining SQL and Tableau - Task 1/4. Task 1 SQL Solution.mp443.16MB
SQL - MySQL for Data Analytics and Business Intelligence/21. Combining SQL and Tableau - Task 1/6. Transferring a Dataset from SQL to Tableau.mp431.42MB
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.mp440.54MB
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.mp445.1MB
SQL - MySQL for Data Analytics and Business Intelligence/22. Combining SQL and Tableau - Task 2/1. Task 2.mp428.85MB
SQL - MySQL for Data Analytics and Business Intelligence/22. Combining SQL and Tableau - Task 2/3. Task 2 SQL Solution.mp439.29MB
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.mp448.93MB
SQL - MySQL for Data Analytics and Business Intelligence/23. Combining SQL and Tableau - Task 3/1. Task 3.mp413.07MB
SQL - MySQL for Data Analytics and Business Intelligence/23. Combining SQL and Tableau - Task 3/3. Task 3 SQL Solution.mp433.12MB
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.mp440.32MB
SQL - MySQL for Data Analytics and Business Intelligence/24. Combining SQL and Tableau - Task 4/1. Task 4.mp423.56MB
SQL - MySQL for Data Analytics and Business Intelligence/24. Combining SQL and Tableau - Task 4/3. Task 4 Solution in SQL.mp430.25MB
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.mp422.28MB
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.mp455.98MB