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

1. 01 Introduction to databases SQL and MySQL/001 What does the course cover.mp424.25MB
2. 01 Introduction to databases SQL and MySQL/002 Why SQL.mp414.74MB
3. 01 Introduction to databases SQL and MySQL/003 Why MySQL.mp46.53MB
4. 01 Introduction to databases SQL and MySQL/004 Introduction to databases.mp419.6MB
5. 02 SQL theory/005 SQL as a declarative language.mp410.08MB
6. 02 SQL theory/006 Data definition language (DDL).mp48.69MB
7. 02 SQL theory/007 SQL keywords.mp42.47MB
8. 02 SQL theory/008 Data manipulation language (DML).mp49.99MB
9. 02 SQL theory/009 Data control language (DCL).mp48.06MB
10. 02 SQL theory/010 Transaction control language (TCL).mp46.86MB
11. 03 Basic database terminology/011 Relational database essentials.mp422.97MB
12. 03 Basic database terminology/012 Databases vs spreadsheets.mp4169.95MB
13. 03 Basic database terminology/013 Database terminology.mp418.96MB
14. 03 Basic database terminology/014 Relational schemas - Primary key.mp410.41MB
15. 03 Basic database terminology/015 Relational schemas - Foreign key.mp410.35MB
16. 03 Basic database terminology/016 Relational schemas - Unique key and null values.mp46.34MB
17. 03 Basic database terminology/017 Relationships.mp49.74MB
18. 04 Installing MySQL and getting acquainted with the interface/018 Installing MySQL.mp489.8MB
19. 04 Installing MySQL and getting acquainted with the interface/021 Setting up a connection.mp46.14MB
20. 04 Installing MySQL and getting acquainted with the interface/022 New Authentication Plugin - Creating a New User.mp447.71MB
21. 04 Installing MySQL and getting acquainted with the interface/023 Introduction to the MySQL interface.mp411.9MB
22. 05 First steps in SQL/024 Creating a Database - Part I.mp410.36MB
23. 05 First steps in SQL/028 Creating a Database - Part II.mp44.87MB
24. 05 First steps in SQL/031 Introduction to data types.mp43.09MB
25. 05 First steps in SQL/032 String data types.mp49.14MB
26. 05 First steps in SQL/033 Integers.mp48.83MB
27. 05 First steps in SQL/034 Fixed and floating-point data types.mp411.77MB
28. 05 First steps in SQL/035 Other useful data types.mp411.8MB
29. 05 First steps in SQL/036 Creating a table.mp410.66MB
30. 05 First steps in SQL/039 Using databases and tables.mp46.52MB
31. 05 First steps in SQL/042 Additional notes on using tables.mp45.07MB
32. 06 MySQL constraints/044 PRIMARY KEY constraint.mp411.98MB
33. 06 MySQL constraints/047 FOREIGN KEY constraint - Part I.mp411.06MB
34. 06 MySQL constraints/048 FOREIGN KEY constraint - Part II.mp414.54MB
35. 06 MySQL constraints/051 UNIQUE Constraint.mp411.75MB
36. 06 MySQL constraints/053 DEFAULT Constraint.mp413.12MB
37. 06 MySQL constraints/056 NOT NULL Constraint - Part I.mp414.91MB
38. 06 MySQL constraints/059 NOT NULL Constraint - Part II.mp43.68MB
39. 07 SQL best practices/060 Coding techniques and best practices - Part I.mp411.56MB
40. 07 SQL best practices/061 Coding techniques and best practices - Part II.mp49.27MB
41. 08 Loading the employees database/062 Loading the employees database.mp48.14MB
42. 09 SQL SELECT statement/064 SELECT - FROM.mp410.96MB
43. 09 SQL SELECT statement/067 WHERE.mp46.03MB
44. 09 SQL SELECT statement/070 AND.mp44.82MB
45. 09 SQL SELECT statement/073 OR.mp48.47MB
46. 09 SQL SELECT statement/076 Operator precedence.mp48.49MB
47. 09 SQL SELECT statement/079 IN - NOT IN.mp48.25MB
48. 09 SQL SELECT statement/084 LIKE - NOT LIKE.mp49.6MB
49. 09 SQL SELECT statement/087 Wildcard characters.mp43.34MB
50. 09 SQL SELECT statement/090 BETWEEN - AND.mp45.18MB
51. 09 SQL SELECT statement/093 IS NOT NULL - IS NULL.mp43.82MB
52. 09 SQL SELECT statement/096 Other comparison operators.mp411.05MB
53. 09 SQL SELECT statement/099 SELECT DISTINCT.mp44.58MB
54. 09 SQL SELECT statement/102 Introduction to aggregate functions.mp412.66MB
55. 09 SQL SELECT statement/105 ORDER BY.mp410.77MB
56. 09 SQL SELECT statement/108 GROUP BY.mp414.82MB
57. 09 SQL SELECT statement/109 Using Aliases (AS).mp45.26MB
58. 09 SQL SELECT statement/112 HAVING.mp48.92MB
59. 09 SQL SELECT statement/115 WHERE vs HAVING- Part I.mp49.99MB
60. 09 SQL SELECT statement/116 WHERE vs HAVING- Part II.mp46.74MB
61. 09 SQL SELECT statement/119 LIMIT.mp412.7MB
62. 10 SQL INSERT statement/122 The INSERT statement - Part I.mp414.42MB
63. 10 SQL INSERT statement/123 The INSERT statement - Part II.mp46.66MB
64. 10 SQL INSERT statement/128 Inserting data INTO a new table.mp49.62MB
65. 11 SQL UPDATE Statement/131 TCLs COMMIT and ROLLBACK.mp47.81MB
66. 11 SQL UPDATE Statement/132 The UPDATE Statement - Part I.mp47.91MB
67. 11 SQL UPDATE Statement/133 The UPDATE Statement - Part II.mp47.39MB
68. 12 SQL DELETE Statement/136 The DELETE Statement - Part I.mp410.31MB
69. 12 SQL DELETE Statement/137 The DELETE Statement - Part II.mp43.68MB
70. 12 SQL DELETE Statement/140 DROP vs TRUNCATE vs DELETE.mp47.48MB
71. 13 MySQL - Aggregate functions/141 COUNT().mp49.24MB
72. 13 MySQL - Aggregate functions/144 SUM().mp43.22MB
73. 13 MySQL - Aggregate functions/147 MIN() and MAX().mp42.96MB
74. 13 MySQL - Aggregate functions/150 AVG().mp44.16MB
75. 13 MySQL - Aggregate functions/153 ROUND().mp44.74MB
76. 13 MySQL - Aggregate functions/157 IFNULL() and COALESCE().mp415.75MB
77. 13 MySQL - Aggregate functions/158 Another Example of Using COALESCE().mp43.7MB
78. 14 SQL Joins/163 Introduction to JOINs.mp47.22MB
79. 14 SQL Joins/167 INNER JOIN - Part I.mp412.42MB
80. 14 SQL Joins/168 INNER JOIN - Part II.mp411.62MB
81. 14 SQL Joins/171 A Note on Using Joins.mp410.76MB
82. 14 SQL Joins/172 Duplicate Records.mp412.73MB
83. 14 SQL Joins/173 LEFT JOIN - Part I.mp414.02MB
84. 14 SQL Joins/174 LEFT JOIN - Part II.mp414.82MB
85. 14 SQL Joins/177 RIGHT JOIN.mp432.09MB
86. 14 SQL Joins/178 The new and the old join syntax.mp49.17MB
87. 14 SQL Joins/181 JOIN and WHERE Used Together.mp46.55MB
88. 14 SQL Joins/184 CROSS JOIN.mp489.99MB
89. 14 SQL Joins/189 Using Aggregate Functions with Joins.mp46.21MB
90. 14 SQL Joins/190 JOIN more than two tables in SQL.mp410.94MB
91. 14 SQL Joins/193 Tips and tricks for joins.mp450.91MB
92. 14 SQL Joins/196 UNION vs UNION ALL.mp48.54MB
93. 15 SQL Subqueries/199 SQL Subqueries with IN nested inside WHERE.mp46.71MB
94. 15 SQL Subqueries/202 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE.mp48.64MB
95. 15 SQL Subqueries/205 SQL Subqueries nested in SELECT and FROM.mp419.91MB
96. 16 SQL Self Join/210 Self Join.mp420.83MB
97. 17 SQL Views/211 Views.mp417.48MB
98. 18 Stored routines/214 Introduction to stored routines.mp47.23MB
99. 18 Stored routines/215 The MySQL syntax for stored procedures.mp45.96MB
100. 18 Stored routines/216 Stored procedures - Example - Part I.mp47.23MB
101. 18 Stored routines/217 Stored procedures - Example - Part II.mp411.17MB
102. 18 Stored routines/220 Another way to create a procedure.mp45.43MB
103. 18 Stored routines/221 Stored procedures with an input parameter.mp417.07MB
104. 18 Stored routines/222 Stored procedures with an output parameter.mp48.52MB
105. 18 Stored routines/225 Variables.mp415.97MB
106. 18 Stored routines/228 User-defined functions in MySQL.mp48.03MB
107. 18 Stored routines/231 Stored routines - conclusion.mp48.18MB
108. 19 Advanced SQL Topics/232 Types of MySQL Variables - Local Variables.mp411.57MB
109. 19 Advanced SQL Topics/233 Session Variables.mp411.96MB
110. 19 Advanced SQL Topics/234 Global Variables.mp45.01MB
111. 19 Advanced SQL Topics/235 User-Defined vs System Variables.mp410.96MB
112. 19 Advanced SQL Topics/239 MySQL Indexes.mp418.21MB
113. 19 Advanced SQL Topics/244 The CASE Statement.mp459.41MB
114. 20 Combining SQL and Tableau - Introduction/251 The Advantages of Software Integration.mp492.4MB
115. 20 Combining SQL and Tableau - Introduction/252 Why Combining SQL and Tableau is useful.mp485.35MB
116. 20 Combining SQL and Tableau - Introduction/253 Installing Tableau Public.mp427.35MB
117. 20 Combining SQL and Tableau - Introduction/254 Loading the employees_mod Database.mp428.53MB
118. 21 Combining SQL and Tableau - Task 1/256 Task 1.mp433.52MB
119. 21 Combining SQL and Tableau - Task 1/258 Task 1 SQL Solution.mp443.16MB
120. 21 Combining SQL and Tableau - Task 1/260 Transferring a Dataset from SQL to Tableau.mp431.42MB
121. 21 Combining SQL and Tableau - Task 1/261 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I.mp440.54MB
122. 21 Combining SQL and Tableau - Task 1/262 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II.mp445.1MB
123. 22 Combining SQL and Tableau - Task 2/263 Task 2.mp428.84MB
124. 22 Combining SQL and Tableau - Task 2/265 Task 2 SQL Solution.mp439.28MB
125. 22 Combining SQL and Tableau - Task 2/267 Chart 2 Visualizing and Analyzing the Solution in Tableau.mp448.93MB
126. 23 Combining SQL and Tableau - Task 3/268 Task 3.mp413.07MB
127. 23 Combining SQL and Tableau - Task 3/270 Task 3 SQL Solution.mp433.12MB
128. 23 Combining SQL and Tableau - Task 3/272 Chart 3 Visualizing and Analyzing the Solution in Tableau.mp440.32MB
129. 24 Combining SQL and Tableau - Task 4/273 Task 4.mp423.56MB
130. 24 Combining SQL and Tableau - Task 4/275 Task 4 Solution in SQL.mp430.25MB
131. 24 Combining SQL and Tableau - Task 4/277 Chart 4 Visualizing and Analyzing the Solution in Tableau.mp422.28MB
132. 25 Combining SQL and Tableau - Task 5/278 Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau.mp455.98MB