[] Udemy - SQL - MySQL for Data Analytics and Business Intelligence
- 收录时间:2020-01-18 16:52:07
- 文件大小:2GB
- 下载次数:119
- 最近下载:2021-01-09 15:03:28
- 磁力链接:
-
文件列表
- 3. Basic database terminology/3. Databases vs spreadsheets.mp4 170MB
- 20. Combining SQL and Tableau - Introduction/1. The Advantages of Software Integration.mp4 92MB
- 14. SQL Joins/23. CROSS JOIN.mp4 90MB
- 4. Installing MySQL and getting acquainted with the interface/1. Installing MySQL.mp4 90MB
- 20. Combining SQL and Tableau - Introduction/2. Why Combining SQL and Tableau is useful.mp4 85MB
- 19. Advanced SQL Topics/17. The CASE Statement.mp4 59MB
- 25. Combining SQL and Tableau - Task 5/1. Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau.mp4 56MB
- 14. SQL Joins/32. Tips and tricks for joins.mp4 51MB
- 22. Combining SQL and Tableau - Task 2/5. Chart 2 Visualizing and Analyzing the Solution in Tableau.mp4 49MB
- 18. Stored routines/16. User-defined functions in MySQL.mp4 49MB
- 4. Installing MySQL and getting acquainted with the interface/7. New Authentication Plugin - Creating a New User.mp4 48MB
- 21. Combining SQL and Tableau - Task 1/8. Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II.mp4 45MB
- 21. Combining SQL and Tableau - Task 1/4. Task 1 SQL Solution.mp4 43MB
- 21. Combining SQL and Tableau - Task 1/7. Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I.mp4 41MB
- 23. Combining SQL and Tableau - Task 3/5. Chart 3 Visualizing and Analyzing the Solution in Tableau.mp4 40MB
- 22. Combining SQL and Tableau - Task 2/3. Task 2 SQL Solution.mp4 39MB
- 18. Stored routines/2. Introduction to Stored Routines.html 38MB
- 21. Combining SQL and Tableau - Task 1/1. Task 1.mp4 34MB
- 23. Combining SQL and Tableau - Task 3/3. Task 3 SQL Solution.mp4 33MB
- 14. SQL Joins/15. RIGHT JOIN.mp4 32MB
- 21. Combining SQL and Tableau - Task 1/6. Transferring a Dataset from SQL to Tableau.mp4 31MB
- 24. Combining SQL and Tableau - Task 4/3. Task 4 Solution in SQL.mp4 30MB
- 22. Combining SQL and Tableau - Task 2/1. Task 2.mp4 29MB
- 20. Combining SQL and Tableau - Introduction/4. Loading the 'employees_mod' Database.mp4 29MB
- 20. Combining SQL and Tableau - Introduction/3. Installing Tableau Public.mp4 27MB
- 1. Introduction to databases, SQL, and MySQL/1. What does the course cover.mp4 24MB
- 24. Combining SQL and Tableau - Task 4/1. Task 4.mp4 24MB
- 3. Basic database terminology/1. Relational database essentials.mp4 23MB
- 24. Combining SQL and Tableau - Task 4/5. Chart 4 Visualizing and Analyzing the Solution in Tableau.mp4 22MB
- 16. SQL Self Join/1. Self Join.mp4 21MB
- 15. SQL Subqueries/7. SQL Subqueries nested in SELECT and FROM.mp4 20MB
- 1. Introduction to databases, SQL, and MySQL/6. Introduction to databases.mp4 20MB
- 3. Basic database terminology/5. Database terminology.mp4 19MB
- 19. Advanced SQL Topics/12. MySQL Indexes.mp4 18MB
- 17. SQL Views/1. Views.mp4 17MB
- 18. Stored routines/9. Stored procedures with an input parameter.mp4 17MB
- 18. Stored routines/13. Variables.mp4 16MB
- 13. MySQL - Aggregate functions/17. IFNULL() and COALESCE().mp4 16MB
- 6. MySQL constraints/14. NOT NULL Constraint - Part I.mp4 15MB
- 9. SQL SELECT statement/45. GROUP BY.mp4 15MB
- 14. SQL Joins/12. LEFT JOIN - Part II.mp4 15MB
- 1. Introduction to databases, SQL, and MySQL/2. Why SQL.mp4 15MB
- 6. MySQL constraints/6. FOREIGN KEY constraint - Part II.mp4 15MB
- 10. SQL INSERT statement/1. The INSERT statement - Part I.mp4 14MB
- 14. SQL Joins/11. LEFT JOIN - Part I.mp4 14MB
- 6. MySQL constraints/11. DEFAULT Constraint.mp4 13MB
- 23. Combining SQL and Tableau - Task 3/1. Task 3.mp4 13MB
- 14. SQL Joins/10. Duplicate Records.mp4 13MB
- 9. SQL SELECT statement/56. LIMIT.mp4 13MB
- 9. SQL SELECT statement/39. Introduction to aggregate functions.mp4 13MB
- 14. SQL Joins/5. INNER JOIN - Part I.mp4 12MB
- 6. MySQL constraints/1. PRIMARY KEY constraint.mp4 12MB
- 19. Advanced SQL Topics/3. Session Variables.mp4 12MB
- 4. Installing MySQL and getting acquainted with the interface/8. Introduction to the MySQL interface.mp4 12MB
- 5. First steps in SQL/16. Other useful data types.mp4 12MB
- 5. First steps in SQL/14. Fixed and floating-point data types.mp4 12MB
- 6. MySQL constraints/9. UNIQUE Constraint.mp4 12MB
- 14. SQL Joins/6. INNER JOIN - Part II.mp4 12MB
- 19. Advanced SQL Topics/1. Types of MySQL Variables - Local Variables.mp4 12MB
- 7. SQL best practices/1. Coding techniques and best practices - Part I.mp4 12MB
- 18. Stored routines/5. Stored procedures - Example - Part II.mp4 11MB
- 9. SQL SELECT statement/33. Other comparison operators.mp4 11MB
- 6. MySQL constraints/5. FOREIGN KEY constraint - Part I.mp4 11MB
- 9. SQL SELECT statement/1. SELECT - FROM.mp4 11MB
- 19. Advanced SQL Topics/7. User-Defined vs System Variables.mp4 11MB
- 14. SQL Joins/29. JOIN more than two tables in SQL.mp4 11MB
- 9. SQL SELECT statement/42. ORDER BY.mp4 11MB
- 14. SQL Joins/9. A Note on Using Joins.mp4 11MB
- 5. First steps in SQL/18. Creating a table.mp4 11MB
- 3. Basic database terminology/7. Relational schemas - Primary key.mp4 10MB
- 3. Basic database terminology/9. Relational schemas - Foreign key.mp4 10MB
- 5. First steps in SQL/1. Creating a Database - Part I.mp4 10MB
- 12. SQL DELETE Statement/1. The DELETE Statement - Part I.mp4 10MB
- 2. SQL theory/1. SQL as a declarative language.mp4 10MB
- 9. SQL SELECT statement/52. WHERE vs HAVING- Part I.mp4 10MB
- 2. SQL theory/7. Data manipulation language (DML).mp4 10MB
- 3. Basic database terminology/13. Relationships.mp4 10MB
- 10. SQL INSERT statement/7. Inserting data INTO a new table.mp4 10MB
- 9. SQL SELECT statement/21. LIKE - NOT LIKE.mp4 10MB
- 7. SQL best practices/3. Coding techniques and best practices - Part II.mp4 9MB
- 13. MySQL - Aggregate functions/1. COUNT().mp4 9MB
- 14. SQL Joins/16. The new and the old join syntax.mp4 9MB
- 5. First steps in SQL/10. String data types.mp4 9MB
- 9. SQL SELECT statement/49. HAVING.mp4 9MB
- 5. First steps in SQL/12. Integers.mp4 9MB
- 2. SQL theory/3. Data definition language (DDL).mp4 9MB
- 15. SQL Subqueries/4. SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE.mp4 9MB
- 14. SQL Joins/35. UNION vs UNION ALL.mp4 9MB
- 18. Stored routines/10. Stored procedures with an output parameter.mp4 9MB
- 9. SQL SELECT statement/13. Operator precedence.mp4 8MB
- 9. SQL SELECT statement/10. OR.mp4 8MB
- 9. SQL SELECT statement/16. IN - NOT IN.mp4 8MB
- 18. Stored routines/20. Stored routines - conclusion.mp4 8MB
- 8. Loading the 'employees' database/1. Loading the 'employees' database.mp4 8MB
- 2. SQL theory/9. Data control language (DCL).mp4 8MB
- 11. SQL UPDATE Statement/2. The UPDATE Statement - Part I.mp4 8MB
- 11. SQL UPDATE Statement/1. TCL's COMMIT and ROLLBACK.mp4 8MB
- 12. SQL DELETE Statement/5. DROP vs TRUNCATE vs DELETE.mp4 7MB
- 11. SQL UPDATE Statement/4. The UPDATE Statement - Part II.mp4 7MB
- 18. Stored routines/4. Stored procedures - Example - Part I.mp4 7MB
- 18. Stored routines/1. Introduction to stored routines.mp4 7MB
- 14. SQL Joins/1. Introduction to JOINs.mp4 7MB
- 2. SQL theory/11. Transaction control language (TCL).mp4 7MB
- 8. Loading the 'employees' database/1. Loading the 'employees' database.srt 7MB
- 9. SQL SELECT statement/53. WHERE vs HAVING- Part II.mp4 7MB
- 15. SQL Subqueries/1. SQL Subqueries with IN nested inside WHERE.mp4 7MB
- 10. SQL INSERT statement/2. The INSERT statement - Part II.mp4 7MB
- 14. SQL Joins/19. JOIN and WHERE Used Together.mp4 7MB
- 1. Introduction to databases, SQL, and MySQL/4. Why MySQL.mp4 7MB
- 5. First steps in SQL/21. Using databases and tables.mp4 7MB
- 3. Basic database terminology/11. Relational schemas - Unique key and null values.mp4 6MB
- 14. SQL Joins/28. Using Aggregate Functions with Joins.mp4 6MB
- 4. Installing MySQL and getting acquainted with the interface/5. Setting up a connection.mp4 6MB
- 9. SQL SELECT statement/4. WHERE.mp4 6MB
- 18. Stored routines/3. The MySQL syntax for stored procedures.mp4 6MB
- 18. Stored routines/8. Another way to create a procedure.mp4 5MB
- 9. SQL SELECT statement/46. Using Aliases (AS).mp4 5MB
- 9. SQL SELECT statement/27. BETWEEN - AND.mp4 5MB
- 5. First steps in SQL/24. Additional notes on using tables.mp4 5MB
- 19. Advanced SQL Topics/5. Global Variables.mp4 5MB
- 5. First steps in SQL/5. Creating a Database - Part II.mp4 5MB
- 9. SQL SELECT statement/7. AND.mp4 5MB
- 13. MySQL - Aggregate functions/13. ROUND().mp4 5MB
- 9. SQL SELECT statement/36. SELECT DISTINCT.mp4 5MB
- 13. MySQL - Aggregate functions/10. AVG().mp4 4MB
- 9. SQL SELECT statement/30. IS NOT NULL - IS NULL.mp4 4MB
- 13. MySQL - Aggregate functions/18. Another Example of Using COALESCE().mp4 4MB
- 12. SQL DELETE Statement/2. The DELETE Statement - Part II.mp4 4MB
- 6. MySQL constraints/17. NOT NULL Constraint - Part II.mp4 4MB
- 9. SQL SELECT statement/24. Wildcard characters.mp4 3MB
- 13. MySQL - Aggregate functions/4. SUM().mp4 3MB
- 11. SQL UPDATE Statement/1. TCL's COMMIT and ROLLBACK.srt 3MB
- 5. First steps in SQL/8. Introduction to data types.mp4 3MB
- 13. MySQL - Aggregate functions/7. MIN() and MAX().mp4 3MB
- 2. SQL theory/5. SQL keywords.mp4 2MB
- 19. Advanced SQL Topics/3.1 Session Variables.pdf.pdf 2MB
- 3. Basic database terminology/13.1 Relationships.pdf.pdf 1MB
- 19. Advanced SQL Topics/12.1 MySQL Indexes.pdf.pdf 1MB
- 2. SQL theory/3.1 DDL.pdf.pdf 1MB
- 3. Basic database terminology/7.1 Relational Schemas - Primary Key.pdf.pdf 1MB
- 7. SQL best practices/1.1 Coding Techniques and Best Practices.pdf.pdf 1MB
- 1. Introduction to databases, SQL, and MySQL/2.1 SQL - FAQ.pdf.pdf 1MB
- 5. First steps in SQL/2.3 SQL - FAQ.pdf.pdf 1MB
- 6. MySQL constraints/5.1 FOREIGN KEY Constraint.pdf.pdf 1MB
- 15. SQL Subqueries/1.1 Subqueries IN WHERE.pdf.pdf 1MB
- 13. MySQL - Aggregate functions/1.1 COUNT().pdf.pdf 1MB
- 12. SQL DELETE Statement/5.1 DROP vs TRUNCATE vs DELETE.pdf.pdf 1MB
- 17. SQL Views/1.1 SQL Views.pdf.pdf 1MB
- 15. SQL Subqueries/4.1 Subqueries EXISTS WHERE.pdf.pdf 1MB
- 2. SQL theory/11.1 TCL.pdf.pdf 966KB
- 3. Basic database terminology/9.1 Relational Schemas - Foreign Key.pdf.pdf 960KB
- 2. SQL theory/7.1 DML.pdf.pdf 913KB
- 18. Stored routines/3.1 The MySQL Syntax for Stored Procedures.pdf.pdf 911KB
- 19. Advanced SQL Topics/1.1 Types of MySQL Variables - Local Variables.pdf.pdf 866KB
- 14. SQL Joins/15.1 RIGHT JOIN.pdf.pdf 856KB
- 14. SQL Joins/35.1 UNION vs UNION ALL.pdf.pdf 824KB
- 5. First steps in SQL/1.1 Creating a Database - Part I.pdf.pdf 794KB
- 14. SQL Joins/5.1 INNER JOIN.pdf.pdf 778KB
- 14. SQL Joins/1.1 Introduction to Joins.pdf.pdf 776KB
- 3. Basic database terminology/11.1 Relational Schemas - Unique Key and Null Values.pdf.pdf 774KB
- 9. SQL SELECT statement/52.1 WHERE vs HAVING.pdf.pdf 768KB
- 14. SQL Joins/11.1 LEFT JOIN.pdf.pdf 739KB
- 9. SQL SELECT statement/39.1 Introduction to Aggregate Functions.pdf.pdf 737KB
- 18. Stored routines/1.1 Introduction to Stored Routines.pdf.pdf 730KB
- 5. First steps in SQL/16.1 Other Useful Data Types.pdf.pdf 729KB
- 6. MySQL constraints/9.1 UNIQUE Constraint.pdf.pdf 727KB
- 18. Stored routines/20.1 Stored Routines - Conclusion.pdf.pdf 724KB
- 14. SQL Joins/16.1 The New and the Old Join Syntax.pdf.pdf 719KB
- 18. Stored routines/13.1 Variables.pdf.pdf 718KB
- 13. MySQL - Aggregate functions/17.1 IFNULL() and COALESCE().pdf.pdf 716KB
- 16. SQL Self Join/1.1 SQL Self Join.pdf.pdf 704KB
- 5. First steps in SQL/14.1 Fixed- and Floating-Point Data Types.pdf.pdf 702KB
- 19. Advanced SQL Topics/7.1 User-Defined vs System Variables.pdf.pdf 699KB
- 2. SQL theory/9.1 DCL.pdf.pdf 683KB
- 6. MySQL constraints/14.1 NOT NULL Constraint.pdf.pdf 680KB
- 19. Advanced SQL Topics/5.1 Global Variables.pdf.pdf 676KB
- 5. First steps in SQL/12.1 Integers.pdf.pdf 656KB
- 9. SQL SELECT statement/27.1 BETWEEN - AND.pdf.pdf 656KB
- 14. SQL Joins/29.1 JOIN More Than Two Tables in SQL.pdf.pdf 624KB
- 13. MySQL - Aggregate functions/16.1 COALESCE() - Preamble.pdf.pdf 582KB
- 11. SQL UPDATE Statement/1.1 TCL's COMMIT and ROLLBACK.pdf.pdf 580KB
- 9. SQL SELECT statement/1.1 SELECT - FROM.pdf.pdf 572KB
- 26. Practice SQL – 10 Final Query Questions/1.2 Practice SQL - 10 Final Query Questions.pdf.pdf 558KB
- 4. Installing MySQL and getting acquainted with the interface/4.1 The Client-Server Model.pdf.pdf 557KB
- 18. Stored routines/9.1 Stored Procedures with an Input Parameter.pdf.pdf 548KB
- 6. MySQL constraints/1.2 PRIMARY KEY Constraint.pdf.pdf 547KB
- 5. First steps in SQL/18.1 Creating a Table.pdf.pdf 543KB
- 2. SQL theory/5.1 SQL Keywords.pdf.pdf 533KB
- 5. First steps in SQL/21.1 Using Databases and Tables.pdf.pdf 530KB
- 7. SQL best practices/1.2 MySQL_Workbench_Shortcuts.pdf.pdf 515KB
- 6. MySQL constraints/11.1 DEFAULT Constraint.pdf.pdf 515KB
- 18. Stored routines/16.1 User-Defined Functions in MySQL.pdf.pdf 512KB
- 5. First steps in SQL/8.1 Introduction to Data Types.pdf.pdf 497KB
- 13. MySQL - Aggregate functions/4.1 SUM().pdf.pdf 494KB
- 9. SQL SELECT statement/7.1 AND.pdf.pdf 490KB
- 14. SQL Joins/32.1 Tips and Tricks for Joins.pdf.pdf 479KB
- 9. SQL SELECT statement/49.1 HAVING.pdf.pdf 463KB
- 11. SQL UPDATE Statement/2.1 The UPDATE Statement.pdf.pdf 456KB
- 9. SQL SELECT statement/45.1 GROUP BY.pdf.pdf 455KB
- 5. First steps in SQL/10.1 String Data Types.pdf.pdf 443KB
- 13. MySQL - Aggregate functions/10.1 AVG().pdf.pdf 443KB
- 18. Stored routines/10.1 Stored Procedures with an Output Parameter.pdf.pdf 429KB
- 9. SQL SELECT statement/13.1 Operator Precedence.pdf.pdf 420KB
- 9. SQL SELECT statement/4.1 WHERE.pdf.pdf 414KB
- 9. SQL SELECT statement/24.1 Wildcard Characters.pdf.pdf 406KB
- 15. SQL Subqueries/7.1 Subqueries SELECT FROM.pdf.pdf 404KB
- 14. SQL Joins/19.1 JOIN and WHERE Used Together.pdf.pdf 398KB
- 9. SQL SELECT statement/36.1 SELECT DISTINCT.pdf.pdf 383KB
- 5. First steps in SQL/24.1 Additional Notes on Using Tables.pdf.pdf 382KB
- 10. SQL INSERT statement/1.1 The INSERT Statement.pdf.pdf 372KB
- 12. SQL DELETE Statement/1.1 The DELETE Statement.pdf.pdf 361KB
- 9. SQL SELECT statement/30.1 IS NOT NULL - IS NULL.pdf.pdf 357KB
- 9. SQL SELECT statement/10.1 OR.pdf.pdf 351KB
- 9. SQL SELECT statement/33.1 Other Comparison Operators.pdf.pdf 340KB
- 14. SQL Joins/10.1 Duplicate Records.pdf.pdf 337KB
- 13. MySQL - Aggregate functions/13.1 ROUND().pdf.pdf 335KB
- 14. SQL Joins/23.1 CROSS JOIN.pdf.pdf 314KB
- 10. SQL INSERT statement/7.1 Inserting Data INTO a New Table.pdf.pdf 302KB
- 19. Advanced SQL Topics/17.1 The CASE Statement.pdf.pdf 302KB
- 9. SQL SELECT statement/56.1 LIMIT.pdf.pdf 297KB
- 13. MySQL - Aggregate functions/7.1 MIN() and MAX().pdf.pdf 285KB
- 9. SQL SELECT statement/1.2 employees_db.pdf.pdf 179KB
- 6. MySQL constraints/1.1 sales_db.pdf.pdf 141KB
- 20. Combining SQL and Tableau - Introduction/4.1 employees_mod_db.pdf.pdf 130KB
- 20. Combining SQL and Tableau - Introduction/5.2 employees_mod_db.pdf.pdf 130KB
- 5. First steps in SQL/2.1 MySQL for Data Analytics and BI - Lecture Code and Tasks Solutions.sql.sql 61KB
- 5. First steps in SQL/2.2 MySQL for Data Analytics and BI - Lecture Code.sql.sql 43KB
- 4. Installing MySQL and getting acquainted with the interface/1. Installing MySQL.srt 13KB
- 3. Basic database terminology/3. Databases vs spreadsheets.srt 12KB
- 14. SQL Joins/23. CROSS JOIN.srt 10KB
- 19. Advanced SQL Topics/9.1 MySQL Triggers.sql.sql 10KB
- 16. SQL Self Join/1. Self Join.srt 9KB
- 15. SQL Subqueries/7. SQL Subqueries nested in SELECT and FROM.srt 9KB
- 19. Advanced SQL Topics/12. MySQL Indexes.srt 8KB
- 17. SQL Views/1. Views.srt 8KB
- 5. First steps in SQL/16. Other useful data types.srt 8KB
- 18. Stored routines/9. Stored procedures with an input parameter.srt 8KB
- 18. Stored routines/13. Variables.srt 8KB
- 21. Combining SQL and Tableau - Task 1/7. Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I.srt 7KB
- 13. MySQL - Aggregate functions/17. IFNULL() and COALESCE().srt 7KB
- 22. Combining SQL and Tableau - Task 2/5. Chart 2 Visualizing and Analyzing the Solution in Tableau.srt 7KB
- 18. Stored routines/16. User-defined functions in MySQL.srt 7KB
- 5. First steps in SQL/14. Fixed and floating-point data types.srt 7KB
- 5. First steps in SQL/1. Creating a Database - Part I.srt 7KB
- 21. Combining SQL and Tableau - Task 1/1. Task 1.srt 7KB
- 20. Combining SQL and Tableau - Introduction/1. The Advantages of Software Integration.srt 7KB
- 1. Introduction to databases, SQL, and MySQL/6. Introduction to databases.srt 7KB
- 26. Practice SQL – 10 Final Query Questions/1.1 Practice SQL – 10 Final Query Questions - SOLUTIONS.sql.sql 7KB
- 14. SQL Joins/12. LEFT JOIN - Part II.srt 7KB
- 3. Basic database terminology/7. Relational schemas - Primary key.srt 7KB
- 9. SQL SELECT statement/45. GROUP BY.srt 7KB
- 10. SQL INSERT statement/1. The INSERT statement - Part I.srt 7KB
- 2. SQL theory/9. Data control language (DCL).srt 7KB
- 3. Basic database terminology/9. Relational schemas - Foreign key.srt 7KB
- 19. Advanced SQL Topics/17. The CASE Statement.srt 7KB
- 14. SQL Joins/32. Tips and tricks for joins.srt 7KB
- 21. Combining SQL and Tableau - Task 1/8. Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II.srt 7KB
- 14. SQL Joins/5. INNER JOIN - Part I.srt 7KB
- 6. MySQL constraints/1. PRIMARY KEY constraint.srt 7KB
- 6. MySQL constraints/14. NOT NULL Constraint - Part I.srt 7KB
- 7. SQL best practices/1. Coding techniques and best practices - Part I.srt 7KB
- 5. First steps in SQL/18. Creating a table.srt 7KB
- 4. Installing MySQL and getting acquainted with the interface/7. New Authentication Plugin - Creating a New User.srt 7KB
- 25. Combining SQL and Tableau - Task 5/1. Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau.srt 7KB
- 9. SQL SELECT statement/39. Introduction to aggregate functions.srt 7KB
- 3. Basic database terminology/1. Relational database essentials.srt 7KB
- 14. SQL Joins/6. INNER JOIN - Part II.srt 7KB
- 1. Introduction to databases, SQL, and MySQL/1. What does the course cover.srt 7KB
- 19. Advanced SQL Topics/3. Session Variables.srt 7KB
- 6. MySQL constraints/5. FOREIGN KEY constraint - Part I.srt 7KB
- 6. MySQL constraints/11. DEFAULT Constraint.srt 7KB
- 2. SQL theory/7. Data manipulation language (DML).srt 6KB
- 14. SQL Joins/35. UNION vs UNION ALL.srt 6KB
- 5. First steps in SQL/10. String data types.srt 6KB
- 20. Combining SQL and Tableau - Introduction/2. Why Combining SQL and Tableau is useful.srt 6KB
- 4. Installing MySQL and getting acquainted with the interface/8. Introduction to the MySQL interface.srt 6KB
- 3. Basic database terminology/13. Relationships.srt 6KB
- 2. SQL theory/3. Data definition language (DDL).srt 6KB
- 18. Stored routines/5. Stored procedures - Example - Part II.srt 6KB
- 3. Basic database terminology/5. Database terminology.srt 6KB
- 9. SQL SELECT statement/56. LIMIT.srt 6KB
- 23. Combining SQL and Tableau - Task 3/5. Chart 3 Visualizing and Analyzing the Solution in Tableau.srt 6KB
- 14. SQL Joins/11. LEFT JOIN - Part I.srt 6KB
- 6. MySQL constraints/6. FOREIGN KEY constraint - Part II.srt 6KB
- 19. Advanced SQL Topics/1. Types of MySQL Variables - Local Variables.srt 6KB
- 9. SQL SELECT statement/1. SELECT - FROM.srt 6KB
- 18. Stored routines/3. The MySQL syntax for stored procedures.srt 6KB
- 21. Combining SQL and Tableau - Task 1/4. Task 1 SQL Solution.srt 6KB
- 6. MySQL constraints/9. UNIQUE Constraint.srt 5KB
- 14. SQL Joins/16. The new and the old join syntax.srt 5KB
- 14. SQL Joins/10. Duplicate Records.srt 5KB
- 13. MySQL - Aggregate functions/1. COUNT().srt 5KB
- 14. SQL Joins/15. RIGHT JOIN.srt 5KB
- 5. First steps in SQL/12. Integers.srt 5KB
- 14. SQL Joins/1. Introduction to JOINs.srt 5KB
- 19. Advanced SQL Topics/7. User-Defined vs System Variables.srt 5KB
- 21. Combining SQL and Tableau - Task 1/6. Transferring a Dataset from SQL to Tableau.srt 5KB
- 15. SQL Subqueries/1. SQL Subqueries with IN nested inside WHERE.srt 5KB
- 14. SQL Joins/9. A Note on Using Joins.srt 5KB
- 9. SQL SELECT statement/33. Other comparison operators.srt 5KB
- 12. SQL DELETE Statement/1. The DELETE Statement - Part I.srt 5KB
- 14. SQL Joins/29. JOIN more than two tables in SQL.srt 5KB
- 7. SQL best practices/3. Coding techniques and best practices - Part II.srt 5KB
- 9. SQL SELECT statement/52. WHERE vs HAVING- Part I.srt 5KB
- 1. Introduction to databases, SQL, and MySQL/2. Why SQL.srt 5KB
- 18. Stored routines/20. Stored routines - conclusion.srt 5KB
- 22. Combining SQL and Tableau - Task 2/1. Task 2.srt 5KB
- 18. Stored routines/1. Introduction to stored routines.srt 5KB
- 10. SQL INSERT statement/7. Inserting data INTO a new table.srt 5KB
- 3. Basic database terminology/11. Relational schemas - Unique key and null values.srt 4KB
- 2. SQL theory/11. Transaction control language (TCL).srt 4KB
- 9. SQL SELECT statement/21. LIKE - NOT LIKE.srt 4KB
- 22. Combining SQL and Tableau - Task 2/3. Task 2 SQL Solution.srt 4KB
- 9. SQL SELECT statement/42. ORDER BY.srt 4KB
- 9. SQL SELECT statement/13. Operator precedence.srt 4KB
- 15. SQL Subqueries/4. SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE.srt 4KB
- 9. SQL SELECT statement/49. HAVING.srt 4KB
- 20. Combining SQL and Tableau - Introduction/4. Loading the 'employees_mod' Database.srt 4KB
- 18. Stored routines/10. Stored procedures with an output parameter.srt 4KB
- 12. SQL DELETE Statement/5. DROP vs TRUNCATE vs DELETE.srt 4KB
- 9. SQL SELECT statement/53. WHERE vs HAVING- Part II.srt 4KB
- 9. SQL SELECT statement/10. OR.srt 4KB
- 23. Combining SQL and Tableau - Task 3/3. Task 3 SQL Solution.srt 4KB
- 9. SQL SELECT statement/16. IN - NOT IN.srt 4KB
- 24. Combining SQL and Tableau - Task 4/5. Chart 4 Visualizing and Analyzing the Solution in Tableau.srt 4KB
- 11. SQL UPDATE Statement/2. The UPDATE Statement - Part I.srt 4KB
- 18. Stored routines/8. Another way to create a procedure.srt 4KB
- 24. Combining SQL and Tableau - Task 4/1. Task 4.srt 4KB
- 14. SQL Joins/19. JOIN and WHERE Used Together.srt 3KB
- 11. SQL UPDATE Statement/4. The UPDATE Statement - Part II.srt 3KB
- 14. SQL Joins/20. Important – Prevent Error Code 1055!.html 3KB
- 5. First steps in SQL/5. Creating a Database - Part II.srt 3KB
- 18. Stored routines/4. Stored procedures - Example - Part I.srt 3KB
- 4. Installing MySQL and getting acquainted with the interface/5. Setting up a connection.srt 3KB
- 5. First steps in SQL/21. Using databases and tables.srt 3KB
- 24. Combining SQL and Tableau - Task 4/3. Task 4 Solution in SQL.srt 3KB
- 2. SQL theory/1. SQL as a declarative language.srt 3KB
- 9. SQL SELECT statement/4. WHERE.srt 3KB
- 1. Introduction to databases, SQL, and MySQL/4. Why MySQL.srt 3KB
- 5. First steps in SQL/8. Introduction to data types.srt 3KB
- 23. Combining SQL and Tableau - Task 3/1. Task 3.srt 3KB
- 18. Stored routines/17. Error Code 1418..html 3KB
- 14. SQL Joins/28. Using Aggregate Functions with Joins.srt 3KB
- 19. Advanced SQL Topics/5. Global Variables.srt 3KB
- 9. SQL SELECT statement/46. Using Aliases (AS).srt 3KB
- 6. MySQL constraints/4. PRIMARY KEY constraint - solution.html 3KB
- 5. First steps in SQL/24. Additional notes on using tables.srt 3KB
- 9. SQL SELECT statement/36. SELECT DISTINCT.srt 3KB
- 13. MySQL - Aggregate functions/13. ROUND().srt 3KB
- 10. SQL INSERT statement/2. The INSERT statement - Part II.srt 3KB
- 13. MySQL - Aggregate functions/10. AVG().srt 3KB
- 9. SQL SELECT statement/7. AND.srt 3KB
- 6. MySQL constraints/17. NOT NULL Constraint - Part II.srt 2KB
- 9. SQL SELECT statement/24. Wildcard characters.srt 2KB
- 14. SQL Joins/31. Join more than two tables in SQL - solution.html 2KB
- 9. SQL SELECT statement/27. BETWEEN - AND.srt 2KB
- 20. Combining SQL and Tableau - Introduction/3. Installing Tableau Public.srt 2KB
- 4. Installing MySQL and getting acquainted with the interface/3. Installing MySQL on macOS and Unix systems.html 2KB
- 13. MySQL - Aggregate functions/18. Another Example of Using COALESCE().srt 2KB
- 27. BONUS LECTURE/1. Bonus Lecture Next Steps.html 2KB
- 9. SQL SELECT statement/30. IS NOT NULL - IS NULL.srt 2KB
- 13. MySQL - Aggregate functions/4. SUM().srt 2KB
- 15. SQL Subqueries/11.1 Subqueries SELECT FROM Solution.sql.sql 2KB
- 2. SQL theory/5. SQL keywords.srt 2KB
- 12. SQL DELETE Statement/2. The DELETE Statement - Part II.srt 2KB
- 18. Stored routines/19. User-defined functions in MySQL - solution.html 2KB
- 19. Advanced SQL Topics/21. The CASE Statement - solution 2.html 2KB
- 14. SQL Joins/37. UNION vs UNION ALL - solution.html 2KB
- 18. Stored routines/12. Stored procedures with an output parameter - solution.html 2KB
- 14. SQL Joins/4. Intro to JOINs - exercise 2.html 2KB
- 14. SQL Joins/3. Intro to JOINs - solution 1.html 2KB
- 13. MySQL - Aggregate functions/7. MIN() and MAX().srt 2KB
- 6. MySQL constraints/3. PRIMARY KEY constraint - exercise.html 2KB
- 6. MySQL constraints/10. UNIQUE Constraint - exercise.html 1KB
- 10. SQL INSERT statement/3. The INSERT statement - exercise 1.html 1KB
- 21. Combining SQL and Tableau - Task 1/3. Important clarification!.html 1KB
- 11. SQL UPDATE Statement/3. ROLLBACK; ARTICLE.html 1KB
- 9. SQL SELECT statement/29. BETWEEN - AND- solution.html 1KB
- 19. Advanced SQL Topics/11. MySQL Triggers - solution.html 1KB
- 14. SQL Joins/18. The new and the old join syntax - solution.html 1KB
- 10. SQL INSERT statement/4. The INSERT statement - solution 1.html 1KB
- 5. First steps in SQL/2. SQL files.html 1KB
- 10. SQL INSERT statement/6. The INSERT statement - solution 2.html 1KB
- 15. SQL Subqueries/10. SQL Subqueries nested in SELECT and FROM - exercise 2.html 1KB
- 18. Stored routines/7. Stored procedures - Example - Part II - solution.html 1KB
- 26. Practice SQL – 10 Final Query Questions/1. Practice SQL – 10 Final Query Questions.html 1KB
- 4. Installing MySQL and getting acquainted with the interface/6. Read me!!!.html 1KB
- 9. SQL SELECT statement/23. LIKE - NOT LIKE - solution.html 997B
- 9. SQL SELECT statement/50. HAVING - exercise.html 987B
- 14. SQL Joins/2. Intro to JOINs - exercise 1.html 974B
- 8. Loading the 'employees' database/2. Loading the 'employees' database.html 955B
- 15. SQL Subqueries/6. SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - solution.html 900B
- 4. Installing MySQL and getting acquainted with the interface/2. Additional note – Installing – Visual C.html 835B
- 22. Combining SQL and Tableau - Task 2/4. Task 2 SQL Solution - Code.html 787B
- 15. SQL Subqueries/3. SQL Subqueries with IN nested inside WHERE - solution.html 785B
- 19. Advanced SQL Topics/23. The CASE Statement - solution 3.html 744B
- 19. Advanced SQL Topics/19. The CASE Statement - solution 1.html 737B
- 14. SQL Joins/22. JOIN and WHERE Used Together - solution.html 722B
- 9. SQL SELECT statement/35. Other comparison operators - solution.html 702B
- 24. Combining SQL and Tableau - Task 4/4. Task 4 Solution in SQL - Code.html 697B
- 9. SQL SELECT statement/51. HAVING - solution.html 697B
- 19. Advanced SQL Topics/16. MySQL Indexes - solution 2.html 683B
- 14. SQL Joins/14. LEFT JOIN - Part II - solution.html 657B
- 5. First steps in SQL/20. Creating a table - solution.html 657B
- 14. SQL Joins/8. INNER JOIN - Part II - solution.html 621B
- 20. Combining SQL and Tableau - Introduction/5. Loading the 'employees_mod' Database.html 613B
- 9. SQL SELECT statement/26. Wildcard characters - solution.html 583B
- 13. MySQL - Aggregate functions/22. Another example of using COALESCE() - solution 2.html 570B
- 14. SQL Joins/27. CROSS JOIN - solution 2.html 566B
- 17. SQL Views/3. Views - solution.html 566B
- 19. Advanced SQL Topics/9. MySQL Triggers.html 537B
- 21. Combining SQL and Tableau - Task 1/5. Task 1 SQL Solution - Code.html 537B
- 23. Combining SQL and Tableau - Task 3/4. Task 3 SQL Solution - Code.html 502B
- 6. MySQL constraints/13. DEFAULT Constraint - solution.html 488B
- 9. SQL SELECT statement/41. Introduction to aggregate functions - solution.html 486B
- 13. MySQL - Aggregate functions/9. MIN() and MAX() - solution.html 471B
- 6. MySQL constraints/12. DEFAULT Constraint - exercise.html 471B
- 14. SQL Joins/13. LEFT JOIN - Part II - exercise.html 455B
- 9. SQL SELECT statement/22. LIKE - NOT LIKE - exercise.html 439B
- 9. SQL SELECT statement/55. WHERE vs HAVING - Part II - solution.html 436B
- 18. Stored routines/18. User-defined functions in MySQL - exercise.html 434B
- 9. SQL SELECT statement/48. Using Aliases (AS) - solution.html 418B
- 19. Advanced SQL Topics/22. The CASE Statement - exercise 3.html 411B
- 9. SQL SELECT statement/3. SELECT - FROM - solution.html 411B
- 14. SQL Joins/34. Tips and tricks for joins - solution.html 408B
- 14. SQL Joins/25. CROSS JOIN - solution 1.html 407B
- 9. SQL SELECT statement/9. AND - solution.html 385B
- 13. MySQL - Aggregate functions/20. Another example of using COALESCE() - solution 1.html 383B
- 19. Advanced SQL Topics/20. The CASE Statement - exercise 2.html 376B
- 10. SQL INSERT statement/5. The INSERT statement - exercise 2.html 372B
- 15. SQL Subqueries/9. SQL Subqueries nested in SELECT and FROM - solution 1.html 366B
- 5. First steps in SQL/19. Creating a table - exercise.html 366B
- 19. Advanced SQL Topics/18. The CASE Statement - exercise 1.html 362B
- 9. SQL SELECT statement/37. SELECT DISTINCT - exercise.html 350B
- 9. SQL SELECT statement/47. Using Aliases (AS) - exercise.html 348B
- 9. SQL SELECT statement/28. BETWEEN - AND - exercise.html 339B
- 6. MySQL constraints/16. NOT NULL Constraint - Part I - solution.html 335B
- 24. Combining SQL and Tableau - Task 4/2. Task 4 - Text.html 325B
- 13. MySQL - Aggregate functions/21. Another example of using COALESCE() - exercise 2.html 320B
- 9. SQL SELECT statement/15. Operator precedence - solution.html 319B
- 13. MySQL - Aggregate functions/12. AVG() - solution.html 307B
- 9. SQL SELECT statement/12. OR - solution.html 306B
- 18. Stored routines/14. Variables - exercise.html 305B
- 13. MySQL - Aggregate functions/15. ROUND() - solution.html 301B
- 9. SQL SELECT statement/20. IN - NOT IN - solution 2.html 299B
- 9. SQL SELECT statement/18. IN - NOT IN - solution 1.html 296B
- 13. MySQL - Aggregate functions/6. SUM() - solution.html 291B
- 17. SQL Views/2. Views - exercise.html 288B
- 9. SQL SELECT statement/32. IS NOT NULL - IS NULL - solution.html 284B
- 9. SQL SELECT statement/6. WHERE - solution.html 283B
- 5. First steps in SQL/26. Additional notes on using tables - exercise.html 275B
- 9. SQL SELECT statement/34. Other comparison operators - exercise.html 273B
- 9. SQL SELECT statement/40. Introduction to aggregate functions - exercise.html 264B
- 5. First steps in SQL/22. Using databases and tables - exercise.html 263B
- 11. SQL UPDATE Statement/6. The UPDATE Statement – Part II - solution.html 257B
- 19. Advanced SQL Topics/15. MySQL Indexes - exercise 2.html 255B
- 13. MySQL - Aggregate functions/19. Another example of using COALESCE() - exercise 1.html 238B
- 9. SQL SELECT statement/38. SELECT DISTINCT - solution.html 234B
- 9. SQL SELECT statement/44. ORDER BY - solution.html 230B
- 9. SQL SELECT statement/25. Wildcard characters - exercise.html 221B
- 15. SQL Subqueries/8. SQL Subqueries nested in SELECT and FROM - exercise 1.html 215B
- 9. SQL SELECT statement/58. LIMIT - solution.html 214B
- 6. MySQL constraints/7. FOREIGN KEY constraint - Part II - exercise.html 212B
- 9. SQL SELECT statement/54. WHERE vs HAVING - Part II - exercise.html 211B
- 13. MySQL - Aggregate functions/3. COUNT() - solution.html 196B
- 14. SQL Joins/17. The new and the old join syntax - exercise.html 192B
- 6. MySQL constraints/8. FOREIGN KEY constraint - Part II - solution.html 192B
- 19. Advanced SQL Topics/10. MySQL Triggers - exercise.html 191B
- 15. SQL Subqueries/5. SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - exercise.html 185B
- 10. SQL INSERT statement/8. Inserting Data INTO a New Table - exercise.html 181B
- 14. SQL Joins/36. UNION vs UNION ALL - exercise.html 179B
- 11. SQL UPDATE Statement/5. The UPDATE Statement – Part II - exercise.html 172B
- 9. SQL SELECT statement/2. SELECT - FROM - exercise.html 170B
- 14. SQL Joins/21. JOIN and WHERE Used Together - exercise.html 169B
- 23. Combining SQL and Tableau - Task 3/2. Task 3 - Text.html 167B
- 6. MySQL constraints/15. NOT NULL Constraint - Part I - exercise.html 167B
- 12. SQL DELETE Statement/6. DROP vs TRUNCATE vs DELETE.html 165B
- 13. MySQL - Aggregate functions/23. Another example of using COALESCE().html 165B
- 16. SQL Self Join/2. Self join.html 165B
- 18. Stored routines/21. Stored routines - conclusion.html 165B
- 19. Advanced SQL Topics/2. Types of MySQL Variables - Local Variables.html 165B
- 19. Advanced SQL Topics/4. Session Variables.html 165B
- 19. Advanced SQL Topics/6. Global Variables.html 165B
- 19. Advanced SQL Topics/8. User-Defined vs System Variables.html 165B
- 5. First steps in SQL/25. Additional notes on using tables.html 165B
- 1. Introduction to databases, SQL, and MySQL/3. Why SQL.html 164B
- 1. Introduction to databases, SQL, and MySQL/5. Why MySQL.html 164B
- 1. Introduction to databases, SQL, and MySQL/7. Introduction to databases.html 164B
- 2. SQL theory/10. Data control language (DCL).html 164B
- 2. SQL theory/12. Transaction control language (TCL).html 164B
- 2. SQL theory/2. SQL as a declarative language.html 164B
- 2. SQL theory/4. Data definition language (DDL).html 164B
- 2. SQL theory/6. SQL keywords.html 164B
- 2. SQL theory/8. Data manipulation language (DML).html 164B
- 3. Basic database terminology/10. Relational schemas - Foreign key.html 164B
- 3. Basic database terminology/12. Relational Schemas - Unique key.html 164B
- 3. Basic database terminology/14. Relational Schemas – Relationships.html 164B
- 3. Basic database terminology/2. Relational database essentials.html 164B
- 3. Basic database terminology/4. Databases vs spreadsheets.html 164B
- 3. Basic database terminology/6. Database terminology.html 164B
- 3. Basic database terminology/8. Relational schemas - Primary key.html 164B
- 5. First steps in SQL/11. String data types.html 164B
- 5. First steps in SQL/13. Integers.html 164B
- 5. First steps in SQL/15. Fixed and floating-point data types.html 164B
- 5. First steps in SQL/17. Other useful data types.html 164B
- 5. First steps in SQL/9. Introduction to data types.html 164B
- 6. MySQL constraints/2. PRIMARY KEY Constraint.html 164B
- 7. SQL best practices/2. Coding techniques and best practices – Part I.html 164B
- 7. SQL best practices/4. Coding techniques and best practices – Part II.html 164B
- 14. SQL Joins/26. CROSS JOIN - exercise 2.html 162B
- 15. SQL Subqueries/2. SQL Subqueries with IN nested inside WHERE - exercise.html 162B
- 18. Stored routines/15. Variables - solution.html 162B
- 19. Advanced SQL Topics/14. MySQL Indexes - solution 1.html 159B
- 13. MySQL - Aggregate functions/14. ROUND() - exercise.html 155B
- 18. Stored routines/11. Stored procedures with an output parameter - exercise.html 152B
- 5. First steps in SQL/3. Creating a Database - Part I - exercise.html 152B
- 14. SQL Joins/24. CROSS JOIN - exercise 1.html 150B
- 21. Combining SQL and Tableau - Task 1/2. Task 1 - Text.html 149B
- 12. SQL DELETE Statement/4. The DELETE Statement – Part II - solution.html 148B
- 14. SQL Joins/7. INNER JOIN - Part II - exercise.html 144B
- 9. SQL SELECT statement/17. IN - NOT IN - exercise 1.html 140B
- 22. Combining SQL and Tableau - Task 2/2. Task 2 - Text.html 137B
- 2. SQL theory/1.1 Course Notes SQL - MySQL for Data Analytics and Business Intelligence.html 134B
- 13. MySQL - Aggregate functions/8. MIN() and MAX() - exercise.html 130B
- 13. MySQL - Aggregate functions/5. SUM() - exercise.html 127B
- 20. Combining SQL and Tableau - Introduction/4.2 The 'employees_mod' Database.html 125B
- 20. Combining SQL and Tableau - Introduction/5.1 The 'employees_mod' database.html 125B
- 13. MySQL - Aggregate functions/2. COUNT() - exercise.html 123B
- 5. First steps in SQL/4. Creating a Database - Part I - solution.html 122B
- 8. Loading the 'employees' database/2.1 The 'employees' database.html 121B
- 9. SQL SELECT statement/19. IN - NOT IN - exercise 2.html 118B
- 18. Stored routines/6. Stored procedures - Example - Part II - exercise.html 116B
- 13. MySQL - Aggregate functions/11. AVG() - exercise.html 112B
- 14. SQL Joins/30. Join more than two tables in SQL - exercise.html 109B
- 9. SQL SELECT statement/43. ORDER BY - exercise.html 106B
- 14. SQL Joins/33. Tips and tricks for joins - exercise.html 93B
- 9. SQL SELECT statement/5. WHERE - exercise.html 93B
- 9. SQL SELECT statement/14. Operator precedence - exercise.html 92B
- 10. SQL INSERT statement/9. Inserting Data INTO a New Table - solution.html 85B
- 9. SQL SELECT statement/11. OR - exercise.html 85B
- 9. SQL SELECT statement/31. IS NOT NULL - IS NULL - exercise.html 85B
- 9. SQL SELECT statement/8. AND - exercise.html 82B
- 12. SQL DELETE Statement/3. The DELETE Statement – Part II - exercise.html 79B
- 5. First steps in SQL/23. Using databases and tables - solution.html 78B
- 9. SQL SELECT statement/57. LIMIT - exercise.html 69B
- 5. First steps in SQL/6. Creating a Database - Part II - exercise.html 57B
- [FreeCourseWorld.Com].url 54B
- [DesireCourse.Net].url 51B
- [CourseClub.Me].url 48B
- 19. Advanced SQL Topics/13. MySQL Indexes - exercise 1.html 40B
- 5. First steps in SQL/7. Creating a Database - Part II - solution.html 34B
- 4. Installing MySQL and getting acquainted with the interface/4. The Client-Server Model.html 30B
- 13. MySQL - Aggregate functions/16. COALESCE() - Preamble.html 28B
- 15. SQL Subqueries/11. SQL Subqueries nested in SELECT and FROM - solution 2.html 15B