SQL - MySQL for Data Analytics and Business Intelligence
SQL - MySQL for Data Analytics and Business Intelligence

SQL that will get you hired – SQL for Business Analysis, Marketing, and Data Management

Created by 365 Careers
Language English

SQL - MySQL for Data Analytics and Business Intelligence

SQL - MySQL for Data Analytics and Business Intelligence
SQL - MySQL for Data Analytics and Business Intelligence

SQL that will get you hired – SQL for Business Analysis, Marketing, and Data Management

Created by 365 Careers
Language English
1. Introduction to databases SQL and MySQL
  • 1. What does the course cover 00:04:14
  • 2. Why SQL 00:03:17
  • 2.1 SQL - FAQ .pdf
  • 3. Why SQL .html
  • 4. Why MySQL 00:01:57
  • 5. Why MySQL .html
  • 6. Introduction to databases 00:04:44
  • 7. Introduction to databases .html
2. SQL theory
  • 1. SQL as a declarative language 00:02:11
  • 1.1 Course Notes SQL - MySQL for Data Analytics and Business Intelligence .html
  • 2. SQL as a declarative language .html
  • 3. Data definition language DDL 00:04:13
  • 3.1 DDL .pdf
  • 4. Data definition language DDL .html
  • 5. SQL keywords 00:01:12
  • 5.1 SQL Keywords .pdf
  • 6. SQL keywords .html
  • 7. Data manipulation language DML 00:04:55
  • 7.1 DML .pdf
  • 8. Data manipulation language DML .html
  • 9. Data control language DCL 00:05:03
  • 9.1 DCL .pdf
  • 10. Data control language DCL .html
  • 11. Transaction control language TCL 00:03:02
  • 11.1 TCL .pdf
  • 12. Transaction control language TCL .html
3. Basic database terminology
  • 1. Relational database essentials 00:04:51
  • 2. Relational database essentials .html
  • 3. Databases vs spreadsheets 00:08:06
  • 4. Databases vs spreadsheets .html
  • 5. Database terminology 00:04:17
  • 6. Database terminology .html
  • 7. Relational schemas - Primary key 00:04:55
  • 7.1 Relational Schemas - Primary Key .pdf
  • 8. Relational schemas - Primary key .html
  • 9. Relational schemas - Foreign key 00:04:59
  • 9.1 Relational Schemas - Foreign Key .pdf
  • 10. Relational schemas - Foreign key .html
  • 11. Relational schemas - Unique key and null values 00:03:07
  • 11.1 Relational Schemas - Unique Key and Null Values .pdf
  • 12. Relational Schemas - Unique key .html
  • 13. Relationships 00:04:39
  • 13.1 Relationships .pdf
  • 14. Relational Schemas Relationships .html
4. Installing MySQL and getting acquainted with the interface
  • 1. Installing MySQL 00:10:48
  • 2. Additional note Installing Visual C .html
  • 3. Installing MySQL on macOS and Unix systems .html
  • 4. The Client-Server Model .html
  • 4.1 The Client-Server Model .pdf
  • 5. Setting up a connection 00:02:34
  • 6. Read me .html
  • 7. New Authentication Plugin - Creating a New User 00:06:18
  • 8. Introduction to the MySQL interface 00:05:09
5. First steps in SQL
  • 1. Creating a Database - Part I 00:05:12
  • 1.1 Creating a Database - Part I .pdf
  • 2. SQL files .html
  • 2.1 MySQL for Data Analytics and BI - Lecture Code .sql
  • 2.2 MySQL for Data Analytics and BI - Lecture Code and Tasks Solutions .sql
  • 2.3 SQL - FAQ .pdf
  • 3. Creating a Database - Part I - exercise .html
  • 4. Creating a Database - Part I - solution .html
  • 5. Creating a Database - Part II 00:02:22
  • 6. Creating a Database - Part II - exercise .html
  • 7. Creating a Database - Part II - solution .html
  • 8. Introduction to data types 00:02:16
  • 8.1 Introduction to Data Types .pdf
  • 9. Introduction to data types .html
  • 10. String data types 00:05:01
  • 10.1 String Data Types .pdf
  • 11. String data types .html
  • 12. Integers 00:04:10
  • 12.1 Integers .pdf
  • 13. Integers .html
  • 14. Fixed and floating-point data types 00:05:44
  • 14.1 Fixed- and Floating-Point Data Types .pdf
  • 15. Fixed and floating-point data types .html
  • 16. Other useful data types 00:06:12
  • 16.1 Other Useful Data Types .pdf
  • 17. Other useful data types .html
  • 18. Creating a table 00:05:17
  • 18.1 Creating a Table .pdf
  • 19. Creating a table - exercise .html
  • 20. Creating a table - solution .html
  • 21. Using databases and tables 00:03:03
  • 21.1 Using Databases and Tables .pdf
  • 22. Using databases and tables - exercise .html
  • 23. Using databases and tables - solution .html
  • 24. Additional notes on using tables 00:02:12
  • 24.1 Additional Notes on Using Tables .pdf
  • 25. Additional notes on using tables .html
  • 26. Additional notes on using tables - exercise .html
6. MySQL constraints
  • 1. PRIMARY KEY constraint 00:05:23
  • 1.1 PRIMARY KEY Constraint .pdf
  • 1.2 sales db .pdf
  • 2. PRIMARY KEY Constraint .html
  • 3. PRIMARY KEY constraint - exercise .html
  • 4. PRIMARY KEY constraint - solution .html
  • 5. FOREIGN KEY constraint - Part I 00:05:25
  • 5.1 FOREIGN KEY Constraint .pdf
  • 6. FOREIGN KEY constraint - Part II 00:05:26
  • 7. FOREIGN KEY constraint - Part II - exercise .html
  • 8. FOREIGN KEY constraint - Part II - solution .html
  • 9. UNIQUE Constraint 00:05:00
  • 9.1 UNIQUE Constraint .pdf
  • 10. UNIQUE Constraint - exercise .html
  • 11. DEFAULT Constraint 00:05:24
  • 11.1 DEFAULT Constraint .pdf
  • 12. DEFAULT Constraint - exercise .html
  • 13. DEFAULT Constraint - solution .html
  • 14. NOT NULL Constraint - Part I 00:05:53
  • 14.1 NOT NULL Constraint .pdf
  • 15. NOT NULL Constraint - Part I - exercise .html
  • 16. NOT NULL Constraint - Part I - solution .html
  • 17. NOT NULL Constraint - Part II 00:01:59
7. SQL best practices
  • 1. Coding techniques and best practices - Part I 00:05:34
  • 1.1 MySQL Workbench Shortcuts .pdf
  • 1.2 Coding Techniques and Best Practices .pdf
  • 2. Coding techniques and best practices Part I .html
  • 3. Coding techniques and best practices - Part II 00:04:11
  • 4. Coding techniques and best practices Part II .html
8. Loading the employees database
  • 1. Loading the employees database 00:02:19
  • 2. Loading the employees database .html
  • 2.1 The employees database .html
9. SQL SELECT statement
  • 1. SELECT - FROM 00:04:57
  • 1.1 SELECT - FROM .pdf
  • 1.2 employees db .pdf
  • 2. SELECT - FROM - exercise .html
  • 3. SELECT - FROM - solution .html
  • 4. WHERE 00:02:30
  • 4.1 WHERE .pdf
  • 5. WHERE - exercise .html
  • 6. WHERE - solution .html
  • 7. AND 00:02:14
  • 7.1 AND .pdf
  • 8. AND - exercise .html
  • 9. AND - solution .html
  • 10. OR 00:03:36
  • 10.1 OR .pdf
  • 11. OR - exercise .html
  • 12. OR - solution .html
  • 13. Operator precedence 00:03:34
  • 13.1 Operator Precedence .pdf
  • 14. Operator precedence - exercise .html
  • 15. Operator precedence - solution .html
  • 16. IN - NOT IN 00:03:12
  • 17. IN - NOT IN - exercise 1 .html
  • 18. IN - NOT IN - solution 1 .html
  • 19. IN - NOT IN - exercise 2 .html
  • 20. IN - NOT IN - solution 2 .html
  • 21. LIKE - NOT LIKE 00:03:36
  • 22. LIKE - NOT LIKE - exercise .html
  • 23. LIKE - NOT LIKE - solution .html
  • 24. Wildcard characters 00:01:45
  • 24.1 Wildcard Characters .pdf
  • 25. Wildcard characters - exercise .html
  • 26. Wildcard characters - solution .html
  • 27. BETWEEN - AND 00:02:20
  • 27.1 BETWEEN - AND .pdf
  • 28. BETWEEN - AND - exercise .html
  • 29. BETWEEN - AND- solution .html
  • 30. IS NOT NULL - IS NULL 00:01:37
  • 30.1 IS NOT NULL - IS NULL .pdf
  • 31. IS NOT NULL - IS NULL - exercise .html
  • 32. IS NOT NULL - IS NULL - solution .html
  • 33. Other comparison operators 00:04:30
  • 33.1 Other Comparison Operators .pdf
  • 34. Other comparison operators - exercise .html
  • 35. Other comparison operators - solution .html
  • 36. SELECT DISTINCT 00:02:06
  • 36.1 SELECT DISTINCT .pdf
  • 37. SELECT DISTINCT - exercise .html
  • 38. SELECT DISTINCT - solution .html
  • 39. Introduction to aggregate functions 00:05:24
  • 39.1 Introduction to Aggregate Functions .pdf
  • 40. Introduction to aggregate functions - exercise .html
  • 41. Introduction to aggregate functions - solution .html
  • 42. ORDER BY 00:03:46
  • 43. ORDER BY - exercise .html
  • 44. ORDER BY - solution .html
  • 45. GROUP BY 00:06:00
  • 45.1 GROUP BY .pdf
  • 46. Using Aliases AS 00:02:08
  • 47. Using Aliases AS - exercise .html
  • 48. Using Aliases AS - solution .html
  • 49. HAVING 00:03:26
  • 49.1 HAVING .pdf
  • 50. HAVING - exercise .html
  • 51. HAVING - solution .html
  • 52. WHERE vs HAVING- Part I 00:04:04
  • 52.1 WHERE vs HAVING .pdf
  • 53. WHERE vs HAVING- Part II 00:03:08
  • 54. WHERE vs HAVING - Part II - exercise .html
  • 55. WHERE vs HAVING - Part II - solution .html
  • 56. LIMIT 00:04:52
  • 56.1 LIMIT .pdf
  • 57. LIMIT - exercise .html
  • 58. LIMIT - solution .html
10. SQL INSERT statement
  • 1. The INSERT statement - Part I 00:06:05
  • 1.1 The INSERT Statement .pdf
  • 2. The INSERT statement - Part II 00:02:19
  • 3. The INSERT statement - exercise 1 .html
  • 4. The INSERT statement - solution 1 .html
  • 5. The INSERT statement - exercise 2 .html
  • 6. The INSERT statement - solution 2 .html
  • 7. Inserting data INTO a new table 00:03:56
  • 7.1 Inserting Data INTO a New Table .pdf
  • 8. Inserting Data INTO a New Table - exercise .html
  • 9. Inserting Data INTO a New Table - solution .html
11. SQL UPDATE Statement
  • 1. TCLs COMMIT and ROLLBACK 00:02:42
  • 1.1 TCLs COMMIT and ROLLBACK .pdf
  • 2. The UPDATE Statement - Part I 00:03:18
  • 2.1 The UPDATE Statement .pdf
  • 3. ROLLBACK ARTICLE .html
  • 4. The UPDATE Statement - Part II 00:02:55
  • 5. The UPDATE Statement Part II - exercise .html
  • 6. The UPDATE Statement Part II - solution .html
12. SQL DELETE Statement
  • 1. The DELETE Statement - Part I 00:04:14
  • 1.1 The DELETE Statement .pdf
  • 2. The DELETE Statement - Part II 00:01:30
  • 3. The DELETE Statement Part II - exercise .html
  • 4. The DELETE Statement Part II - solution .html
  • 5. DROP vs TRUNCATE vs DELETE 00:03:23
  • 5.1 DROP vs TRUNCATE vs DELETE .pdf
  • 6. DROP vs TRUNCATE vs DELETE .html
13. MySQL - Aggregate functions
  • 1. COUNT 00:04:14
  • 1.1 COUNT .pdf
  • 2. COUNT - exercise .html
  • 3. COUNT - solution .html
  • 4. SUM 00:01:31
  • 4.1 SUM .pdf
  • 5. SUM - exercise .html
  • 6. SUM - solution .html
  • 7. MIN and MAX 00:01:15
  • 7.1 MIN and MAX .pdf
  • 8. MIN and MAX - exercise .html
  • 9. MIN and MAX - solution .html
  • 10. AVG 00:01:58
  • 10.1 AVG .pdf
  • 11. AVG - exercise .html
  • 12. AVG - solution .html
  • 13. ROUND 00:02:06
  • 13.1 ROUND .pdf
  • 14. ROUND - exercise .html
  • 15. ROUND - solution .html
  • 16. COALESCE - Preamble .html
  • 16.1 COALESCE - Preamble .pdf
  • 17. IFNULL and COALESCE 00:06:25
  • 17.1 IFNULL and COALESCE .pdf
  • 18. Another Example of Using COALESCE 00:01:36
  • 19. Another example of using COALESCE - exercise 1 .html
  • 20. Another example of using COALESCE - solution 1 .html
  • 21. Another example of using COALESCE - exercise 2 .html
  • 22. Another example of using COALESCE - solution 2 .html
  • 23. Another example of using COALESCE .html
14. SQL Joins
  • 1. Introduction to JOINs 00:04:23
  • 1.1 Introduction to Joins .pdf
  • 2. Intro to JOINs - exercise 1 .html
  • 3. Intro to JOINs - solution 1 .html
  • 4. Intro to JOINs - exercise 2 .html
  • 5. INNER JOIN - Part I 00:06:03
  • 5.1 INNER JOIN .pdf
  • 6. INNER JOIN - Part II 00:05:33
  • 7. INNER JOIN - Part II - exercise .html
  • 8. INNER JOIN - Part II - solution .html
  • 9. A Note on Using Joins 00:04:09
  • 10. Duplicate Records 00:04:21
  • 10.1 Duplicate Records .pdf
  • 11. LEFT JOIN - Part I 00:04:31
  • 11.1 LEFT JOIN .pdf
  • 12. LEFT JOIN - Part II 00:05:46
  • 13. LEFT JOIN - Part II - exercise .html
  • 14. LEFT JOIN - Part II - solution .html
  • 15. RIGHT JOIN 00:04:30
  • 15.1 RIGHT JOIN .pdf
  • 16. The new and the old join syntax 00:04:17
  • 16.1 The New and the Old Join Syntax .pdf
  • 17. The new and the old join syntax - exercise .html
  • 18. The new and the old join syntax - solution .html
  • 19. JOIN and WHERE Used Together 00:02:53
  • 19.1 JOIN and WHERE Used Together .pdf
  • 20. Important Prevent Error Code 1055 .html
  • 21. JOIN and WHERE Used Together - exercise .html
  • 22. JOIN and WHERE Used Together - solution .html
  • 23. CROSS JOIN 00:07:42
  • 23.1 CROSS JOIN .pdf
  • 24. CROSS JOIN - exercise 1 .html
  • 25. CROSS JOIN - solution 1 .html
  • 26. CROSS JOIN - exercise 2 .html
  • 27. CROSS JOIN - solution 2 .html
  • 28. Using Aggregate Functions with Joins 00:02:17
  • 29. JOIN more than two tables in SQL 00:04:27
  • 29.1 JOIN More Than Two Tables in SQL .pdf
  • 30. Join more than two tables in SQL - exercise .html
  • 31. Join more than two tables in SQL - solution .html
  • 32. Tips and tricks for joins 00:05:39
  • 32.1 Tips and Tricks for Joins .pdf
  • 33. Tips and tricks for joins - exercise .html
  • 34. Tips and tricks for joins - solution .html
  • 35. UNION vs UNION ALL 00:05:44
  • 35.1 UNION vs UNION ALL .pdf
  • 36. UNION vs UNION ALL - exercise .html
  • 37. UNION vs UNION ALL - solution .html
15. SQL Subqueries
  • 1. SQL Subqueries with IN nested inside WHERE 00:04:31
  • 1.1 Subqueries IN WHERE .pdf
  • 2. SQL Subqueries with IN nested inside WHERE - exercise .html
  • 3. SQL Subqueries with IN nested inside WHERE - solution .html
  • 4. SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE 00:03:42
  • 4.1 Subqueries EXISTS WHERE .pdf
  • 5. SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - exercise .html
  • 6. SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - solution .html
  • 7. SQL Subqueries nested in SELECT and FROM 00:07:57
  • 7.1 Subqueries SELECT FROM .pdf
  • 8. SQL Subqueries nested in SELECT and FROM - exercise 1 .html
  • 9. SQL Subqueries nested in SELECT and FROM - solution 1 .html
  • 10. SQL Subqueries nested in SELECT and FROM - exercise 2 .html
  • 11. SQL Subqueries nested in SELECT and FROM - solution 2 .html
  • 11.1 Subqueries SELECT FROM Solution .sql
16. SQL Self Join
  • 1. Self Join 00:07:45
  • 1.1 SQL Self Join .pdf
  • 2. Self join .html
17. SQL Views
  • 1. Views 00:07:12
  • 1.1 SQL Views .pdf
  • 2. Views - exercise .html
  • 3. Views - solution .html
18. Stored routines
  • 1. Introduction to stored routines 00:03:26
  • 1.1 Introduction to Stored Routines .pdf
  • 2. Introduction to Stored Routines .html
  • 3. The MySQL syntax for stored procedures 00:04:32
  • 3.1 The MySQL Syntax for Stored Procedures .pdf
  • 4. Stored procedures - Example - Part I 00:02:45
  • 5. Stored procedures - Example - Part II 00:04:49
  • 6. Stored procedures - Example - Part II - exercise .html
  • 7. Stored procedures - Example - Part II - solution .html
  • 8. Another way to create a procedure 00:03:19
  • 9. Stored procedures with an input parameter 00:06:29
  • 9.1 Stored Procedures with an Input Parameter .pdf
  • 10. Stored procedures with an output parameter 00:03:20
  • 10.1 Stored Procedures with an Output Parameter .pdf
  • 11. Stored procedures with an output parameter - exercise .html
  • 12. Stored procedures with an output parameter - solution .html
  • 13. Variables 00:06:50
  • 13.1 Variables .pdf
  • 14. Variables - exercise .html
  • 15. Variables - solution .html
  • 16. User-defined functions in MySQL 00:06:14
  • 16.1 User-Defined Functions in MySQL .pdf
  • 17. Error Code 1418. .html
  • 18. User-defined functions in MySQL - exercise .html
  • 19. User-defined functions in MySQL - solution .html
  • 20. Stored routines - conclusion 00:03:55
  • 20.1 Stored Routines - Conclusion .pdf
  • 21. Stored routines - conclusion .html
19. Advanced SQL Topics
  • 1. Types of MySQL Variables - Local Variables 00:04:56
  • 1.1 Types of MySQL Variables - Local Variables .pdf
  • 2. Types of MySQL Variables - Local Variables .html
  • 3. Session Variables 00:05:21
  • 3.1 Session Variables .pdf
  • 4. Session Variables .html
  • 5. Global Variables 00:02:18
  • 5.1 Global Variables .pdf
  • 6. Global Variables .html
  • 7. User-Defined vs System Variables 00:04:12
  • 7.1 User-Defined vs System Variables .pdf
  • 8. User-Defined vs System Variables .html
  • 9. MySQL Triggers .html
  • 9.1 MySQL Triggers .sql
  • 10. MySQL Triggers - exercise .html
  • 11. MySQL Triggers - solution .html
  • 12. MySQL Indexes 00:07:27
  • 12.1 MySQL Indexes .pdf
  • 13. MySQL Indexes - exercise 1 .html
  • 14. MySQL Indexes - solution 1 .html
  • 15. MySQL Indexes - exercise 2 .html
  • 16. MySQL Indexes - solution 2 .html
  • 17. The CASE Statement 00:05:57
  • 17.1 The CASE Statement .pdf
  • 18. The CASE Statement - exercise 1 .html
  • 19. The CASE Statement - solution 1 .html
  • 20. The CASE Statement - exercise 2 .html
  • 21. The CASE Statement - solution 2 .html
  • 22. The CASE Statement - exercise 3 .html
  • 23. The CASE Statement - solution 3 .html
20. Combining SQL and Tableau - Introduction
  • 1. The Advantages of Software Integration 00:05:20
  • 2. Why Combining SQL and Tableau is useful 00:04:54
  • 3. Installing Tableau Public 00:01:51
  • 4. Loading the employees mod Database 00:03:22
  • 4.1 employees mod db .pdf
  • 4.2 The employees mod Database .html
  • 5. Loading the employees mod Database .html
  • 5.1 The employees mod database .html
  • 5.2 employees mod db .pdf
21. Combining SQL and Tableau - Task 1
  • 1. Task 1 00:05:33
  • 2. Task 1 - Text .html
  • 3. Important clarification .html
  • 4. Task 1 SQL Solution 00:04:41
  • 5. Task 1 SQL Solution - Code .html
  • 6. Transferring a Dataset from SQL to Tableau 00:04:13
  • 7. Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I 00:06:17
  • 8. Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II 00:05:25
22. Combining SQL and Tableau - Task 2
  • 1. Task 2 00:03:50
  • 2. Task 2 - Text .html
  • 3. Task 2 SQL Solution 00:03:43
  • 4. Task 2 SQL Solution - Code .html
  • 5. Chart 2 Visualizing and Analyzing the Solution in Tableau 00:06:08
23. Combining SQL and Tableau - Task 3
  • 1. Task 3 00:02:21
  • 2. Task 3 - Text .html
  • 3. Task 3 SQL Solution 00:03:14
  • 4. Task 3 SQL Solution - Code .html
  • 5. Chart 3 Visualizing and Analyzing the Solution in Tableau 00:04:56
24. Combining SQL and Tableau - Task 4
  • 1. Task 4 00:02:45
  • 2. Task 4 - Text .html
  • 3. Task 4 Solution in SQL 00:02:47
  • 4. Task 4 Solution in SQL - Code .html
  • 5. Chart 4 Visualizing and Analyzing the Solution in Tableau 00:03:22
25. Combining SQL and Tableau - Task 5
  • 1. Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau 00:06:04
26. Practice SQL 10 Final Query Questions
  • 1. Practice SQL 10 Final Query Questions .html
  • 1.1 10-Practice-Final-Query-Questions - SOLUTIONS .sql
  • 1.2 10-Practice-SQL-Final-Query-Questions .pdf
27. BONUS LECTURE
  • 1. Bonus Lecture Next Steps .html