GigaCourse com Udemy SQL MySQL for Data Analytics and Business Intelligence

GigaCourse com Udemy SQL MySQL for Data Analytics and Business Intelligence

Name	[GigaCourse.com] Udemy - SQL - MySQL for Data Analytics and Business Intelligence	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	2.6 GB
Total Files	553
Hash	4233B705A356ECE21814BDFB23914EA5D09C9468

/1. Introduction to databases, SQL, and MySQL/
1. What does the course cover.mp4	25.4 MB
1. What does the course cover.srt	6.7 KB
2. Why SQL.mp4	15.5 MB
2. Why SQL.srt	7.9 MB
2.1 SQL - FAQ.pdf	1.2 MB
3. Why SQL.html	0.2 KB
4. Why MySQL.mp4	6.9 MB
4. Why MySQL.srt	2.9 KB
5. Why MySQL.html	0.2 KB
6. Introduction to databases.mp4	20.6 MB
6. Introduction to databases.srt	7.2 KB
7. Introduction to databases.html	0.2 KB
/10. SQL INSERT statement/
1. The INSERT statement - Part I.mp4	15.1 MB
1. The INSERT statement - Part I.srt	8.0 KB
1.1 The INSERT Statement.pdf	380.7 KB
2. The INSERT statement - Part II.mp4	7.0 MB
2. The INSERT statement - Part II.srt	3.0 KB
3. The INSERT statement - exercise 1.html	1.5 KB
4. The INSERT statement - solution 1.html	1.3 KB
5. The INSERT statement - exercise 2.html	0.4 KB
6. The INSERT statement - solution 2.html	1.2 KB
7. Inserting data INTO a new table.mp4	10.1 MB
7. Inserting data INTO a new table.srt	5.3 KB
7.1 Inserting Data INTO a New Table.pdf	309.6 KB
8. Inserting Data INTO a New Table - exercise.html	0.2 KB
9. Inserting Data INTO a New Table - solution.html	0.1 KB
/11. SQL UPDATE Statement/
1. TCL's COMMIT and ROLLBACK.mp4	8.2 MB
1. TCL's COMMIT and ROLLBACK.srt	4.2 KB
1.1 TCL's COMMIT and ROLLBACK.pdf	594.1 KB
2. The UPDATE Statement - Part I.mp4	8.3 MB
2. The UPDATE Statement - Part I.srt	4.2 KB
2.1 The UPDATE Statement.pdf	466.8 KB
3. ROLLBACK; ARTICLE.html	1.4 KB
4. The UPDATE Statement - Part II.mp4	7.8 MB
4. The UPDATE Statement - Part II.srt	4.1 KB
5. The UPDATE Statement – Part II - exercise.html	0.2 KB
6. The UPDATE Statement – Part II - solution.html	0.3 KB
/12. SQL DELETE Statement/
1. The DELETE Statement - Part I.mp4	10.8 MB
1. The DELETE Statement - Part I.srt	5.7 KB
1.1 The DELETE Statement.pdf	369.3 KB
2. The DELETE Statement - Part II.mp4	3.9 MB
2. The DELETE Statement - Part II.srt	2.1 KB
3. The DELETE Statement – Part II - exercise.html	0.1 KB
4. The DELETE Statement – Part II - solution.html	0.1 KB
5. DROP vs TRUNCATE vs DELETE.mp4	7.9 MB
5. DROP vs TRUNCATE vs DELETE.srt	4.6 KB
5.1 DROP vs TRUNCATE vs DELETE.pdf	1.1 MB
6. DROP vs TRUNCATE vs DELETE.html	0.2 KB
/13. MySQL - Aggregate functions/
1. COUNT().mp4	9.7 MB
1. COUNT().srt	6.0 KB
1.1 COUNT().pdf	1.1 MB
10. AVG().mp4	4.4 MB
10. AVG().srt	2.9 KB
10.1 AVG().pdf	453.4 KB
11. AVG() - exercise.html	0.1 KB
12. AVG() - solution.html	0.3 KB
13. ROUND().mp4	5.0 MB
13. ROUND().srt	2.9 KB
13.1 ROUND().pdf	342.8 KB
14. ROUND() - exercise.html	0.2 KB
15. ROUND() - solution.html	0.3 KB
16. COALESCE() - Preamble.html	0.0 KB
16.1 COALESCE() - Preamble.pdf	595.9 KB
17. IFNULL() and COALESCE().mp4	16.5 MB
17. IFNULL() and COALESCE().srt	8.4 KB
17.1 IFNULL() and COALESCE().pdf	732.8 KB
18. Another Example of Using COALESCE().mp4	3.9 MB
18. Another Example of Using COALESCE().srt	2.3 KB
19. Another example of using COALESCE() - exercise 1.html	0.2 KB
2. COUNT() - exercise.html	0.1 KB
20. Another example of using COALESCE() - solution 1.html	0.4 KB
21. Another example of using COALESCE() - exercise 2.html	0.3 KB
22. Another example of using COALESCE() - solution 2.html	0.6 KB
23. Another example of using COALESCE().html	0.2 KB
3. COUNT() - solution.html	0.2 KB
4. SUM().mp4	3.4 MB
4. SUM().srt	2.2 KB
4.1 SUM().pdf	505.9 KB
5. SUM() - exercise.html	0.1 KB
6. SUM() - solution.html	0.3 KB
7. MIN() and MAX().mp4	3.1 MB
7. MIN() and MAX().srt	1.7 KB
7.1 MIN() and MAX().pdf	291.7 KB
8. MIN() and MAX() - exercise.html	0.1 KB
9. MIN() and MAX() - solution.html	0.5 KB
/14. SQL Joins/
1. Introduction to JOINs.mp4	7.6 MB
1. Introduction to JOINs.srt	6.0 KB
1.1 Introduction to Joins.pdf	794.5 KB
10. Duplicate Records.mp4	13.4 MB
10. Duplicate Records.srt	6.1 KB
10.1 Duplicate Records.pdf	345.1 KB
11. LEFT JOIN - Part I.mp4	14.7 MB
11. LEFT JOIN - Part I.srt	6.8 KB
11.1 LEFT JOIN.pdf	756.8 KB
12. LEFT JOIN - Part II.mp4	15.5 MB
12. LEFT JOIN - Part II.srt	8.1 KB
13. LEFT JOIN - Part II - exercise.html	0.5 KB
14. LEFT JOIN - Part II - solution.html	0.7 KB
15. RIGHT JOIN.mp4	33.7 MB
15. RIGHT JOIN.srt	5.9 KB
15.1 RIGHT JOIN.pdf	876.8 KB
16. The new and the old join syntax.mp4	9.6 MB
16. The new and the old join syntax.srt	6.1 KB
16.1 The New and the Old Join Syntax.pdf	736.0 KB
17. The new and the old join syntax - exercise.html	0.2 KB
18. The new and the old join syntax - solution.html	1.3 KB
19. JOIN and WHERE Used Together.mp4	6.9 MB
19. JOIN and WHERE Used Together.srt	4.0 KB
19.1 JOIN and WHERE Used Together.pdf	407.5 KB
2. Intro to JOINs - exercise 1.html	1.0 KB
20. Important – Prevent Error Code 1055!.html	3.5 KB
21. JOIN and WHERE Used Together - exercise.html	0.2 KB
22. JOIN and WHERE Used Together - solution.html	0.7 KB
23. CROSS JOIN.mp4	94.4 MB
23. CROSS JOIN.srt	11.5 KB
23.1 CROSS JOIN.pdf	321.2 KB
24. CROSS JOIN - exercise 1.html	0.2 KB
25. CROSS JOIN - solution 1.html	0.4 KB
26. CROSS JOIN - exercise 2.html	0.2 KB
27. CROSS JOIN - solution 2.html	0.6 KB
28. Using Aggregate Functions with Joins.mp4	6.5 MB
28. Using Aggregate Functions with Joins.srt	3.3 KB
29. JOIN more than two tables in SQL.mp4	11.5 MB
29. JOIN more than two tables in SQL.srt	5.6 KB
29.1 JOIN More Than Two Tables in SQL.pdf	639.2 KB
3. Intro to JOINs - solution 1.html	1.6 KB
30. Join more than two tables in SQL - exercise.html	0.1 KB
31. Join more than two tables in SQL - solution.html	2.5 KB
32. Tips and tricks for joins.mp4	53.4 MB
32. Tips and tricks for joins.srt	7.8 KB
32.1 Tips and Tricks for Joins.pdf	490.7 KB
33. Tips and tricks for joins - exercise.html	0.1 KB
34. Tips and tricks for joins - solution.html	0.4 KB
35. UNION vs UNION ALL.mp4	9.0 MB
35. UNION vs UNION ALL.srt	7.2 KB
35.1 UNION vs UNION ALL.pdf	843.5 KB
36. UNION vs UNION ALL - exercise.html	0.2 KB
37. UNION vs UNION ALL - solution.html	1.8 KB
4. Intro to JOINs - exercise 2.html	1.7 KB
5. INNER JOIN - Part I.mp4	13.0 MB
5. INNER JOIN - Part I.srt	7.9 KB
5.1 INNER JOIN.pdf	797.1 KB
6. INNER JOIN - Part II.mp4	12.2 MB
6. INNER JOIN - Part II.srt	7.6 KB
7. INNER JOIN - Part II - exercise.html	0.1 KB
8. INNER JOIN - Part II - solution.html	0.6 KB
9. A Note on Using Joins.mp4	11.3 MB
9. A Note on Using Joins.srt	5.9 KB
/15. SQL Subqueries/
1. SQL Subqueries with IN nested inside WHERE.mp4	7.0 MB
1. SQL Subqueries with IN nested inside WHERE.srt	5.8 KB
1.1 Subqueries IN WHERE.pdf	1.1 MB
10. SQL Subqueries nested in SELECT and FROM - exercise 2.html	1.1 KB
11. SQL Subqueries nested in SELECT and FROM - solution 2.html	0.0 KB
11.1 Subqueries SELECT FROM Solution.sql	1.9 KB
2. SQL Subqueries with IN nested inside WHERE - exercise.html	0.2 KB
3. SQL Subqueries with IN nested inside WHERE - solution.html	0.8 KB
4. SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE.mp4	9.1 MB
4. SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE.srt	5.0 KB
4.1 Subqueries EXISTS WHERE.pdf	1.1 MB
5. SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - exercise.html	0.2 KB
6. SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - solution.html	0.9 KB
7. SQL Subqueries nested in SELECT and FROM.mp4	20.9 MB
7. SQL Subqueries nested in SELECT and FROM.srt	9.9 KB
7.1 Subqueries SELECT FROM.pdf	413.5 KB
8. SQL Subqueries nested in SELECT and FROM - exercise 1.html	0.2 KB
9. SQL Subqueries nested in SELECT and FROM - solution 1.html	0.4 KB
/16. SQL Self Join/
1. Self Join.mp4	21.9 MB
1. Self Join.srt	9.8 KB
1.1 SQL Self Join.pdf	720.7 KB
2. Self join.html	0.2 KB
/17. SQL Views/
1. Views.mp4	18.3 MB
1. Views.srt	9.4 KB
1.1 SQL Views.pdf	1.1 MB
2. Views - exercise.html	0.3 KB
3. Views - solution.html	0.6 KB
/18. Stored routines/
1. Introduction to stored routines.mp4	7.6 MB
1. Introduction to stored routines.srt	4.7 KB
1.1 Introduction to Stored Routines.pdf	747.2 KB
10. Stored procedures with an output parameter.mp4	8.9 MB
10. Stored procedures with an output parameter.srt	4.6 KB
10.1 Stored Procedures with an Output Parameter.pdf	439.7 KB
11. Stored procedures with an output parameter - exercise.html	0.2 KB
12. Stored procedures with an output parameter - solution.html	1.7 KB
13. Variables.mp4	16.7 MB
13. Variables.srt	8.4 KB
13.1 Variables.pdf	735.6 KB
14. Variables - exercise.html	0.3 KB
15. Variables - solution.html	0.2 KB
16. User-defined functions in MySQL.mp4	51.1 MB
16. User-defined functions in MySQL.srt	8.1 KB
16.1 User-Defined Functions in MySQL.pdf	524.3 KB
17. Error Code 1418..html	2.9 KB
18. User-defined functions in MySQL - exercise.html	0.4 KB
19. User-defined functions in MySQL - solution.html	1.8 KB
2. Introduction to Stored Routines.html	0.2 KB
20. Stored routines - conclusion.mp4	8.6 MB
20. Stored routines - conclusion.srt	5.5 KB
20.1 Stored Routines - Conclusion.pdf	731.0 KB
21. Stored routines - conclusion.html	0.2 KB
3. The MySQL syntax for stored procedures.mp4	6.2 MB
3. The MySQL syntax for stored procedures.srt	6.4 KB
3.1 The MySQL Syntax for Stored Procedures.pdf	932.9 KB
4. Stored procedures - Example - Part I.mp4	7.6 MB
4. Stored procedures - Example - Part I.srt	3.9 KB
5. Stored procedures - Example - Part II.mp4	11.7 MB
5. Stored procedures - Example - Part II.srt	7.2 KB
6. Stored procedures - Example - Part II - exercise.html	0.1 KB
7. Stored procedures - Example - Part II - solution.html	1.1 KB
8. Another way to create a procedure.mp4	5.7 MB
8. Another way to create a procedure.srt	4.2 KB
9. Stored procedures with an input parameter.mp4	17.9 MB
9. Stored procedures with an input parameter.srt	8.7 KB
9.1 Stored Procedures with an Input Parameter.pdf	560.9 KB
/19. Advanced SQL Topics/
1. Types of MySQL Variables - Local Variables.mp4	12.1 MB
1. Types of MySQL Variables - Local Variables.srt	6.5 KB
1.1 Types of MySQL Variables - Local Variables.pdf	887.1 KB
10. MySQL Triggers - exercise.html	0.2 KB
11. MySQL Triggers - solution.html	1.3 KB
12. MySQL Indexes.mp4	19.1 MB
12. MySQL Indexes.srt	9.6 KB
12.1 MySQL Indexes.pdf	1.4 MB
13. MySQL Indexes - exercise 1.html	0.0 KB
14. MySQL Indexes - solution 1.html	0.2 KB
15. MySQL Indexes - exercise 2.html	0.3 KB
16. MySQL Indexes - solution 2.html	0.7 KB
17. The CASE Statement.mp4	62.3 MB
17. The CASE Statement.srt	7.8 KB
17.1 The CASE Statement.pdf	309.4 KB
18. The CASE Statement - exercise 1.html	0.4 KB
19. The CASE Statement - solution 1.html	0.7 KB
2. Types of MySQL Variables - Local Variables.html	0.2 KB
20. The CASE Statement - exercise 2.html	0.4 KB
21. The CASE Statement - solution 2.html	1.8 KB
22. The CASE Statement - exercise 3.html	0.4 KB
23. The CASE Statement - solution 3.html	0.7 KB
3. Session Variables.mp4	12.5 MB
3. Session Variables.srt	7.3 KB
3.1 Session Variables.pdf	1.9 MB
4. Session Variables.html	0.2 KB
5. Global Variables.mp4	5.3 MB
5. Global Variables.srt	3.1 KB
5.1 Global Variables.pdf	692.5 KB
6. Global Variables.html	0.2 KB
7. User-Defined vs System Variables.mp4	11.5 MB
7. User-Defined vs System Variables.srt	6.0 KB
7.1 User-Defined vs System Variables.pdf	716.2 KB
8. User-Defined vs System Variables.html	0.2 KB
9. MySQL Triggers.html	0.5 KB
9.1 MySQL Triggers.sql	10.0 KB
/2. SQL theory/
1. SQL as a declarative language.mp4	10.6 MB
1. SQL as a declarative language.srt	3.1 KB
1.1 Course Notes SQL - MySQL for Data Analytics and Business Intelligence.html	0.1 KB
10. Data control language (DCL).html	0.2 KB
11. Transaction control language (TCL).mp4	7.2 MB
11. Transaction control language (TCL).srt	4.5 KB
11.1 TCL.pdf	988.9 KB
12. Transaction control language (TCL).html	0.2 KB
2. SQL as a declarative language.html	0.2 KB
3. Data definition language (DDL).mp4	9.1 MB
3. Data definition language (DDL).srt	6.3 KB
3.1 DDL.pdf	1.3 MB
4. Data definition language (DDL).html	0.2 KB
5. SQL keywords.mp4	2.6 MB
5. SQL keywords.srt	1.8 KB
5.1 SQL Keywords.pdf	545.9 KB
6. SQL keywords.html	0.2 KB
7. Data manipulation language (DML).mp4	10.5 MB
7. Data manipulation language (DML).srt	6.5 KB
7.1 DML.pdf	935.1 KB
8. Data manipulation language (DML).html	0.2 KB
9. Data control language (DCL).mp4	8.5 MB
9. Data control language (DCL).srt	7.1 KB
9.1 DCL.pdf	699.1 KB
/20. Combining SQL and Tableau - Introduction/
1. The Advantages of Software Integration.mp4	96.9 MB
1. The Advantages of Software Integration.srt	8.1 KB
2. Why Combining SQL and Tableau is useful.mp4	89.5 MB
2. Why Combining SQL and Tableau is useful.srt	7.4 KB
3. Installing Tableau Public.mp4	28.7 MB
3. Installing Tableau Public.srt	2.6 KB
4. Loading the 'employees_mod' Database.mp4	29.9 MB
4. Loading the 'employees_mod' Database.srt	4.6 KB
4.1 employees_mod_db.pdf	132.8 KB
4.2 The 'employees_mod' Database.html	0.1 KB
5. Loading the 'employees_mod' Database.html	0.6 KB
5.1 employees_mod_db.pdf	132.8 KB
5.2 The 'employees_mod' database.html	0.1 KB
/21. Combining SQL and Tableau - Task 1/
1. Task 1.mp4	35.2 MB
1. Task 1.srt	8.2 KB
2. Task 1 - Text.html	0.1 KB
3. Important clarification!.html	1.4 KB
4. Task 1 SQL Solution.mp4	45.3 MB
4. Task 1 SQL Solution.srt	6.4 KB
5. Task 1 SQL Solution - Code.html	0.5 KB
6. Transferring a Dataset from SQL to Tableau.mp4	32.9 MB
6. Transferring a Dataset from SQL to Tableau.srt	5.9 KB
7. Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I.mp4	42.5 MB
7. Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I.srt	8.7 KB
8. Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II.mp4	47.3 MB
8. Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II.srt	7.8 KB
/22. Combining SQL and Tableau - Task 2/
1. Task 2.mp4	30.3 MB
1. Task 2.srt	5.2 KB
2. Task 2 - Text.html	0.1 KB
3. Task 2 SQL Solution.mp4	41.2 MB
3. Task 2 SQL Solution.srt	4.9 KB
4. Task 2 SQL Solution - Code.html	0.8 KB
5. Chart 2 Visualizing and Analyzing the Solution in Tableau.mp4	51.3 MB
5. Chart 2 Visualizing and Analyzing the Solution in Tableau.srt	8.7 KB
/23. Combining SQL and Tableau - Task 3/
1. Task 3.mp4	13.7 MB
1. Task 3.srt	3.2 KB
2. Task 3 - Text.html	0.2 KB
3. Task 3 SQL Solution.mp4	34.7 MB
3. Task 3 SQL Solution.srt	4.4 KB
4. Task 3 SQL Solution - Code.html	0.5 KB
5. Chart 3 Visualizing and Analyzing the Solution in Tableau.mp4	42.3 MB
5. Chart 3 Visualizing and Analyzing the Solution in Tableau.srt	6.6 KB
/24. Combining SQL and Tableau - Task 4/
1. Task 4.mp4	24.7 MB
1. Task 4.srt	3.9 KB
2. Task 4 - Text.html	0.3 KB
3. Task 4 Solution in SQL.mp4	31.7 MB
3. Task 4 Solution in SQL.srt	3.6 KB
4. Task 4 Solution in SQL - Code.html	0.7 KB
5. Chart 4 Visualizing and Analyzing the Solution in Tableau.mp4	23.4 MB
5. Chart 4 Visualizing and Analyzing the Solution in Tableau.srt	4.4 KB
/25. Combining SQL and Tableau - Task 5/
1. Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau.mp4	58.7 MB
1. Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau.srt	7.7 KB
/26. Practice SQL – 10 Final Query Questions/
1. Practice SQL – 10 Final Query Questions.html	1.0 KB
1.1 Practice SQL – 10 Final Query Questions - SOLUTIONS.sql	7.2 KB
1.2 Practice SQL - 10 Final Query Questions.pdf	560.7 KB
/27. BONUS LECTURE/
1. Bonus Lecture Next Steps.html	2.0 KB
/3. Basic database terminology/
1. Relational database essentials.mp4	24.1 MB
1. Relational database essentials.srt	7.9 KB
10. Relational schemas - Foreign key.html	0.2 KB
11. Relational schemas - Unique key and null values.mp4	6.7 MB
11. Relational schemas - Unique key and null values.srt	5.2 KB
11.1 Relational Schemas - Unique Key and Null Values.pdf	792.4 KB
12. Relational Schemas - Unique key.html	0.2 KB
13. Relationships.mp4	10.2 MB
13. Relationships.srt	7.0 KB
13.1 Relationships.pdf	1.4 MB
14. Relational Schemas – Relationships.html	0.2 KB
2. Relational database essentials.html	0.2 KB
3. Databases vs spreadsheets.mp4	178.2 MB
3. Databases vs spreadsheets.srt	14.2 KB
4. Databases vs spreadsheets.html	0.2 KB
5. Database terminology.mp4	19.9 MB
5. Database terminology.srt	7.4 KB
6. Database terminology.html	0.2 KB
7. Relational schemas - Primary key.mp4	10.9 MB
7. Relational schemas - Primary key.srt	7.9 KB
7.1 Relational Schemas - Primary Key.pdf	1.3 MB
8. Relational schemas - Primary key.html	0.2 KB
9. Relational schemas - Foreign key.mp4	10.9 MB
9. Relational schemas - Foreign key.srt	7.9 KB
9.1 Relational Schemas - Foreign Key.pdf	983.4 KB
/4. Installing MySQL and getting acquainted with the interface/
1. Installing MySQL.mp4	94.2 MB
1. Installing MySQL.srt	14.7 KB
2. Additional note – Installing – Visual C.html	0.8 KB
3. Installing MySQL on macOS and Unix systems.html	2.1 KB
4. The Client-Server Model.html	0.0 KB
4.1 The Client-Server Model.pdf	570.3 KB
5. Setting up a connection.mp4	6.5 MB
5. Setting up a connection.srt	3.7 KB
6. Read me!!!.html	1.0 KB
7. New Authentication Plugin - Creating a New User.mp4	50.0 MB
7. New Authentication Plugin - Creating a New User.srt	7.9 KB
8. Introduction to the MySQL interface.mp4	12.5 MB
8. Introduction to the MySQL interface.srt	7.2 KB
/5. First steps in SQL/
1. Creating a Database - Part I.mp4	10.9 MB
1. Creating a Database - Part I.srt	8.4 KB
1.1 Creating a Database - Part I.pdf	812.6 KB
10. String data types.mp4	9.6 MB
10. String data types.srt	7.1 KB
10.1 String Data Types.pdf	453.9 KB
11. String data types.html	0.2 KB
12. Integers.mp4	9.3 MB
12. Integers.srt	5.9 KB
12.1 Integers.pdf	671.8 KB
13. Integers.html	0.2 KB
14. Fixed and floating-point data types.mp4	12.3 MB
14. Fixed and floating-point data types.srt	8.1 KB
14.1 Fixed- and Floating-Point Data Types.pdf	718.5 KB
15. Fixed and floating-point data types.html	0.2 KB
16. Other useful data types.mp4	12.4 MB
16. Other useful data types.srt	8.8 KB
16.1 Other Useful Data Types.pdf	746.5 KB
17. Other useful data types.html	0.2 KB
18. Creating a table.mp4	11.2 MB
18. Creating a table.srt	7.7 KB
18.1 Creating a Table.pdf	556.0 KB
19. Creating a table - exercise.html	0.4 KB
2. SQL files.html	1.2 KB
2.1 SQL - FAQ.pdf	1.2 MB
2.2 MySQL for Data Analytics and BI - Lecture Code.sql	43.7 KB
2.3 MySQL for Data Analytics and BI - Lecture Code and Tasks Solutions.sql	62.2 KB
20. Creating a table - solution.html	0.7 KB
21. Using databases and tables.mp4	6.8 MB
21. Using databases and tables.srt	3.9 KB
21.1 Using Databases and Tables.pdf	542.5 KB
22. Using databases and tables - exercise.html	0.3 KB
23. Using databases and tables - solution.html	0.1 KB
24. Additional notes on using tables.mp4	5.3 MB
24. Additional notes on using tables.srt	3.0 KB
24.1 Additional Notes on Using Tables.pdf	391.5 KB
25. Additional notes on using tables.html	0.2 KB
26. Additional notes on using tables - exercise.html	0.3 KB
3. Creating a Database - Part I - exercise.html	0.2 KB
4. Creating a Database - Part I - solution.html	0.1 KB
5. Creating a Database - Part II.mp4	5.1 MB
5. Creating a Database - Part II.srt	3.9 KB
6. Creating a Database - Part II - exercise.html	0.1 KB
7. Creating a Database - Part II - solution.html	0.0 KB
8. Introduction to data types.mp4	3.3 MB
8. Introduction to data types.srt	3.4 KB
8.1 Introduction to Data Types.pdf	508.6 KB
9. Introduction to data types.html	0.2 KB
/6. MySQL constraints/
1. PRIMARY KEY constraint.mp4	12.6 MB
1. PRIMARY KEY constraint.srt	7.9 KB
1.1 sales_db.pdf	144.0 KB
1.2 PRIMARY KEY Constraint.pdf	560.2 KB
10. UNIQUE Constraint - exercise.html	1.5 KB
11. DEFAULT Constraint.mp4	13.8 MB
11. DEFAULT Constraint.srt	7.5 KB
11.1 DEFAULT Constraint.pdf	527.3 KB
12. DEFAULT Constraint - exercise.html	0.5 KB
13. DEFAULT Constraint - solution.html	0.5 KB
14. NOT NULL Constraint - Part I.mp4	15.6 MB
14. NOT NULL Constraint - Part I.srt	8.0 KB
14.1 NOT NULL Constraint.pdf	696.5 KB
15. NOT NULL Constraint - Part I - exercise.html	0.2 KB
16. NOT NULL Constraint - Part I - solution.html	0.3 KB
17. NOT NULL Constraint - Part II.mp4	3.9 MB
17. NOT NULL Constraint - Part II.srt	2.8 KB
2. PRIMARY KEY Constraint.html	0.2 KB
3. PRIMARY KEY constraint - exercise.html	1.6 KB
4. PRIMARY KEY constraint - solution.html	2.7 KB
5. FOREIGN KEY constraint - Part I.mp4	11.6 MB
5. FOREIGN KEY constraint - Part I.srt	7.5 KB
5.1 FOREIGN KEY Constraint.pdf	1.1 MB
6. FOREIGN KEY constraint - Part II.mp4	15.3 MB
6. FOREIGN KEY constraint - Part II.srt	6.6 KB
7. FOREIGN KEY constraint - Part II - exercise.html	0.2 KB
8. FOREIGN KEY constraint - Part II - solution.html	0.2 KB
9. UNIQUE Constraint.mp4	12.3 MB
9. UNIQUE Constraint.srt	6.2 KB
9.1 UNIQUE Constraint.pdf	744.0 KB
/7. SQL best practices/
1. Coding techniques and best practices - Part I.mp4	12.1 MB
1. Coding techniques and best practices - Part I.srt	7.8 KB
1.1 Coding Techniques and Best Practices.pdf	1.3 MB
1.2 MySQL_Workbench_Shortcuts.pdf	527.6 KB
2. Coding techniques and best practices – Part I.html	0.2 KB
3. Coding techniques and best practices - Part II.mp4	9.7 MB
3. Coding techniques and best practices - Part II.srt	5.6 KB
4. Coding techniques and best practices – Part II.html	0.2 KB
/8. Loading the 'employees' database/
1. Loading the 'employees' database.mp4	8.5 MB
1. Loading the 'employees' database.srt	3.2 KB
2. Loading the 'employees' database.html	1.0 KB
2.1 The 'employees' database.html	0.1 KB
/9. SQL SELECT statement/
1. SELECT - FROM.mp4	11.5 MB
1. SELECT - FROM.srt	6.7 KB
1.1 SELECT - FROM.pdf	585.7 KB
1.2 employees_db.pdf	183.1 KB
10. OR.mp4	8.9 MB
10. OR.srt	4.5 KB
10.1 OR.pdf	359.7 KB
11. OR - exercise.html	0.1 KB
12. OR - solution.html	0.3 KB
13. Operator precedence.mp4	8.9 MB
13. Operator precedence.srt	4.9 KB
13.1 Operator Precedence.pdf	430.5 KB
14. Operator precedence - exercise.html	0.1 KB
15. Operator precedence - solution.html	0.3 KB
16. IN - NOT IN.mp4	8.7 MB
16. IN - NOT IN.srt	4.3 KB
17. IN - NOT IN - exercise 1.html	0.1 KB
18. IN - NOT IN - solution 1.html	0.3 KB
19. IN - NOT IN - exercise 2.html	0.1 KB
2. SELECT - FROM - exercise.html	0.2 KB
20. IN - NOT IN - solution 2.html	0.3 KB
21. LIKE - NOT LIKE.mp4	10.1 MB
21. LIKE - NOT LIKE.srt	5.0 KB
22. LIKE - NOT LIKE - exercise.html	0.4 KB
23. LIKE - NOT LIKE - solution.html	1.0 KB
24. Wildcard characters.mp4	3.5 MB
24. Wildcard characters.srt	2.9 KB
24.1 Wildcard Characters.pdf	416.2 KB
25. Wildcard characters - exercise.html	0.2 KB
26. Wildcard characters - solution.html	0.6 KB
27. BETWEEN - AND.mp4	5.4 MB
27. BETWEEN - AND.srt	2.8 KB
27.1 BETWEEN - AND.pdf	671.3 KB
28. BETWEEN - AND - exercise.html	0.3 KB
29. BETWEEN - AND- solution.html	1.4 KB
3. SELECT - FROM - solution.html	0.4 KB
30. IS NOT NULL - IS NULL.mp4	4.0 MB
30. IS NOT NULL - IS NULL.srt	2.2 KB
30.1 IS NOT NULL - IS NULL.pdf	365.8 KB
31. IS NOT NULL - IS NULL - exercise.html	0.1 KB
32. IS NOT NULL - IS NULL - solution.html	0.3 KB
33. Other comparison operators.mp4	11.6 MB
33. Other comparison operators.srt	5.8 KB
33.1 Other Comparison Operators.pdf	348.2 KB
34. Other comparison operators - exercise.html	0.3 KB
35. Other comparison operators - solution.html	0.7 KB
36. SELECT DISTINCT.mp4	4.8 MB
36. SELECT DISTINCT.srt	3.0 KB
36.1 SELECT DISTINCT.pdf	392.0 KB
37. SELECT DISTINCT - exercise.html	0.4 KB
38. SELECT DISTINCT - solution.html	0.2 KB
39. Introduction to aggregate functions.mp4	13.3 MB
39. Introduction to aggregate functions.srt	7.7 KB
39.1 Introduction to Aggregate Functions.pdf	755.0 KB
4. WHERE.mp4	6.3 MB
4. WHERE.srt	3.4 KB
4.1 WHERE.pdf	423.7 KB
40. Introduction to aggregate functions - exercise.html	0.3 KB
41. Introduction to aggregate functions - solution.html	0.5 KB
42. ORDER BY.mp4	11.3 MB
42. ORDER BY.srt	4.8 KB
43. ORDER BY - exercise.html	0.1 KB
44. ORDER BY - solution.html	0.2 KB
45. GROUP BY.mp4	15.6 MB
45. GROUP BY.srt	7.8 KB
45.1 GROUP BY.pdf	466.0 KB
46. Using Aliases (AS).mp4	5.5 MB
46. Using Aliases (AS).srt	3.0 KB
47. Using Aliases (AS) - exercise.html	0.3 KB
48. Using Aliases (AS) - solution.html	0.4 KB
49. HAVING.mp4	9.4 MB
49. HAVING.srt	4.7 KB
49.1 HAVING.pdf	474.3 KB
5. WHERE - exercise.html	0.1 KB
50. HAVING - exercise.html	1.0 KB
51. HAVING - solution.html	0.7 KB
52. WHERE vs HAVING- Part I.mp4	10.5 MB
52. WHERE vs HAVING- Part I.srt	5.4 KB
52.1 WHERE vs HAVING.pdf	786.0 KB
53. WHERE vs HAVING- Part II.mp4	7.1 MB
53. WHERE vs HAVING- Part II.srt	4.5 KB
54. WHERE vs HAVING - Part II - exercise.html	0.2 KB
55. WHERE vs HAVING - Part II - solution.html	0.4 KB
56. LIMIT.mp4	13.3 MB
56. LIMIT.srt	6.8 KB
56.1 LIMIT.pdf	304.4 KB
57. LIMIT - exercise.html	0.1 KB
58. LIMIT - solution.html	0.2 KB
6. WHERE - solution.html	0.3 KB
7. AND.mp4	5.1 MB
7. AND.srt	2.9 KB
7.1 AND.pdf	501.5 KB
8. AND - exercise.html	0.1 KB
9. AND - solution.html	0.4 KB
/
Readme.txt	1.0 KB
[GigaCourse.com].url	0.0 KB
Total files 553