FreeCourseSite com Udemy - SQL - MySQL for Data Analytics and Business Intelligence

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