GigaCourse Com Udemy - SQL - MySQL for Data Analytics and Business Intelligence

1. 01 - Introduction to databases, SQL, and MySQL/001 What does the course cover.mp473.65MB
2. 01 - Introduction to databases, SQL, and MySQL/002 Why SQL.mp458.06MB
3. 01 - Introduction to databases, SQL, and MySQL/003 Why MySQL.mp423.71MB
4. 01 - Introduction to databases, SQL, and MySQL/004 Introduction to databases.mp483.52MB
5. 02 - SQL theory/001 SQL as a declarative language.mp47.08MB
6. 02 - SQL theory/002 Data definition language (DDL).mp49.09MB
7. 02 - SQL theory/003 SQL keywords.mp42.46MB
8. 02 - SQL theory/004 Data manipulation language (DML).mp410.7MB
9. 02 - SQL theory/005 Data control language (DCL).mp413.55MB
10. 02 - SQL theory/006 Transaction control language (TCL).mp49.12MB
11. 03 - Basic database terminology/001 Relational database essentials.mp491.73MB
12. 03 - Basic database terminology/002 Databases vs spreadsheets.mp4141.25MB
13. 03 - Basic database terminology/003 Database terminology.mp413.34MB
14. 03 - Basic database terminology/004 Relational schemas - Primary key.mp414.38MB
15. 03 - Basic database terminology/005 Relational schemas - Foreign key.mp411.85MB
16. 03 - Basic database terminology/006 Relational schemas - Unique key and null values.mp47MB
17. 03 - Basic database terminology/007 Relationships.mp413.22MB
18. 04 - Installing MySQL and getting acquainted with the interface/001 Installing MySQL.mp460.22MB
19. 04 - Installing MySQL and getting acquainted with the interface/005 Setting up a connection.mp46.43MB
20. 04 - Installing MySQL and getting acquainted with the interface/007 New Authentication Plugin - Creating a New User.mp419.07MB
21. 04 - Installing MySQL and getting acquainted with the interface/008 Introduction to the MySQL interface.mp414.08MB
22. 05 - First steps in SQL/001 Creating a Database - Part I.mp420.27MB
23. 05 - First steps in SQL/005 Creating a Database - Part II.mp46.03MB
24. 05 - First steps in SQL/008 Introduction to data types.mp44.81MB
25. 05 - First steps in SQL/009 String data types.mp411.15MB
26. 05 - First steps in SQL/010 Integers.mp415.27MB
27. 05 - First steps in SQL/011 Fixed and floating-point data types.mp418.64MB
28. 05 - First steps in SQL/012 Other useful data types.mp413.96MB
29. 05 - First steps in SQL/013 Creating a table.mp416.35MB
30. 05 - First steps in SQL/016 Using databases and tables.mp49.15MB
31. 05 - First steps in SQL/019 Additional notes on using tables.mp47.23MB
32. 06 - MySQL constraints/001 PRIMARY KEY constraint.mp417.68MB
33. 06 - MySQL constraints/004 FOREIGN KEY constraint - Part I.mp417.74MB
34. 06 - MySQL constraints/005 FOREIGN KEY constraint - Part II.mp421.33MB
35. 06 - MySQL constraints/008 UNIQUE Constraint.mp413.49MB
36. 06 - MySQL constraints/010 DEFAULT Constraint.mp414.72MB
37. 06 - MySQL constraints/013 NOT NULL Constraint - Part I.mp434.63MB
38. 06 - MySQL constraints/016 NOT NULL Constraint - Part II.mp44.26MB
39. 07 - SQL best practices/001 Coding techniques and best practices - Part I.mp413.78MB
40. 07 - SQL best practices/002 Coding techniques and best practices - Part II.mp411.55MB
41. 08 - Loading the 'employees' database/001 Loading the 'employees' database.mp48.06MB
42. 09 - SQL SELECT statement/001 SELECT - FROM.mp415.15MB
43. 09 - SQL SELECT statement/004 WHERE.mp416.98MB
44. 09 - SQL SELECT statement/007 AND.mp45.67MB
45. 09 - SQL SELECT statement/010 OR.mp410.59MB
46. 09 - SQL SELECT statement/013 Operator precedence.mp410.22MB
47. 09 - SQL SELECT statement/016 IN - NOT IN.mp49.85MB
48. 09 - SQL SELECT statement/021 LIKE - NOT LIKE.mp410.89MB
49. 09 - SQL SELECT statement/024 Wildcard characters.mp43.72MB
50. 09 - SQL SELECT statement/027 BETWEEN - AND.mp45.48MB
51. 09 - SQL SELECT statement/030 IS NOT NULL - IS NULL.mp44.54MB
52. 09 - SQL SELECT statement/033 Other comparison operators.mp416.33MB
53. 09 - SQL SELECT statement/036 SELECT DISTINCT.mp47.65MB
54. 09 - SQL SELECT statement/039 Introduction to aggregate functions.mp414.59MB
55. 09 - SQL SELECT statement/042 ORDER BY.mp412.05MB
56. 09 - SQL SELECT statement/045 GROUP BY.mp424.3MB
57. 09 - SQL SELECT statement/046 Using Aliases (AS).mp46.76MB
58. 09 - SQL SELECT statement/049 HAVING.mp412.66MB
59. 09 - SQL SELECT statement/052 WHERE vs HAVING- Part I.mp427.24MB
60. 09 - SQL SELECT statement/053 WHERE vs HAVING- Part II.mp417.84MB
61. 09 - SQL SELECT statement/056 LIMIT.mp418.67MB
62. 10 - SQL INSERT statement/001 The INSERT statement - Part I.mp421.41MB
63. 10 - SQL INSERT statement/002 The INSERT statement - Part II.mp47.32MB
64. 10 - SQL INSERT statement/007 Inserting data INTO a new table.mp411.72MB
65. 11 - SQL UPDATE Statement/001 TCL's COMMIT and ROLLBACK.mp49.59MB
66. 11 - SQL UPDATE Statement/002 The UPDATE Statement - Part I.mp49.72MB
67. 11 - SQL UPDATE Statement/004 The UPDATE Statement - Part II.mp48.74MB
68. 12 - SQL DELETE Statement/001 The DELETE Statement - Part I.mp412.75MB
69. 12 - SQL DELETE Statement/002 The DELETE Statement - Part II.mp45.58MB
70. 12 - SQL DELETE Statement/005 DROP vs TRUNCATE vs DELETE.mp47.63MB
71. 13 - MySQL - Aggregate functions/001 COUNT().mp419.12MB
72. 13 - MySQL - Aggregate functions/004 SUM().mp43.81MB
73. 13 - MySQL - Aggregate functions/007 MIN() and MAX().mp43.52MB
74. 13 - MySQL - Aggregate functions/010 AVG().mp46.6MB
75. 13 - MySQL - Aggregate functions/013 ROUND().mp46.01MB
76. 13 - MySQL - Aggregate functions/017 IFNULL() and COALESCE().mp428.08MB
77. 13 - MySQL - Aggregate functions/018 Another Example of Using COALESCE().mp44.13MB
78. 14 - SQL Joins/001 Introduction to JOINs.mp421.64MB
79. 14 - SQL Joins/005 INNER JOIN - Part I.mp413.8MB
80. 14 - SQL Joins/006 INNER JOIN - Part II.mp426.2MB
81. 14 - SQL Joins/009 A Note on Using Joins.mp413.32MB
82. 14 - SQL Joins/010 Duplicate Records.mp416.78MB
83. 14 - SQL Joins/011 LEFT JOIN - Part I.mp420.44MB
84. 14 - SQL Joins/012 LEFT JOIN - Part II.mp420.78MB
85. 14 - SQL Joins/015 RIGHT JOIN.mp424.52MB
86. 14 - SQL Joins/016 The new and the old join syntax.mp414.49MB
87. 14 - SQL Joins/019 JOIN and WHERE Used Together.mp418.88MB
88. 14 - SQL Joins/023 CROSS JOIN.mp431.13MB
89. 14 - SQL Joins/028 Using Aggregate Functions with Joins.mp48.62MB
90. 14 - SQL Joins/029 JOIN more than two tables in SQL.mp412.65MB
91. 14 - SQL Joins/032 Tips and tricks for joins.mp436.77MB
92. 14 - SQL Joins/035 UNION vs UNION ALL.mp415.25MB
93. 15 - SQL Subqueries/001 SQL Subqueries with IN nested inside WHERE.mp412.18MB
94. 15 - SQL Subqueries/004 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE.mp49.76MB
95. 15 - SQL Subqueries/007 SQL Subqueries nested in SELECT and FROM.mp432.84MB
96. 16 - SQL Self Join/001 Self Join.mp447.25MB
97. 17 - SQL Views/001 Views.mp420.65MB
98. 18 - Stored routines/001 Introduction to stored routines.mp48.12MB
99. 18 - Stored routines/002 The MySQL syntax for stored procedures.mp425.16MB
100. 18 - Stored routines/003 Stored procedures - Example - Part I.mp47.68MB
101. 18 - Stored routines/004 Stored procedures - Example - Part II.mp414.41MB
102. 18 - Stored routines/007 Another way to create a procedure.mp410.13MB
103. 18 - Stored routines/008 Stored procedures with an input parameter.mp419.4MB
104. 18 - Stored routines/009 Stored procedures with an output parameter.mp412.54MB
105. 18 - Stored routines/012 Variables.mp422.46MB
106. 18 - Stored routines/015 User-defined functions in MySQL.mp443.93MB
107. 18 - Stored routines/019 Stored routines - conclusion.mp411.37MB
108. 19 - Advanced SQL Topics/001 Types of MySQL Variables - Local Variables.mp417.9MB
109. 19 - Advanced SQL Topics/002 Session Variables.mp416.13MB
110. 19 - Advanced SQL Topics/003 Global Variables.mp46.57MB
111. 19 - Advanced SQL Topics/004 User-Defined vs System Variables.mp430.4MB
112. 19 - Advanced SQL Topics/006 MySQL Triggers.mp443.46MB
113. 19 - Advanced SQL Topics/009 MySQL Indexes.mp426.42MB
114. 19 - Advanced SQL Topics/014 The CASE Statement.mp422.73MB
115. 20 - SQL Window Functions/001 Introduction to MySQL Window Functions.mp44.65MB
116. 20 - SQL Window Functions/002 The ROW_NUMBER() Ranking Window Function and the Relevant MySQL Syntax.mp459.47MB
117. 20 - SQL Window Functions/005 A Note on Using Several Window Functions in a Query.mp410.31MB
118. 20 - SQL Window Functions/008 MySQL Window Functions Syntax.mp412.88MB
119. 20 - SQL Window Functions/011 The PARTITION BY Clause VS the GROUP BY Clause.mp418.53MB
120. 20 - SQL Window Functions/014 The MySQL RANK() and DENSE_RANK() Window Functions.mp427.87MB
121. 20 - SQL Window Functions/017 Working with MySQL Ranking Window Functions and Joins Together.mp435.48MB
122. 20 - SQL Window Functions/020 The LAG() and LEAD() Value Window Functions.mp435.34MB
123. 20 - SQL Window Functions/023 MySQL Aggregate Functions in the Context of Window Functions - Part I.mp434.18MB
124. 20 - SQL Window Functions/026 MySQL Aggregate Functions in the Context of Window Functions - Part II.mp443.52MB
125. 21 - SQL Common Table Expressions (CTEs)/001 MySQL Common Table Expressions - Introduction.mp449.22MB
126. 21 - SQL Common Table Expressions (CTEs)/002 An Alternative Solution to the Same Task.mp48.45MB
127. 21 - SQL Common Table Expressions (CTEs)/005 Using Multiple Subclauses in a WITH Clause - Part I.mp424.55MB
128. 21 - SQL Common Table Expressions (CTEs)/006 Using Multiple Subclauses in a WITH Clause - Part II.mp421.19MB
129. 21 - SQL Common Table Expressions (CTEs)/009 Referring to Common Table Expressions in a WITH Clause.mp416.68MB
130. 22 - SQL Temporary Tables/001 MySQL Temporary Tables - Introduction.mp410.69MB
131. 22 - SQL Temporary Tables/002 MySQL Temporary Tables in Action.mp429.65MB
132. 22 - SQL Temporary Tables/005 Other Features of MySQL Temporary Tables.mp433.16MB
133. 23 - Combining SQL and Tableau - Introduction/001 The Advantages of Software Integration.mp456.38MB
134. 23 - Combining SQL and Tableau - Introduction/002 Why Combining SQL and Tableau is useful.mp414.71MB
135. 23 - Combining SQL and Tableau - Introduction/003 Installing Tableau Public.mp47.1MB
136. 23 - Combining SQL and Tableau - Introduction/004 Loading the 'employees_mod' Database.mp416.49MB
137. 24 - Combining SQL and Tableau - Task 1/001 Task 1.mp413.81MB
138. 24 - Combining SQL and Tableau - Task 1/004 Task 1 SQL Solution.mp420.11MB
139. 24 - Combining SQL and Tableau - Task 1/006 Transferring a Dataset from SQL to Tableau.mp412.74MB
140. 24 - Combining SQL and Tableau - Task 1/007 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I.mp415.87MB
141. 24 - Combining SQL and Tableau - Task 1/008 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II.mp419.84MB
142. 25 - Combining SQL and Tableau - Task 2/001 Task 2.mp48.8MB
143. 25 - Combining SQL and Tableau - Task 2/003 Task 2 SQL Solution.mp411.46MB
144. 25 - Combining SQL and Tableau - Task 2/005 Chart 2 Visualizing and Analyzing the Solution in Tableau.mp430.02MB
145. 26 - Combining SQL and Tableau - Task 3/001 Task 3.mp45MB
146. 26 - Combining SQL and Tableau - Task 3/003 Task 3 SQL Solution.mp414.3MB
147. 26 - Combining SQL and Tableau - Task 3/005 Chart 3 Visualizing and Analyzing the Solution in Tableau.mp418.79MB
148. 27 - Combining SQL and Tableau - Task 4/001 Task 4.mp48.67MB
149. 27 - Combining SQL and Tableau - Task 4/003 Task 4 Solution in SQL.mp412.98MB
150. 27 - Combining SQL and Tableau - Task 4/005 Chart 4 Visualizing and Analyzing the Solution in Tableau.mp48.67MB
151. 28 - Combining SQL and Tableau - Task 5/001 Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau.mp441.73MB