FreeCourseWeb com Udemy SQL MySQL for Data Analytics and Business Intelligence

FreeCourseWeb com Udemy SQL MySQL for Data Analytics and Business Intelligence

Name	[ FreeCourseWeb.com ] Udemy - SQL - MySQL for Data Analytics and Business Intelligence	DOWNLOAD Copy Link
Total Size	3.2 GB
Total Files	587
Last Seen	2024-11-07 23:47
Hash	90A9125B4847EA5158913AF1C6BF9F0230F2D421

/
Get Bonus Downloads Here.url	0.2 KB
/.../01 - Introduction to databases, SQL, and MySQL/
001 What does the course cover.mp4	77.2 MB
001 What does the course cover_en.srt	6.5 KB
002 SQL-FAQ.pdf	771.2 KB
002 Why SQL.mp4	60.9 MB
002 Why SQL_en.srt	4.7 KB
003 Why MySQL.mp4	24.9 MB
003 Why MySQL_en.srt	2.8 KB
004 Introduction to databases.mp4	87.6 MB
004 Introduction to databases_en.srt	7.0 KB
/.../02 - SQL theory/
001 Course-Notes-SQL-MySQL-for-Data-Analytics-and-Business-Intelligence.url	0.1 KB
001 SQL as a declarative language.mp4	7.4 MB
001 SQL as a declarative language_en.srt	3.0 KB
002 DDL.pdf	1.3 MB
002 Data definition language (DDL).mp4	9.5 MB
002 Data definition language (DDL)_en.srt	6.1 KB
003 SQL keywords.mp4	2.6 MB
003 SQL keywords_en.srt	1.8 KB
003 SQL-Keywords.pdf	545.9 KB
004 DML.pdf	935.1 KB
004 Data manipulation language (DML).mp4	11.2 MB
004 Data manipulation language (DML)_en.srt	6.3 KB
005 DCL.pdf	699.1 KB
005 Data control language (DCL).mp4	14.2 MB
005 Data control language (DCL)_en.srt	6.8 KB
006 TCL.pdf	988.9 KB
006 Transaction control language (TCL).mp4	9.6 MB
006 Transaction control language (TCL)_en.srt	4.4 KB
external-links.txt	0.2 KB
/.../03 - Basic database terminology/
001 Relational database essentials.mp4	96.2 MB
001 Relational database essentials_en.srt	6.9 KB
002 Databases vs spreadsheets.mp4	148.1 MB
002 Databases vs spreadsheets_en.srt	12.4 KB
003 Database terminology.mp4	14.0 MB
003 Database terminology_en.srt	6.4 KB
004 Relational schemas - Primary key.mp4	15.1 MB
004 Relational schemas - Primary key_en.srt	7.5 KB
004 Relational-Schemas-Primary-Key.pdf	1.3 MB
005 Relational schemas - Foreign key.mp4	12.4 MB
005 Relational schemas - Foreign key_en.srt	7.3 KB
005 Relational-Schemas-Foreign-Key.pdf	983.4 KB
006 Relational schemas - Unique key and null values.mp4	7.3 MB
006 Relational schemas - Unique key and null values_en.srt	4.6 KB
006 Relational-Schemas-Unique-Key-and-Null-Values.pdf	792.4 KB
007 Relationships.mp4	13.9 MB
007 Relationships.pdf	1.4 MB
007 Relationships_en.srt	6.8 KB
/.../04 - Installing MySQL and getting acquainted with the interface/
001 Installing MySQL.mp4	63.1 MB
001 Installing MySQL_en.srt	13.4 KB
002 Additional note – Installing – Visual C.html	0.8 KB
003 Installing MySQL on macOS and Unix systems.html	2.7 KB
004 The Client-Server Model.html	0.0 KB
004 The-Client-Server-Model.pdf	570.3 KB
005 Setting up a connection.mp4	6.7 MB
005 Setting up a connection_en.srt	3.7 KB
006 Read me!!!.html	1.0 KB
007 New Authentication Plugin - Creating a New User.mp4	20.0 MB
007 New Authentication Plugin - Creating a New User_en.srt	7.6 KB
008 Introduction to the MySQL interface.mp4	14.8 MB
008 Introduction to the MySQL interface_en.srt	6.8 KB
/.../05 - First steps in SQL/
001 Creating a Database - Part I.mp4	21.3 MB
001 Creating a Database - Part I_en.srt	7.4 KB
001 Creating-a-Database-Part-I.pdf	812.6 KB
002 MySQL-for-Data-Analytics-and-BI-Lecture-Code-and-Tasks-Solutions.sql	62.2 KB
002 MySQL-for-Data-Analytics-and-BI-Lecture-Code.sql	43.7 KB
002 SQL files.html	1.3 KB
002 SQL-FAQ.pdf	1.2 MB
003 Creating a Database - Part I - exercise.html	0.1 KB
004 Creating a Database - Part I - solution.html	0.1 KB
005 Creating a Database - Part II.mp4	6.3 MB
005 Creating a Database - Part II_en.srt	3.4 KB
006 Creating a Database - Part II - exercise.html	0.1 KB
007 Creating a Database - Part II - solution.html	0.0 KB
008 Introduction to data types.mp4	5.0 MB
008 Introduction to data types_en.srt	3.1 KB
008 Introduction-to-Data-Types.pdf	508.6 KB
009 String data types.mp4	11.7 MB
009 String data types_en.srt	6.7 KB
009 String-Data-Types.pdf	453.9 KB
010 Integers.mp4	16.0 MB
010 Integers.pdf	671.8 KB
010 Integers_en.srt	5.4 KB
011 Fixed and floating-point data types.mp4	19.5 MB
011 Fixed and floating-point data types_en.srt	7.9 KB
011 Fixed-and-Floating-Point-Data-Types.pdf	718.5 KB
012 Other useful data types.mp4	14.6 MB
012 Other useful data types_en.srt	8.0 KB
012 Other-Useful-Data-Types.pdf	746.5 KB
013 Creating a table.mp4	17.1 MB
013 Creating a table_en.srt	7.4 KB
013 Creating-a-Table.pdf	556.0 KB
014 Creating a table - exercise.html	0.4 KB
015 Creating a table - solution.html	0.7 KB
016 Using databases and tables.mp4	9.6 MB
016 Using databases and tables_en.srt	3.5 KB
016 Using-Databases-and-Tables.pdf	542.5 KB
017 Using databases and tables - exercise.html	0.3 KB
018 Using databases and tables - solution.html	0.1 KB
019 Additional notes on using tables.mp4	7.6 MB
019 Additional notes on using tables_en.srt	2.9 KB
019 Additional-Notes-on-Using-Tables.pdf	391.5 KB
020 Additional notes on using tables - exercise.html	0.3 KB
/.../06 - MySQL constraints/
001 PRIMARY KEY constraint.mp4	18.5 MB
001 PRIMARY KEY constraint_en.srt	7.4 KB
001 PRIMARY-KEY-Constraint.pdf	560.2 KB
001 sales-db.pdf	144.0 KB
002 PRIMARY KEY constraint - exercise.html	1.6 KB
003 PRIMARY KEY constraint - solution.html	2.7 KB
004 FOREIGN KEY constraint - Part I.mp4	18.6 MB
004 FOREIGN KEY constraint - Part I_en.srt	7.1 KB
004 FOREIGN-KEY-Constraint.pdf	1.1 MB
005 FOREIGN KEY constraint - Part II.mp4	22.4 MB
005 FOREIGN KEY constraint - Part II_en.srt	6.3 KB
006 FOREIGN KEY constraint - Part II - exercise.html	0.2 KB
007 FOREIGN KEY constraint - Part II - solution.html	0.2 KB
008 UNIQUE Constraint.mp4	14.1 MB
008 UNIQUE Constraint_en.srt	5.9 KB
008 UNIQUE-Constraint.pdf	744.0 KB
009 UNIQUE Constraint - exercise.html	1.6 KB
010 DEFAULT Constraint.mp4	15.4 MB
010 DEFAULT Constraint_en.srt	6.9 KB
010 DEFAULT-Constraint.pdf	527.3 KB
011 DEFAULT Constraint - exercise.html	0.4 KB
012 DEFAULT Constraint - solution.html	0.5 KB
013 NOT NULL Constraint - Part I.mp4	36.3 MB
013 NOT NULL Constraint - Part I_en.srt	7.3 KB
013 NOT-NULL-Constraint.pdf	696.5 KB
014 NOT NULL Constraint - Part I - exercise.html	0.2 KB
015 NOT NULL Constraint - Part I - solution.html	0.4 KB
016 NOT NULL Constraint - Part II.mp4	4.5 MB
016 NOT NULL Constraint - Part II_en.srt	2.8 KB
/.../07 - SQL best practices/
001 Coding techniques and best practices - Part I.mp4	14.4 MB
001 Coding techniques and best practices - Part I_en.srt	7.5 KB
001 Coding-Techniques-and-Best-Practices.pdf	1.3 MB
001 MySQL-Workbench-Shortcuts.pdf	527.6 KB
002 Coding techniques and best practices - Part II.mp4	12.1 MB
002 Coding techniques and best practices - Part II_en.srt	5.2 KB
/.../08 - Loading the 'employees' database/
001 Loading the 'employees' database.mp4	8.5 MB
001 Loading the 'employees' database_en.srt	2.9 KB
002 Loading the 'employees' database.html	1.0 KB
002 The-employees-database.url	0.1 KB
external-links.txt	0.1 KB
/.../09 - SQL SELECT statement/
001 SELECT - FROM.mp4	15.9 MB
001 SELECT - FROM_en.srt	6.2 KB
001 SELECT-FROM.pdf	585.7 KB
001 employees-db.pdf	183.1 KB
002 SELECT - FROM - exercise.html	0.2 KB
003 SELECT - FROM - solution.html	0.5 KB
004 WHERE.mp4	17.8 MB
004 WHERE.pdf	423.7 KB
004 WHERE_en.srt	3.3 KB
005 WHERE - exercise.html	0.1 KB
006 WHERE - solution.html	0.3 KB
007 AND.mp4	5.9 MB
007 AND.pdf	501.5 KB
007 AND_en.srt	2.9 KB
008 AND - exercise.html	0.1 KB
009 AND - solution.html	0.4 KB
010 OR.mp4	11.1 MB
010 OR.pdf	359.7 KB
010 OR_en.srt	4.2 KB
011 OR - exercise.html	0.1 KB
012 OR - solution.html	0.3 KB
013 Operator precedence.mp4	10.7 MB
013 Operator precedence_en.srt	4.5 KB
013 Operator-Precedence.pdf	430.5 KB
014 Operator precedence - exercise.html	0.1 KB
015 Operator precedence - solution.html	0.3 KB
016 IN - NOT IN.mp4	10.3 MB
016 IN - NOT IN_en.srt	4.3 KB
017 IN - NOT IN - exercise 1.html	0.1 KB
018 IN - NOT IN - solution 1.html	0.3 KB
019 IN - NOT IN - exercise 2.html	0.1 KB
020 IN - NOT IN - solution 2.html	0.3 KB
021 LIKE - NOT LIKE.mp4	11.4 MB
021 LIKE - NOT LIKE_en.srt	4.7 KB
022 LIKE - NOT LIKE - exercise.html	0.4 KB
023 LIKE - NOT LIKE - solution.html	1.1 KB
024 Wildcard characters.mp4	3.9 MB
024 Wildcard characters_en.srt	2.6 KB
024 Wildcard-Characters.pdf	416.2 KB
025 Wildcard characters - exercise.html	0.2 KB
026 Wildcard characters - solution.html	0.6 KB
027 BETWEEN - AND.mp4	5.7 MB
027 BETWEEN - AND_en.srt	2.7 KB
027 BETWEEN-AND.pdf	671.3 KB
028 BETWEEN - AND - exercise.html	0.3 KB
029 BETWEEN - AND- solution.html	1.5 KB
030 IS NOT NULL - IS NULL.mp4	4.8 MB
030 IS NOT NULL - IS NULL_en.srt	2.1 KB
030 IS-NOT-NULL-IS-NULL.pdf	365.8 KB
031 IS NOT NULL - IS NULL - exercise.html	0.1 KB
032 IS NOT NULL - IS NULL - solution.html	0.3 KB
033 Other comparison operators.mp4	17.1 MB
033 Other comparison operators_en.srt	5.7 KB
033 Other-Comparison-Operators.pdf	348.2 KB
034 Other comparison operators - exercise.html	0.3 KB
035 Other comparison operators - solution.html	0.8 KB
036 SELECT DISTINCT.mp4	8.0 MB
036 SELECT DISTINCT_en.srt	2.7 KB
036 SELECT-DISTINCT.pdf	392.0 KB
037 SELECT DISTINCT - exercise.html	0.3 KB
038 SELECT DISTINCT - solution.html	0.3 KB
039 Introduction to aggregate functions.mp4	15.3 MB
039 Introduction to aggregate functions_en.srt	7.0 KB
039 Introduction-to-Aggregate-Functions.pdf	755.0 KB
040 Introduction to aggregate functions - exercise.html	0.3 KB
041 Introduction to aggregate functions - solution.html	0.5 KB
042 ORDER BY.mp4	12.6 MB
042 ORDER BY_en.srt	4.6 KB
043 ORDER BY - exercise.html	0.1 KB
044 ORDER BY - solution.html	0.3 KB
045 GROUP BY.mp4	25.5 MB
045 GROUP BY_en.srt	7.6 KB
045 GROUP-BY.pdf	466.0 KB
046 Using Aliases (AS).mp4	7.1 MB
046 Using Aliases (AS)_en.srt	2.9 KB
047 Using Aliases (AS) - exercise.html	0.3 KB
048 Using Aliases (AS) - solution.html	0.5 KB
049 HAVING.mp4	13.3 MB
049 HAVING.pdf	474.3 KB
049 HAVING_en.srt	4.5 KB
050 HAVING - exercise.html	1.1 KB
051 HAVING - solution.html	0.7 KB
052 WHERE vs HAVING- Part I.mp4	28.6 MB
052 WHERE vs HAVING- Part I_en.srt	5.2 KB
052 WHERE-vs-HAVING.pdf	786.0 KB
053 WHERE vs HAVING- Part II.mp4	18.7 MB
053 WHERE vs HAVING- Part II_en.srt	4.1 KB
054 WHERE vs HAVING - Part II - exercise.html	0.2 KB
055 WHERE vs HAVING - Part II - solution.html	0.5 KB
056 LIMIT.mp4	19.6 MB
056 LIMIT.pdf	304.4 KB
056 LIMIT_en.srt	6.5 KB
057 LIMIT - exercise.html	0.1 KB
058 LIMIT - solution.html	0.2 KB
/.../10 - SQL INSERT statement/
001 The INSERT statement - Part I.mp4	22.5 MB
001 The INSERT statement - Part I_en.srt	7.8 KB
001 The-INSERT-Statement.pdf	380.7 KB
002 The INSERT statement - Part II.mp4	7.7 MB
002 The INSERT statement - Part II_en.srt	3.0 KB
003 The INSERT statement - exercise 1.html	1.5 KB
004 The INSERT statement - solution 1.html	1.4 KB
005 The INSERT statement - exercise 2.html	0.4 KB
006 The INSERT statement - solution 2.html	1.3 KB
007 Inserting data INTO a new table.mp4	12.3 MB
007 Inserting data INTO a new table_en.srt	5.0 KB
007 Inserting-Data-INTO-a-New-Table.pdf	309.6 KB
008 Inserting Data INTO a New Table - exercise.html	0.2 KB
009 Inserting Data INTO a New Table - solution.html	0.1 KB
/.../11 - SQL UPDATE Statement/
001 TCL's COMMIT and ROLLBACK.mp4	10.1 MB
001 TCL's COMMIT and ROLLBACK_en.srt	3.9 KB
001 TCLs-COMMIT-and-ROLLBACK.pdf	594.1 KB
002 The UPDATE Statement - Part I.mp4	10.2 MB
002 The UPDATE Statement - Part I_en.srt	3.9 KB
002 The-UPDATE-Statement.pdf	466.8 KB
003 ROLLBACK; ARTICLE.html	1.3 KB
004 The UPDATE Statement - Part II.mp4	9.2 MB
004 The UPDATE Statement - Part II_en.srt	3.8 KB
005 The UPDATE Statement – Part II - exercise.html	0.2 KB
006 The UPDATE Statement – Part II - solution.html	0.3 KB
/.../12 - SQL DELETE Statement/
001 The DELETE Statement - Part I.mp4	13.4 MB
001 The DELETE Statement - Part I_en.srt	5.3 KB
001 The-DELETE-Statement.pdf	369.3 KB
002 The DELETE Statement - Part II.mp4	5.9 MB
002 The DELETE Statement - Part II_en.srt	1.8 KB
003 The DELETE Statement – Part II - exercise.html	0.1 KB
004 The DELETE Statement – Part II - solution.html	0.2 KB
005 DROP vs TRUNCATE vs DELETE.mp4	8.0 MB
005 DROP vs TRUNCATE vs DELETE_en.srt	4.4 KB
005 DROP-vs-TRUNCATE-vs-DELETE.pdf	1.1 MB
/.../13 - MySQL - Aggregate functions/
001 COUNT().mp4	20.0 MB
001 COUNT()_en.srt	5.7 KB
001 COUNT.pdf	1.1 MB
002 COUNT() - exercise.html	0.1 KB
003 COUNT() - solution.html	0.2 KB
004 SUM().mp4	4.0 MB
004 SUM()_en.srt	2.1 KB
004 SUM.pdf	505.9 KB
005 SUM() - exercise.html	0.1 KB
006 SUM() - solution.html	0.3 KB
007 MIN() and MAX().mp4	3.7 MB
007 MIN() and MAX()_en.srt	1.6 KB
007 MIN-and-MAX.pdf	291.7 KB
008 MIN() and MAX() - exercise.html	0.1 KB
009 MIN() and MAX() - solution.html	0.5 KB
010 AVG().mp4	6.9 MB
010 AVG()_en.srt	2.8 KB
010 AVG.pdf	453.4 KB
011 AVG() - exercise.html	0.1 KB
012 AVG() - solution.html	0.3 KB
013 ROUND().mp4	6.3 MB
013 ROUND()_en.srt	2.7 KB
013 ROUND.pdf	342.8 KB
014 ROUND() - exercise.html	0.2 KB
015 ROUND() - solution.html	0.3 KB
016 COALESCE() - Preamble.html	0.0 KB
016 COALESCE-Preamble.pdf	595.9 KB
017 IFNULL() and COALESCE().mp4	29.4 MB
017 IFNULL() and COALESCE()_en.srt	8.1 KB
017 IFNULL-and-COALESCE.pdf	732.8 KB
018 Another Example of Using COALESCE().mp4	4.3 MB
018 Another Example of Using COALESCE()_en.srt	2.0 KB
019 Another example of using COALESCE() - exercise 1.html	0.2 KB
020 Another example of using COALESCE() - solution 1.html	0.4 KB
021 Another example of using COALESCE() - exercise 2.html	0.3 KB
022 Another example of using COALESCE() - solution 2.html	0.6 KB
/.../14 - SQL Joins/
001 Introduction to JOINs.mp4	22.7 MB
001 Introduction to JOINs_en.srt	5.4 KB
001 Introduction-to-Joins.pdf	794.5 KB
002 Intro to JOINs - exercise 1.html	0.9 KB
003 Intro to JOINs - solution 1.html	1.7 KB
004 Intro to JOINs - exercise 2.html	1.7 KB
005 INNER JOIN - Part I.mp4	14.5 MB
005 INNER JOIN - Part I_en.srt	7.5 KB
005 INNER-JOIN.pdf	797.1 KB
006 INNER JOIN - Part II.mp4	27.5 MB
006 INNER JOIN - Part II_en.srt	7.1 KB
007 INNER JOIN - Part II - exercise.html	0.1 KB
008 INNER JOIN - Part II - solution.html	0.7 KB
009 A Note on Using Joins.mp4	14.0 MB
009 A Note on Using Joins_en.srt	5.5 KB
010 Duplicate Records.mp4	17.6 MB
010 Duplicate Records_en.srt	5.5 KB
010 Duplicate-Records.pdf	345.1 KB
011 LEFT JOIN - Part I.mp4	21.4 MB
011 LEFT JOIN - Part I_en.srt	6.1 KB
011 LEFT-JOIN.pdf	756.8 KB
012 LEFT JOIN - Part II.mp4	21.8 MB
012 LEFT JOIN - Part II_en.srt	7.6 KB
013 LEFT JOIN - Part II - exercise.html	0.4 KB
014 LEFT JOIN - Part II - solution.html	0.6 KB
015 RIGHT JOIN.mp4	25.7 MB
015 RIGHT JOIN_en.srt	5.3 KB
015 RIGHT-JOIN.pdf	876.8 KB
016 The new and the old join syntax.mp4	15.2 MB
016 The new and the old join syntax_en.srt	5.8 KB
016 The-New-and-the-Old-Join-Syntax.pdf	736.0 KB
017 The new and the old join syntax - exercise.html	0.2 KB
018 The new and the old join syntax - solution.html	1.4 KB
019 JOIN and WHERE Used Together.mp4	19.8 MB
019 JOIN and WHERE Used Together_en.srt	3.7 KB
019 JOIN-and-WHERE-Used-Together.pdf	407.5 KB
020 Important – Prevent Error Code 1055!.html	3.5 KB
021 JOIN and WHERE Used Together - exercise.html	0.2 KB
022 JOIN and WHERE Used Together - solution.html	0.8 KB
023 CROSS JOIN.mp4	32.6 MB
023 CROSS JOIN_en.srt	10.7 KB
023 CROSS-JOIN.pdf	321.2 KB
024 CROSS JOIN - exercise 1.html	0.2 KB
025 CROSS JOIN - solution 1.html	0.5 KB
026 CROSS JOIN - exercise 2.html	0.2 KB
027 CROSS JOIN - solution 2.html	0.6 KB
028 Using Aggregate Functions with Joins.mp4	9.0 MB
028 Using Aggregate Functions with Joins_en.srt	2.9 KB
029 JOIN more than two tables in SQL.mp4	13.3 MB
029 JOIN more than two tables in SQL_en.srt	5.4 KB
029 JOIN-More-Than-Two-Tables-in-SQL.pdf	639.2 KB
030 Join more than two tables in SQL - exercise.html	0.1 KB
031 Join more than two tables in SQL - solution.html	2.9 KB
032 Tips and tricks for joins.mp4	38.6 MB
032 Tips and tricks for joins_en.srt	7.5 KB
032 Tips-and-Tricks-for-Joins.pdf	490.7 KB
033 Tips and tricks for joins - exercise.html	0.1 KB
034 Tips and tricks for joins - solution.html	0.4 KB
035 UNION vs UNION ALL.mp4	16.0 MB
035 UNION vs UNION ALL_en.srt	7.0 KB
035 UNION-vs-UNION-ALL.pdf	843.5 KB
036 UNION vs UNION ALL - exercise.html	0.2 KB
037 UNION vs UNION ALL - solution.html	1.9 KB
/.../15 - SQL Subqueries/
001 SQL Subqueries with IN nested inside WHERE.mp4	12.8 MB
001 SQL Subqueries with IN nested inside WHERE_en.srt	5.4 KB
001 Subqueries-IN-WHERE.pdf	1.1 MB
002 SQL Subqueries with IN nested inside WHERE - exercise.html	0.2 KB
003 SQL Subqueries with IN nested inside WHERE - solution.html	0.8 KB
004 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE.mp4	10.2 MB
004 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE_en.srt	4.6 KB
004 Subqueries-EXISTS-WHERE.pdf	1.1 MB
005 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - exercise.html	0.2 KB
006 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - solution.html	0.9 KB
007 SQL Subqueries nested in SELECT and FROM.mp4	34.4 MB
007 SQL Subqueries nested in SELECT and FROM_en.srt	9.0 KB
007 Subqueries-SELECT-FROM.pdf	413.5 KB
008 SQL Subqueries nested in SELECT and FROM - exercise 1.html	0.2 KB
009 SQL Subqueries nested in SELECT and FROM - solution 1.html	0.4 KB
010 SQL Subqueries nested in SELECT and FROM - exercise 2.html	1.2 KB
011 SQL Subqueries nested in SELECT and FROM - solution 2.html	0.0 KB
011 Subqueries-SELECT-FROM-Solution.sql	1.9 KB
/.../16 - SQL Self Join/
001 SQL-Self-Join.pdf	720.7 KB
001 Self Join.mp4	49.6 MB
001 Self Join_en.srt	9.3 KB
/.../17 - SQL Views/
001 SQL-Views.pdf	1.1 MB
001 Views.mp4	21.7 MB
001 Views_en.srt	8.5 KB
002 Views - exercise.html	0.3 KB
003 Views - solution.html	0.6 KB
/.../18 - Stored routines/
001 Introduction to stored routines.mp4	8.5 MB
001 Introduction to stored routines_en.srt	4.5 KB
001 Introduction-to-Stored-Routines.pdf	747.2 KB
002 The MySQL syntax for stored procedures.mp4	26.4 MB
002 The MySQL syntax for stored procedures_en.srt	6.2 KB
002 The-MySQL-Syntax-for-Stored-Procedures.pdf	932.9 KB
003 Stored procedures - Example - Part I.mp4	8.1 MB
003 Stored procedures - Example - Part I_en.srt	3.7 KB
004 Stored procedures - Example - Part II.mp4	15.1 MB
004 Stored procedures - Example - Part II_en.srt	6.6 KB
005 Stored procedures - Example - Part II - exercise.html	0.1 KB
006 Stored procedures - Example - Part II - solution.html	1.2 KB
007 Another way to create a procedure.mp4	10.6 MB
007 Another way to create a procedure_en.srt	4.0 KB
008 Stored procedures with an input parameter.mp4	20.3 MB
008 Stored procedures with an input parameter_en.srt	8.3 KB
008 Stored-Procedures-with-an-Input-Parameter.pdf	560.9 KB
009 Stored procedures with an output parameter.mp4	13.1 MB
009 Stored procedures with an output parameter_en.srt	4.3 KB
009 Stored-Procedures-with-an-Output-Parameter.pdf	439.7 KB
010 Stored procedures with an output parameter - exercise.html	0.1 KB
011 Stored procedures with an output parameter - solution.html	1.8 KB
012 Variables.mp4	23.6 MB
012 Variables.pdf	735.6 KB
012 Variables_en.srt	8.2 KB
013 Variables - exercise.html	0.3 KB
014 Variables - solution.html	0.2 KB
015 User-Defined-Functions-in-MySQL.pdf	524.3 KB
015 User-defined functions in MySQL.mp4	46.1 MB
015 User-defined functions in MySQL_en.srt	7.8 KB
016 Error Code 1418.html	2.9 KB
017 User-defined functions in MySQL - exercise.html	0.4 KB
018 User-defined functions in MySQL - solution.html	1.8 KB
019 Stored routines - conclusion.mp4	11.9 MB
019 Stored routines - conclusion_en.srt	5.1 KB
019 Stored-Routines-Conclusion.pdf	731.0 KB
/.../19 - Advanced SQL Topics/
001 Types of MySQL Variables - Local Variables.mp4	18.8 MB
001 Types of MySQL Variables - Local Variables_en.srt	6.3 KB
001 Types-of-MySQL-Variables-Local-Variables.pdf	887.1 KB
002 Session Variables.mp4	16.9 MB
002 Session Variables_en.srt	7.1 KB
002 Session-Variables.pdf	1.9 MB
003 Global Variables.mp4	6.9 MB
003 Global Variables_en.srt	2.9 KB
003 Global-Variables.pdf	692.5 KB
004 User-Defined vs System Variables.mp4	31.9 MB
004 User-Defined vs System Variables_en.srt	5.4 KB
004 User-Defined-vs-System-Variables.pdf	716.2 KB
005 MySQL Triggers.html	0.7 KB
005 MySQL-Triggers.pdf	458.3 KB
005 MySQL-Triggers.sql	10.0 KB
006 MySQL Triggers.mp4	45.6 MB
006 MySQL Triggers_en.srt	18.7 KB
007 MySQL Triggers - exercise.html	0.2 KB
008 MySQL Triggers - solution.html	1.3 KB
009 MySQL Indexes.mp4	27.7 MB
009 MySQL Indexes_en.srt	9.1 KB
009 MySQL-Indexes.pdf	1.4 MB
010 MySQL Indexes - exercise 1.html	0.0 KB
011 MySQL Indexes - solution 1.html	0.2 KB
012 MySQL Indexes - exercise 2.html	0.2 KB
013 MySQL Indexes - solution 2.html	0.7 KB
014 The CASE Statement.mp4	23.8 MB
014 The CASE Statement_en.srt	7.4 KB
014 The-CASE-Statement.pdf	309.4 KB
015 The CASE Statement - exercise 1.html	0.4 KB
016 The CASE Statement - solution 1.html	0.7 KB
017 The CASE Statement - exercise 2.html	0.4 KB
018 The CASE Statement - solution 2.html	1.6 KB
019 The CASE Statement - exercise 3.html	0.4 KB
020 The CASE Statement - solution 3.html	0.7 KB
/.../20 - SQL Window Functions/
001 Introduction to MySQL Window Functions.mp4	4.9 MB
001 Introduction to MySQL Window Functions_en.srt	2.8 KB
002 The ROW_NUMBER() Ranking Window Function and the Relevant MySQL Syntax.mp4	62.4 MB
002 The ROW_NUMBER() Ranking Window Function and the Relevant MySQL Syntax_en.srt	12.1 KB
003 The ROW_NUMBER() Ranking Window Function - Exercises.html	0.7 KB
004 The ROW_NUMBER() Ranking Window Function - Solution.html	0.7 KB
005 A Note on Using Several Window Functions in a Query.mp4	10.8 MB
005 A Note on Using Several Window Functions in a Query_en.srt	3.7 KB
006 A Note on Using Several Window Functions - Exercise.html	1.7 KB
007 A Note on Using Several Window Functions - Solution.html	1.2 KB
008 MySQL Window Functions Syntax.mp4	13.5 MB
008 MySQL Window Functions Syntax_en.srt	5.0 KB
009 MySQL Window Functions Syntax - Exercise.html	0.4 KB
010 MySQL Window Functions Syntax - Solution.html	0.4 KB
011 The PARTITION BY Clause VS the GROUP BY Clause.mp4	19.4 MB
011 The PARTITION BY Clause VS the GROUP BY Clause_en.srt	9.1 KB
012 The PARTITION BY Clause VS the GROUP BY Clause - Exercise.html	2.1 KB
013 The PARTITION BY Clause VS the GROUP BY Clause - Solution.html	2.3 KB
014 The MySQL RANK() and DENSE_RANK() Window Functions.mp4	29.2 MB
014 The MySQL RANK() and DENSE_RANK() Window Functions_en.srt	10.4 KB
015 The MySQL RANK() and DENSE_RANK() Window Functions - Exercise.html	1.2 KB
016 The MySQL RANK() and DENSE_RANK() Window Functions - Solution.html	1.7 KB
017 Working with MySQL Ranking Window Functions and Joins Together.mp4	37.2 MB
017 Working with MySQL Ranking Window Functions and Joins Together_en.srt	11.7 KB
018 Working with MySQL Ranking Window Functions and Joins Together - Exercise.html	1.1 KB
019 Working with MySQL Ranking Window Functions and Joins Together - Solution.html	1.4 KB
020 The LAG() and LEAD() Value Window Functions.mp4	37.1 MB
020 The LAG() and LEAD() Value Window Functions_en.srt	11.8 KB
021 The LAG() and LEAD() Value Window Functions - Exercise.html	1.7 KB
022 The LAG() and LEAD() Value Window Functions - Solution.html	1.4 KB
023 MySQL Aggregate Functions in the Context of Window Functions - Part I.mp4	35.8 MB
023 MySQL Aggregate Functions in the Context of Window Functions - Part I_en.srt	9.2 KB
024 MySQL Aggregate Functions in the Context of Window Functions - Part I-Exercise.html	0.3 KB
025 MySQL Aggregate Functions in the Context of Window Functions - Part I-Solution.html	0.7 KB
026 MySQL Aggregate Functions in the Context of Window Functions - Part II.mp4	45.6 MB
026 MySQL Aggregate Functions in the Context of Window Functions - Part II_en.srt	9.7 KB
027 MySQL Aggregate Functions in the Context of Window Functions - Part II-Exercise.html	1.7 KB
028 MySQL Aggregate Functions in the Context of Window Functions - Part II-Solution.html	2.0 KB
/.../21 - SQL Common Table Expressions (CTEs)/
001 MySQL Common Table Expressions - Introduction.mp4	51.6 MB
001 MySQL Common Table Expressions - Introduction_en.srt	9.8 KB
002 An Alternative Solution to the Same Task.mp4	8.9 MB
002 An Alternative Solution to the Same Task_en.srt	2.7 KB
003 An Alternative Solution to the Same Task-Exercise.html	1.2 KB
004 An Alternative Solution to the Same Task-Solution.html	2.6 KB
005 Using Multiple Subclauses in a WITH Clause - Part I.mp4	25.7 MB
005 Using Multiple Subclauses in a WITH Clause - Part I_en.srt	7.8 KB
006 Using Multiple Subclauses in a WITH Clause - Part II.mp4	22.2 MB
006 Using Multiple Subclauses in a WITH Clause - Part II_en.srt	7.5 KB
007 Using Multiple Subclauses in a WITH Clause-Exercise.html	0.7 KB
008 Using Multiple Subclauses in a WITH Clause-Solution.html	2.3 KB
009 Referring to Common Table Expressions in a WITH Clause.mp4	17.5 MB
009 Referring to Common Table Expressions in a WITH Clause_en.srt	5.6 KB
/.../22 - SQL Temporary Tables/
001 MySQL Temporary Tables - Introduction.mp4	11.2 MB
001 MySQL Temporary Tables - Introduction_en.srt	4.4 KB
002 MySQL Temporary Tables in Action.mp4	31.1 MB
002 MySQL Temporary Tables in Action_en.srt	7.2 KB
003 MySQL Temporary Tables in Action-Exercise.html	0.4 KB
004 MySQL Temporary Tables in Action-Solution.html	0.7 KB
005 Other Features of MySQL Temporary Tables.mp4	34.8 MB
005 Other Features of MySQL Temporary Tables_en.srt	9.9 KB
006 Other Features of MySQL Temporary Tables-Exercise.html	1.3 KB
007 Other Features of MySQL Temporary Tables-Solution.html	1.5 KB
/.../23 - Combining SQL and Tableau - Introduction/
001 The Advantages of Software Integration.mp4	59.1 MB
001 The Advantages of Software Integration_en.srt	7.4 KB
002 Why Combining SQL and Tableau is useful.mp4	15.4 MB
002 Why Combining SQL and Tableau is useful_en.srt	6.4 KB
003 Installing Tableau Public.mp4	7.4 MB
003 Installing Tableau Public_en.srt	2.5 KB
004 Loading the 'employees_mod' Database.mp4	17.3 MB
004 Loading the 'employees_mod' Database_en.srt	4.2 KB
004 The-employees-mod-Database.url	0.1 KB
004 employees-mod-db.pdf	132.8 KB
005 Loading the 'employees_mod' Database.html	0.6 KB
005 The-employees-mod-database.url	0.1 KB
005 employees-mod-db.pdf	132.8 KB
external-links.txt	0.2 KB
/.../24 - Combining SQL and Tableau - Task 1/
001 Task 1.mp4	14.5 MB
001 Task 1_en.srt	7.6 KB
002 Task 1 - Text.html	0.1 KB
003 Important clarification!.html	1.4 KB
004 Task 1 SQL Solution.mp4	21.1 MB
004 Task 1 SQL Solution_en.srt	6.1 KB
005 Task 1 SQL Solution - Code.html	0.5 KB
006 Transferring a Dataset from SQL to Tableau.mp4	13.4 MB
006 Transferring a Dataset from SQL to Tableau_en.srt	5.4 KB
007 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I.mp4	16.6 MB
007 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I_en.srt	8.5 KB
008 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II.mp4	20.8 MB
008 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II_en.srt	7.2 KB
/.../25 - Combining SQL and Tableau - Task 2/
001 Task 2.mp4	9.2 MB
001 Task 2_en.srt	5.2 KB
002 Task 2 - Text.html	0.1 KB
003 Task 2 SQL Solution.mp4	12.0 MB
003 Task 2 SQL Solution_en.srt	4.6 KB
004 Task 2 SQL Solution - Code.html	0.7 KB
005 Chart 2 Visualizing and Analyzing the Solution in Tableau.mp4	31.5 MB
005 Chart 2 Visualizing and Analyzing the Solution in Tableau_en.srt	8.2 KB
/.../26 - Combining SQL and Tableau - Task 3/
001 Task 3.mp4	5.2 MB
001 Task 3_en.srt	3.2 KB
002 Task 3 - Text.html	0.2 KB
003 Task 3 SQL Solution.mp4	15.0 MB
003 Task 3 SQL Solution_en.srt	4.2 KB
004 Task 3 SQL Solution - Code.html	0.4 KB
005 Chart 3 Visualizing and Analyzing the Solution in Tableau.mp4	19.7 MB
005 Chart 3 Visualizing and Analyzing the Solution in Tableau_en.srt	6.1 KB
/.../27 - Combining SQL and Tableau - Task 4/
001 Task 4.mp4	9.1 MB
001 Task 4_en.srt	3.7 KB
002 Task 4 - Text.html	0.3 KB
003 Task 4 Solution in SQL.mp4	13.6 MB
003 Task 4 Solution in SQL_en.srt	3.5 KB
004 Task 4 Solution in SQL - Code.html	0.7 KB
005 Chart 4 Visualizing and Analyzing the Solution in Tableau.mp4	9.1 MB
005 Chart 4 Visualizing and Analyzing the Solution in Tableau_en.srt	4.1 KB
/.../28 - Combining SQL and Tableau - Task 5/
001 Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau.mp4	43.8 MB
001 Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau_en.srt	7.3 KB
/.../29 - Practice SQL – 10 Final Query Questions/
001 10-Practice-Final-Query-Questions-SOLUTIONS.sql	7.1 KB
001 10-Practice-SQL-Final-Query-Questions.pdf	570.4 KB
001 Practice SQL – 10 Final Query Questions.html	1.0 KB
/.../30 - BONUS LECTURE/
001 Bonus Lecture Next Steps.html	2.8 KB
/~Get Your Files Here !/
Bonus Resources.txt	0.4 KB
Total files 587