|
Please note that this page does not hosts or makes available any of the listed filenames. You
cannot download any of those files from here.
|
| 001 10-Practice-Final-Query-Questions-SOLUTIONS.sql |
6.91KB |
| 001 10-Practice-SQL-Final-Query-Questions.pdf |
557.06KB |
| 001 Bonus Lecture Next Steps.html |
2.74KB |
| 001 Coding-Techniques-and-Best-Practices.pdf |
1.25MB |
| 001 Coding techniques and best practices - Part I_en.srt |
7.33KB |
| 001 Coding techniques and best practices - Part I.mp4 |
13.78MB |
| 001 COUNT.pdf |
1.07MB |
| 001 COUNT()_en.srt |
5.58KB |
| 001 COUNT().mp4 |
19.12MB |
| 001 Course-Notes-SQL-MySQL-for-Data-Analytics-and-Business-Intelligence.url |
97B |
| 001 Creating a Database - Part I_en.srt |
7.25KB |
| 001 Creating a Database - Part I.mp4 |
20.27MB |
| 001 Creating-a-Database-Part-I.pdf |
793.56KB |
| 001 employees-db.pdf |
178.82KB |
| 001 Installing MySQL_en.srt |
13.09KB |
| 001 Installing MySQL.mp4 |
60.22MB |
| 001 Introduction to JOINs_en.srt |
5.23KB |
| 001 Introduction to JOINs.mp4 |
21.64MB |
| 001 Introduction-to-Joins.pdf |
775.87KB |
| 001 Introduction to MySQL Window Functions_en.srt |
2.75KB |
| 001 Introduction to MySQL Window Functions.mp4 |
4.65MB |
| 001 Introduction to stored routines_en.srt |
4.39KB |
| 001 Introduction to stored routines.mp4 |
8.12MB |
| 001 Introduction-to-Stored-Routines.pdf |
729.67KB |
| 001 Loading the 'employees' database_en.srt |
2.81KB |
| 001 Loading the 'employees' database.mp4 |
8.06MB |
| 001 MySQL Common Table Expressions - Introduction_en.srt |
9.56KB |
| 001 MySQL Common Table Expressions - Introduction.mp4 |
49.22MB |
| 001 MySQL Temporary Tables - Introduction_en.srt |
4.33KB |
| 001 MySQL Temporary Tables - Introduction.mp4 |
10.69MB |
| 001 MySQL-Workbench-Shortcuts.pdf |
515.23KB |
| 001 Practice SQL – 10 Final Query Questions.html |
1019B |
| 001 PRIMARY KEY constraint_en.srt |
7.24KB |
| 001 PRIMARY KEY constraint.mp4 |
17.68MB |
| 001 PRIMARY-KEY-Constraint.pdf |
547.08KB |
| 001 Relational database essentials_en.srt |
6.78KB |
| 001 Relational database essentials.mp4 |
91.73MB |
| 001 sales-db.pdf |
140.67KB |
| 001 SELECT - FROM_en.srt |
6.05KB |
| 001 SELECT - FROM.mp4 |
15.15MB |
| 001 SELECT-FROM.pdf |
571.98KB |
| 001 Self Join_en.srt |
9.09KB |
| 001 Self Join.mp4 |
47.25MB |
| 001 SQL as a declarative language_en.srt |
2.96KB |
| 001 SQL as a declarative language.mp4 |
7.08MB |
| 001 SQL-Self-Join.pdf |
703.86KB |
| 001 SQL Subqueries with IN nested inside WHERE_en.srt |
5.28KB |
| 001 SQL Subqueries with IN nested inside WHERE.mp4 |
12.18MB |
| 001 SQL-Views.pdf |
1.01MB |
| 001 Subqueries-IN-WHERE.pdf |
1.07MB |
| 001 Task 1_en.srt |
7.42KB |
| 001 Task 1.mp4 |
13.81MB |
| 001 Task 2_en.srt |
5.12KB |
| 001 Task 2.mp4 |
8.80MB |
| 001 Task 3_en.srt |
3.16KB |
| 001 Task 3.mp4 |
5.00MB |
| 001 Task 4_en.srt |
3.57KB |
| 001 Task 4.mp4 |
8.67MB |
| 001 Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau_en.srt |
7.11KB |
| 001 Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau.mp4 |
41.73MB |
| 001 TCL's COMMIT and ROLLBACK_en.srt |
3.77KB |
| 001 TCL's COMMIT and ROLLBACK.mp4 |
9.59MB |
| 001 TCLs-COMMIT-and-ROLLBACK.pdf |
580.19KB |
| 001 The Advantages of Software Integration_en.srt |
7.27KB |
| 001 The Advantages of Software Integration.mp4 |
56.38MB |
| 001 The-DELETE-Statement.pdf |
360.60KB |
| 001 The DELETE Statement - Part I_en.srt |
5.14KB |
| 001 The DELETE Statement - Part I.mp4 |
12.75MB |
| 001 The-INSERT-Statement.pdf |
371.78KB |
| 001 The INSERT statement - Part I_en.srt |
7.63KB |
| 001 The INSERT statement - Part I.mp4 |
21.41MB |
| 001 Types of MySQL Variables - Local Variables_en.srt |
6.12KB |
| 001 Types of MySQL Variables - Local Variables.mp4 |
17.90MB |
| 001 Types-of-MySQL-Variables-Local-Variables.pdf |
866.29KB |
| 001 Views_en.srt |
8.31KB |
| 001 Views.mp4 |
20.65MB |
| 001 What does the course cover_en.srt |
6.34KB |
| 001 What does the course cover.mp4 |
73.65MB |
| 002 Additional note – Installing – Visual C.html |
839B |
| 002 An Alternative Solution to the Same Task_en.srt |
2.67KB |
| 002 An Alternative Solution to the Same Task.mp4 |
8.45MB |
| 002 Coding techniques and best practices - Part II_en.srt |
5.12KB |
| 002 Coding techniques and best practices - Part II.mp4 |
11.55MB |
| 002 COUNT() - exercise.html |
111B |
| 002 Databases vs spreadsheets_en.srt |
12.14KB |
| 002 Databases vs spreadsheets.mp4 |
141.25MB |
| 002 Data definition language (DDL)_en.srt |
5.94KB |
| 002 Data definition language (DDL).mp4 |
9.09MB |
| 002 DDL.pdf |
1.26MB |
| 002 Intro to JOINs - exercise 1.html |
921B |
| 002 Loading the 'employees' database.html |
964B |
| 002 MySQL-for-Data-Analytics-and-BI-Lecture-Code.sql |
42.72KB |
| 002 MySQL-for-Data-Analytics-and-BI-Lecture-Code-and-Tasks-Solutions.sql |
60.75KB |
| 002 MySQL Temporary Tables in Action_en.srt |
7.02KB |
| 002 MySQL Temporary Tables in Action.mp4 |
29.65MB |
| 002 PRIMARY KEY constraint - exercise.html |
1.52KB |
| 002 SELECT - FROM - exercise.html |
160B |
| 002 Session Variables_en.srt |
6.93KB |
| 002 Session Variables.mp4 |
16.13MB |
| 002 Session-Variables.pdf |
1.82MB |
| 002 SQL-FAQ.pdf |
753.12KB |
| 002 SQL-FAQ.pdf |
1.16MB |
| 002 SQL files.html |
1.26KB |
| 002 SQL Subqueries with IN nested inside WHERE - exercise.html |
162B |
| 002 Task 1 - Text.html |
147B |
| 002 Task 2 - Text.html |
137B |
| 002 Task 3 - Text.html |
167B |
| 002 Task 4 - Text.html |
327B |
| 002 The DELETE Statement - Part II_en.srt |
1.80KB |
| 002 The DELETE Statement - Part II.mp4 |
5.58MB |
| 002 The-employees-database.url |
84B |
| 002 The INSERT statement - Part II_en.srt |
2.92KB |
| 002 The INSERT statement - Part II.mp4 |
7.32MB |
| 002 The MySQL syntax for stored procedures_en.srt |
6.02KB |
| 002 The MySQL syntax for stored procedures.mp4 |
25.16MB |
| 002 The-MySQL-Syntax-for-Stored-Procedures.pdf |
911.08KB |
| 002 The ROW_NUMBER() Ranking Window Function and the Relevant MySQL Syntax_en.srt |
11.84KB |
| 002 The ROW_NUMBER() Ranking Window Function and the Relevant MySQL Syntax.mp4 |
59.47MB |
| 002 The-UPDATE-Statement.pdf |
455.86KB |
| 002 The UPDATE Statement - Part I_en.srt |
3.82KB |
| 002 The UPDATE Statement - Part I.mp4 |
9.72MB |
| 002 Views - exercise.html |
284B |
| 002 Why Combining SQL and Tableau is useful_en.srt |
6.29KB |
| 002 Why Combining SQL and Tableau is useful.mp4 |
14.71MB |
| 002 Why SQL_en.srt |
4.57KB |
| 002 Why SQL.mp4 |
58.06MB |
| 003 An Alternative Solution to the Same Task-Exercise.html |
1.15KB |
| 003 COUNT() - solution.html |
212B |
| 003 Creating a Database - Part I - exercise.html |
145B |
| 003 Database terminology_en.srt |
6.25KB |
| 003 Database terminology.mp4 |
13.34MB |
| 003 Global Variables_en.srt |
2.80KB |
| 003 Global Variables.mp4 |
6.57MB |
| 003 Global-Variables.pdf |
676.25KB |
| 003 Important clarification!.html |
1.38KB |
| 003 Installing MySQL on macOS and Unix systems.html |
2.63KB |
| 003 Installing Tableau Public_en.srt |
2.45KB |
| 003 Installing Tableau Public.mp4 |
7.10MB |
| 003 Intro to JOINs - solution 1.html |
1.64KB |
| 003 MySQL Temporary Tables in Action-Exercise.html |
372B |
| 003 PRIMARY KEY constraint - solution.html |
2.64KB |
| 003 ROLLBACK; ARTICLE.html |
1.31KB |
| 003 SELECT - FROM - solution.html |
457B |
| 003 SQL keywords_en.srt |
1.74KB |
| 003 SQL keywords.mp4 |
2.46MB |
| 003 SQL-Keywords.pdf |
533.09KB |
| 003 SQL Subqueries with IN nested inside WHERE - solution.html |
825B |
| 003 Stored procedures - Example - Part I_en.srt |
3.63KB |
| 003 Stored procedures - Example - Part I.mp4 |
7.68MB |
| 003 Task 2 SQL Solution_en.srt |
4.48KB |
| 003 Task 2 SQL Solution.mp4 |
11.46MB |
| 003 Task 3 SQL Solution_en.srt |
4.07KB |
| 003 Task 3 SQL Solution.mp4 |
14.30MB |
| 003 Task 4 Solution in SQL_en.srt |
3.44KB |
| 003 Task 4 Solution in SQL.mp4 |
12.98MB |
| 003 The DELETE Statement – Part II - exercise.html |
73B |
| 003 The INSERT statement - exercise 1.html |
1.42KB |
| 003 The ROW_NUMBER() Ranking Window Function - Exercises.html |
684B |
| 003 Views - solution.html |
590B |
| 003 Why MySQL_en.srt |
2.78KB |
| 003 Why MySQL.mp4 |
23.71MB |
| 004 An Alternative Solution to the Same Task-Solution.html |
2.54KB |
| 004 Creating a Database - Part I - solution.html |
126B |
| 004 Data manipulation language (DML)_en.srt |
6.14KB |
| 004 Data manipulation language (DML).mp4 |
10.70MB |
| 004 DML.pdf |
913.21KB |
| 004 employees-mod-db.pdf |
129.65KB |
| 004 FOREIGN-KEY-Constraint.pdf |
1.08MB |
| 004 FOREIGN KEY constraint - Part I_en.srt |
6.90KB |
| 004 FOREIGN KEY constraint - Part I.mp4 |
17.74MB |
| 004 Introduction to databases_en.srt |
6.82KB |
| 004 Introduction to databases.mp4 |
83.52MB |
| 004 Intro to JOINs - exercise 2.html |
1.65KB |
| 004 Loading the 'employees_mod' Database_en.srt |
4.10KB |
| 004 Loading the 'employees_mod' Database.mp4 |
16.49MB |
| 004 MySQL Temporary Tables in Action-Solution.html |
676B |
| 004 Relational schemas - Primary key_en.srt |
7.30KB |
| 004 Relational schemas - Primary key.mp4 |
14.38MB |
| 004 Relational-Schemas-Primary-Key.pdf |
1.26MB |
| 004 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE_en.srt |
4.46KB |
| 004 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE.mp4 |
9.76MB |
| 004 Stored procedures - Example - Part II_en.srt |
6.42KB |
| 004 Stored procedures - Example - Part II.mp4 |
14.41MB |
| 004 Subqueries-EXISTS-WHERE.pdf |
1.00MB |
| 004 SUM.pdf |
494.07KB |
| 004 SUM()_en.srt |
2.02KB |
| 004 SUM().mp4 |
3.81MB |
| 004 Task 1 SQL Solution_en.srt |
6.00KB |
| 004 Task 1 SQL Solution.mp4 |
20.11MB |
| 004 Task 2 SQL Solution - Code.html |
665B |
| 004 Task 3 SQL Solution - Code.html |
444B |
| 004 Task 4 Solution in SQL - Code.html |
653B |
| 004 The Client-Server Model.html |
30B |
| 004 The-Client-Server-Model.pdf |
556.90KB |
| 004 The DELETE Statement – Part II - solution.html |
158B |
| 004 The-employees-mod-Database.url |
88B |
| 004 The INSERT statement - solution 1.html |
1.36KB |
| 004 The ROW_NUMBER() Ranking Window Function - Solution.html |
704B |
| 004 The UPDATE Statement - Part II_en.srt |
3.71KB |
| 004 The UPDATE Statement - Part II.mp4 |
8.74MB |
| 004 User-Defined vs System Variables_en.srt |
5.31KB |
| 004 User-Defined vs System Variables.mp4 |
30.40MB |
| 004 User-Defined-vs-System-Variables.pdf |
699.41KB |
| 004 WHERE_en.srt |
3.23KB |
| 004 WHERE.mp4 |
16.98MB |
| 004 WHERE.pdf |
413.79KB |
| 005 A Note on Using Several Window Functions in a Query_en.srt |
3.62KB |
| 005 A Note on Using Several Window Functions in a Query.mp4 |
10.31MB |
| 005 Chart 2 Visualizing and Analyzing the Solution in Tableau_en.srt |
8.02KB |
| 005 Chart 2 Visualizing and Analyzing the Solution in Tableau.mp4 |
30.02MB |
| 005 Chart 3 Visualizing and Analyzing the Solution in Tableau_en.srt |
5.95KB |
| 005 Chart 3 Visualizing and Analyzing the Solution in Tableau.mp4 |
18.79MB |
| 005 Chart 4 Visualizing and Analyzing the Solution in Tableau_en.srt |
3.97KB |
| 005 Chart 4 Visualizing and Analyzing the Solution in Tableau.mp4 |
8.67MB |
| 005 Creating a Database - Part II_en.srt |
3.28KB |
| 005 Creating a Database - Part II.mp4 |
6.03MB |
| 005 Data control language (DCL)_en.srt |
6.68KB |
| 005 Data control language (DCL).mp4 |
13.55MB |
| 005 DCL.pdf |
682.67KB |
| 005 DROP vs TRUNCATE vs DELETE_en.srt |
4.26KB |
| 005 DROP vs TRUNCATE vs DELETE.mp4 |
7.63MB |
| 005 DROP-vs-TRUNCATE-vs-DELETE.pdf |
1.02MB |
| 005 employees-mod-db.pdf |
129.65KB |
| 005 FOREIGN KEY constraint - Part II_en.srt |
6.15KB |
| 005 FOREIGN KEY constraint - Part II.mp4 |
21.33MB |
| 005 INNER-JOIN.pdf |
778.46KB |
| 005 INNER JOIN - Part I_en.srt |
7.33KB |
| 005 INNER JOIN - Part I.mp4 |
13.80MB |
| 005 Loading the 'employees_mod' Database.html |
602B |
| 005 MySQL Triggers.html |
743B |
| 005 MySQL-Triggers.pdf |
447.52KB |
| 005 MySQL-Triggers.sql |
9.73KB |
| 005 Other Features of MySQL Temporary Tables_en.srt |
9.62KB |
| 005 Other Features of MySQL Temporary Tables.mp4 |
33.16MB |
| 005 Relational schemas - Foreign key_en.srt |
7.13KB |
| 005 Relational schemas - Foreign key.mp4 |
11.85MB |
| 005 Relational-Schemas-Foreign-Key.pdf |
960.36KB |
| 005 Setting up a connection_en.srt |
3.62KB |
| 005 Setting up a connection.mp4 |
6.43MB |
| 005 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - exercise.html |
179B |
| 005 Stored procedures - Example - Part II - exercise.html |
120B |
| 005 SUM() - exercise.html |
127B |
| 005 Task 1 SQL Solution - Code.html |
481B |
| 005 The-employees-mod-database.url |
88B |
| 005 The INSERT statement - exercise 2.html |
364B |
| 005 The UPDATE Statement – Part II - exercise.html |
156B |
| 005 Using Multiple Subclauses in a WITH Clause - Part I_en.srt |
7.59KB |
| 005 Using Multiple Subclauses in a WITH Clause - Part I.mp4 |
24.55MB |
| 005 WHERE - exercise.html |
77B |
| 006 A Note on Using Several Window Functions - Exercise.html |
1.70KB |
| 006 Creating a Database - Part II - exercise.html |
57B |
| 006 FOREIGN KEY constraint - Part II - exercise.html |
182B |
| 006 INNER JOIN - Part II_en.srt |
6.93KB |
| 006 INNER JOIN - Part II.mp4 |
26.20MB |
| 006 MySQL Triggers_en.srt |
18.27KB |
| 006 MySQL Triggers.mp4 |
43.46MB |
| 006 Other Features of MySQL Temporary Tables-Exercise.html |
1.22KB |
| 006 Read me!!!.html |
1018B |
| 006 Relational schemas - Unique key and null values_en.srt |
4.50KB |
| 006 Relational schemas - Unique key and null values.mp4 |
7.00MB |
| 006 Relational-Schemas-Unique-Key-and-Null-Values.pdf |
773.82KB |
| 006 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - solution.html |
944B |
| 006 Stored procedures - Example - Part II - solution.html |
1.14KB |
| 006 SUM() - solution.html |
311B |
| 006 TCL.pdf |
965.74KB |
| 006 The INSERT statement - solution 2.html |
1.24KB |
| 006 The UPDATE Statement – Part II - solution.html |
279B |
| 006 Transaction control language (TCL)_en.srt |
4.27KB |
| 006 Transaction control language (TCL).mp4 |
9.12MB |
| 006 Transferring a Dataset from SQL to Tableau_en.srt |
5.28KB |
| 006 Transferring a Dataset from SQL to Tableau.mp4 |
12.74MB |
| 006 Using Multiple Subclauses in a WITH Clause - Part II_en.srt |
7.31KB |
| 006 Using Multiple Subclauses in a WITH Clause - Part II.mp4 |
21.19MB |
| 006 WHERE - solution.html |
311B |
| 007 AND_en.srt |
2.86KB |
| 007 AND.mp4 |
5.67MB |
| 007 AND.pdf |
489.72KB |
| 007 A Note on Using Several Window Functions - Solution.html |
1.19KB |
| 007 Another way to create a procedure_en.srt |
3.94KB |
| 007 Another way to create a procedure.mp4 |
10.13MB |
| 007 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I_en.srt |
8.26KB |
| 007 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I.mp4 |
15.87MB |
| 007 Creating a Database - Part II - solution.html |
34B |
| 007 FOREIGN KEY constraint - Part II - solution.html |
208B |
| 007 INNER JOIN - Part II - exercise.html |
141B |
| 007 Inserting data INTO a new table_en.srt |
4.88KB |
| 007 Inserting data INTO a new table.mp4 |
11.72MB |
| 007 Inserting-Data-INTO-a-New-Table.pdf |
302.31KB |
| 007 MIN() and MAX()_en.srt |
1.51KB |
| 007 MIN() and MAX().mp4 |
3.52MB |
| 007 MIN-and-MAX.pdf |
284.85KB |
| 007 MySQL Triggers - exercise.html |
191B |
| 007 New Authentication Plugin - Creating a New User_en.srt |
7.39KB |
| 007 New Authentication Plugin - Creating a New User.mp4 |
19.07MB |
| 007 Other Features of MySQL Temporary Tables-Solution.html |
1.48KB |
| 007 Relationships_en.srt |
6.67KB |
| 007 Relationships.mp4 |
13.22MB |
| 007 Relationships.pdf |
1.36MB |
| 007 SQL Subqueries nested in SELECT and FROM_en.srt |
8.78KB |
| 007 SQL Subqueries nested in SELECT and FROM.mp4 |
32.84MB |
| 007 Subqueries-SELECT-FROM.pdf |
403.81KB |
| 007 Using Multiple Subclauses in a WITH Clause-Exercise.html |
686B |
| 008 AND - exercise.html |
82B |
| 008 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II_en.srt |
7.05KB |
| 008 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II.mp4 |
19.84MB |
| 008 INNER JOIN - Part II - solution.html |
689B |
| 008 Inserting Data INTO a New Table - exercise.html |
163B |
| 008 Introduction to data types_en.srt |
3.04KB |
| 008 Introduction to data types.mp4 |
4.81MB |
| 008 Introduction-to-Data-Types.pdf |
496.65KB |
| 008 Introduction to the MySQL interface_en.srt |
6.63KB |
| 008 Introduction to the MySQL interface.mp4 |
14.08MB |
| 008 MIN() and MAX() - exercise.html |
130B |
| 008 MySQL Triggers - solution.html |
1.31KB |
| 008 MySQL Window Functions Syntax_en.srt |
4.89KB |
| 008 MySQL Window Functions Syntax.mp4 |
12.88MB |
| 008 SQL Subqueries nested in SELECT and FROM - exercise 1.html |
198B |
| 008 Stored procedures with an input parameter_en.srt |
8.12KB |
| 008 Stored procedures with an input parameter.mp4 |
19.40MB |
| 008 Stored-Procedures-with-an-Input-Parameter.pdf |
547.71KB |
| 008 UNIQUE Constraint_en.srt |
5.75KB |
| 008 UNIQUE Constraint.mp4 |
13.49MB |
| 008 UNIQUE-Constraint.pdf |
726.56KB |
| 008 Using Multiple Subclauses in a WITH Clause-Solution.html |
2.23KB |
| 009 AND - solution.html |
413B |
| 009 A Note on Using Joins_en.srt |
5.37KB |
| 009 A Note on Using Joins.mp4 |
13.32MB |
| 009 Inserting Data INTO a New Table - solution.html |
85B |
| 009 MIN() and MAX() - solution.html |
535B |
| 009 MySQL Indexes_en.srt |
8.86KB |
| 009 MySQL Indexes.mp4 |
26.42MB |
| 009 MySQL-Indexes.pdf |
1.29MB |
| 009 MySQL Window Functions Syntax - Exercise.html |
447B |
| 009 Referring to Common Table Expressions in a WITH Clause_en.srt |
5.51KB |
| 009 Referring to Common Table Expressions in a WITH Clause.mp4 |
16.68MB |
| 009 SQL Subqueries nested in SELECT and FROM - solution 1.html |
366B |
| 009 Stored procedures with an output parameter_en.srt |
4.24KB |
| 009 Stored procedures with an output parameter.mp4 |
12.54MB |
| 009 Stored-Procedures-with-an-Output-Parameter.pdf |
429.39KB |
| 009 String data types_en.srt |
6.57KB |
| 009 String data types.mp4 |
11.15MB |
| 009 String-Data-Types.pdf |
443.28KB |
| 009 UNIQUE Constraint - exercise.html |
1.55KB |
| 010 AVG.pdf |
442.81KB |
| 010 AVG()_en.srt |
2.69KB |
| 010 AVG().mp4 |
6.60MB |
| 010 DEFAULT Constraint_en.srt |
6.77KB |
| 010 DEFAULT Constraint.mp4 |
14.72MB |
| 010 DEFAULT-Constraint.pdf |
514.90KB |
| 010 Duplicate Records_en.srt |
5.40KB |
| 010 Duplicate Records.mp4 |
16.78MB |
| 010 Duplicate-Records.pdf |
336.98KB |
| 010 Integers_en.srt |
5.30KB |
| 010 Integers.mp4 |
15.27MB |
| 010 Integers.pdf |
656.05KB |
| 010 MySQL Indexes - exercise 1.html |
34B |
| 010 MySQL Window Functions Syntax - Solution.html |
352B |
| 010 OR_en.srt |
4.12KB |
| 010 OR.mp4 |
10.59MB |
| 010 OR.pdf |
351.28KB |
| 010 SQL Subqueries nested in SELECT and FROM - exercise 2.html |
1.17KB |
| 010 Stored procedures with an output parameter - exercise.html |
146B |
| 011 AVG() - exercise.html |
112B |
| 011 DEFAULT Constraint - exercise.html |
444B |
| 011 Fixed and floating-point data types_en.srt |
7.71KB |
| 011 Fixed and floating-point data types.mp4 |
18.64MB |
| 011 Fixed-and-Floating-Point-Data-Types.pdf |
701.70KB |
| 011 LEFT-JOIN.pdf |
739.04KB |
| 011 LEFT JOIN - Part I_en.srt |
5.95KB |
| 011 LEFT JOIN - Part I.mp4 |
20.44MB |
| 011 MySQL Indexes - solution 1.html |
169B |
| 011 OR - exercise.html |
85B |
| 011 SQL Subqueries nested in SELECT and FROM - solution 2.html |
15B |
| 011 Stored procedures with an output parameter - solution.html |
1.72KB |
| 011 Subqueries-SELECT-FROM-Solution.sql |
1.85KB |
| 011 The PARTITION BY Clause VS the GROUP BY Clause_en.srt |
8.87KB |
| 011 The PARTITION BY Clause VS the GROUP BY Clause.mp4 |
18.53MB |
| 012 AVG() - solution.html |
343B |
| 012 DEFAULT Constraint - solution.html |
488B |
| 012 LEFT JOIN - Part II_en.srt |
7.38KB |
| 012 LEFT JOIN - Part II.mp4 |
20.78MB |
| 012 MySQL Indexes - exercise 2.html |
247B |
| 012 OR - solution.html |
326B |
| 012 Other useful data types_en.srt |
7.84KB |
| 012 Other useful data types.mp4 |
13.96MB |
| 012 Other-Useful-Data-Types.pdf |
729.04KB |
| 012 The PARTITION BY Clause VS the GROUP BY Clause - Exercise.html |
2.05KB |
| 012 Variables_en.srt |
7.99KB |
| 012 Variables.mp4 |
22.46MB |
| 012 Variables.pdf |
718.33KB |
| 013 Creating a table_en.srt |
7.22KB |
| 013 Creating a table.mp4 |
16.35MB |
| 013 Creating-a-Table.pdf |
542.97KB |
| 013 LEFT JOIN - Part II - exercise.html |
429B |
| 013 MySQL Indexes - solution 2.html |
735B |
| 013 NOT-NULL-Constraint.pdf |
680.16KB |
| 013 NOT NULL Constraint - Part I_en.srt |
7.10KB |
| 013 NOT NULL Constraint - Part I.mp4 |
34.63MB |
| 013 Operator precedence_en.srt |
4.39KB |
| 013 Operator precedence.mp4 |
10.22MB |
| 013 Operator-Precedence.pdf |
420.38KB |
| 013 ROUND.pdf |
334.72KB |
| 013 ROUND()_en.srt |
2.59KB |
| 013 ROUND().mp4 |
6.01MB |
| 013 The PARTITION BY Clause VS the GROUP BY Clause - Solution.html |
2.20KB |
| 013 Variables - exercise.html |
295B |
| 014 Creating a table - exercise.html |
368B |
| 014 LEFT JOIN - Part II - solution.html |
593B |
| 014 NOT NULL Constraint - Part I - exercise.html |
163B |
| 014 Operator precedence - exercise.html |
92B |
| 014 ROUND() - exercise.html |
155B |
| 014 The CASE Statement_en.srt |
7.27KB |
| 014 The CASE Statement.mp4 |
22.73MB |
| 014 The-CASE-Statement.pdf |
302.12KB |
| 014 The MySQL RANK() and DENSE_RANK() Window Functions_en.srt |
10.12KB |
| 014 The MySQL RANK() and DENSE_RANK() Window Functions.mp4 |
27.87MB |
| 014 Variables - solution.html |
170B |
| 015 Creating a table - solution.html |
697B |
| 015 NOT NULL Constraint - Part I - solution.html |
357B |
| 015 Operator precedence - solution.html |
339B |
| 015 RIGHT JOIN_en.srt |
5.19KB |
| 015 RIGHT JOIN.mp4 |
24.52MB |
| 015 RIGHT-JOIN.pdf |
856.26KB |
| 015 ROUND() - solution.html |
321B |
| 015 The CASE Statement - exercise 1.html |
360B |
| 015 The MySQL RANK() and DENSE_RANK() Window Functions - Exercise.html |
1.18KB |
| 015 User-defined functions in MySQL_en.srt |
7.58KB |
| 015 User-defined functions in MySQL.mp4 |
43.93MB |
| 015 User-Defined-Functions-in-MySQL.pdf |
511.99KB |
| 016 COALESCE() - Preamble.html |
28B |
| 016 COALESCE-Preamble.pdf |
581.89KB |
| 016 Error Code 1418.html |
2.80KB |
| 016 IN - NOT IN_en.srt |
4.22KB |
| 016 IN - NOT IN.mp4 |
9.85MB |
| 016 NOT NULL Constraint - Part II_en.srt |
2.72KB |
| 016 NOT NULL Constraint - Part II.mp4 |
4.26MB |
| 016 The CASE Statement - solution 1.html |
697B |
| 016 The MySQL RANK() and DENSE_RANK() Window Functions - Solution.html |
1.63KB |
| 016 The new and the old join syntax_en.srt |
5.70KB |
| 016 The new and the old join syntax.mp4 |
14.49MB |
| 016 The-New-and-the-Old-Join-Syntax.pdf |
718.72KB |
| 016 Using databases and tables_en.srt |
3.45KB |
| 016 Using databases and tables.mp4 |
9.15MB |
| 016 Using-Databases-and-Tables.pdf |
529.82KB |
| 017 IFNULL() and COALESCE()_en.srt |
7.95KB |
| 017 IFNULL() and COALESCE().mp4 |
28.08MB |
| 017 IFNULL-and-COALESCE.pdf |
715.62KB |
| 017 IN - NOT IN - exercise 1.html |
122B |
| 017 The CASE Statement - exercise 2.html |
377B |
| 017 The new and the old join syntax - exercise.html |
189B |
| 017 User-defined functions in MySQL - exercise.html |
433B |
| 017 Using databases and tables - exercise.html |
256B |
| 017 Working with MySQL Ranking Window Functions and Joins Together_en.srt |
11.47KB |
| 017 Working with MySQL Ranking Window Functions and Joins Together.mp4 |
35.48MB |
| 018 Another Example of Using COALESCE()_en.srt |
1.99KB |
| 018 Another Example of Using COALESCE().mp4 |
4.13MB |
| 018 IN - NOT IN - solution 1.html |
324B |
| 018 The CASE Statement - solution 2.html |
1.57KB |
| 018 The new and the old join syntax - solution.html |
1.36KB |
| 018 User-defined functions in MySQL - solution.html |
1.78KB |
| 018 Using databases and tables - solution.html |
86B |
| 018 Working with MySQL Ranking Window Functions and Joins Together - Exercise.html |
1.06KB |
| 019 Additional notes on using tables_en.srt |
2.81KB |
| 019 Additional notes on using tables.mp4 |
7.23MB |
| 019 Additional-Notes-on-Using-Tables.pdf |
382.34KB |
| 019 Another example of using COALESCE() - exercise 1.html |
208B |
| 019 IN - NOT IN - exercise 2.html |
112B |
| 019 JOIN and WHERE Used Together_en.srt |
3.60KB |
| 019 JOIN and WHERE Used Together.mp4 |
18.88MB |
| 019 JOIN-and-WHERE-Used-Together.pdf |
397.99KB |
| 019 Stored routines - conclusion_en.srt |
4.99KB |
| 019 Stored routines - conclusion.mp4 |
11.37MB |
| 019 Stored-Routines-Conclusion.pdf |
713.87KB |
| 019 The CASE Statement - exercise 3.html |
377B |
| 019 Working with MySQL Ranking Window Functions and Joins Together - Solution.html |
1.41KB |
| 020 Additional notes on using tables - exercise.html |
259B |
| 020 Another example of using COALESCE() - solution 1.html |
407B |
| 020 Important – Prevent Error Code 1055!.html |
3.39KB |
| 020 IN - NOT IN - solution 2.html |
319B |
| 020 The CASE Statement - solution 3.html |
708B |
| 020 The LAG() and LEAD() Value Window Functions_en.srt |
11.57KB |
| 020 The LAG() and LEAD() Value Window Functions.mp4 |
35.34MB |
| 021 Another example of using COALESCE() - exercise 2.html |
302B |
| 021 JOIN and WHERE Used Together - exercise.html |
157B |
| 021 LIKE - NOT LIKE_en.srt |
4.59KB |
| 021 LIKE - NOT LIKE.mp4 |
10.89MB |
| 021 The LAG() and LEAD() Value Window Functions - Exercise.html |
1.65KB |
| 022 Another example of using COALESCE() - solution 2.html |
610B |
| 022 JOIN and WHERE Used Together - solution.html |
768B |
| 022 LIKE - NOT LIKE - exercise.html |
431B |
| 022 The LAG() and LEAD() Value Window Functions - Solution.html |
1.33KB |
| 023 CROSS JOIN_en.srt |
10.44KB |
| 023 CROSS JOIN.mp4 |
31.13MB |
| 023 CROSS-JOIN.pdf |
313.67KB |
| 023 LIKE - NOT LIKE - solution.html |
1.12KB |
| 023 MySQL Aggregate Functions in the Context of Window Functions - Part I_en.srt |
8.97KB |
| 023 MySQL Aggregate Functions in the Context of Window Functions - Part I.mp4 |
34.18MB |
| 024 CROSS JOIN - exercise 1.html |
150B |
| 024 MySQL Aggregate Functions in the Context of Window Functions - Part I-Exercise.html |
342B |
| 024 Wildcard characters_en.srt |
2.52KB |
| 024 Wildcard characters.mp4 |
3.72MB |
| 024 Wildcard-Characters.pdf |
406.42KB |
| 025 CROSS JOIN - solution 1.html |
520B |
| 025 MySQL Aggregate Functions in the Context of Window Functions - Part I-Solution.html |
710B |
| 025 Wildcard characters - exercise.html |
207B |
| 026 CROSS JOIN - exercise 2.html |
163B |
| 026 MySQL Aggregate Functions in the Context of Window Functions - Part II_en.srt |
9.50KB |
| 026 MySQL Aggregate Functions in the Context of Window Functions - Part II.mp4 |
43.52MB |
| 026 Wildcard characters - solution.html |
629B |
| 027 BETWEEN - AND_en.srt |
2.60KB |
| 027 BETWEEN - AND.mp4 |
5.48MB |
| 027 BETWEEN-AND.pdf |
655.54KB |
| 027 CROSS JOIN - solution 2.html |
558B |
| 027 MySQL Aggregate Functions in the Context of Window Functions - Part II-Exercise.html |
1.63KB |
| 028 BETWEEN - AND - exercise.html |
317B |
| 028 MySQL Aggregate Functions in the Context of Window Functions - Part II-Solution.html |
1.96KB |
| 028 Using Aggregate Functions with Joins_en.srt |
2.81KB |
| 028 Using Aggregate Functions with Joins.mp4 |
8.62MB |
| 029 BETWEEN - AND- solution.html |
1.47KB |
| 029 JOIN more than two tables in SQL_en.srt |
5.25KB |
| 029 JOIN more than two tables in SQL.mp4 |
12.65MB |
| 029 JOIN-More-Than-Two-Tables-in-SQL.pdf |
624.23KB |
| 030 IS NOT NULL - IS NULL_en.srt |
2.03KB |
| 030 IS NOT NULL - IS NULL.mp4 |
4.54MB |
| 030 IS-NOT-NULL-IS-NULL.pdf |
357.26KB |
| 030 Join more than two tables in SQL - exercise.html |
106B |
| 031 IS NOT NULL - IS NULL - exercise.html |
85B |
| 031 Join more than two tables in SQL - solution.html |
2.80KB |
| 032 IS NOT NULL - IS NULL - solution.html |
304B |
| 032 Tips and tricks for joins_en.srt |
7.31KB |
| 032 Tips and tricks for joins.mp4 |
36.77MB |
| 032 Tips-and-Tricks-for-Joins.pdf |
479.19KB |
| 033 Other comparison operators_en.srt |
5.53KB |
| 033 Other comparison operators.mp4 |
16.33MB |
| 033 Other-Comparison-Operators.pdf |
340.07KB |
| 033 Tips and tricks for joins - exercise.html |
87B |
| 034 Other comparison operators - exercise.html |
280B |
| 034 Tips and tricks for joins - solution.html |
432B |
| 035 Other comparison operators - solution.html |
794B |
| 035 UNION vs UNION ALL_en.srt |
6.82KB |
| 035 UNION vs UNION ALL.mp4 |
15.25MB |
| 035 UNION-vs-UNION-ALL.pdf |
823.75KB |
| 036 SELECT DISTINCT_en.srt |
2.68KB |
| 036 SELECT DISTINCT.mp4 |
7.65MB |
| 036 SELECT-DISTINCT.pdf |
382.83KB |
| 036 UNION vs UNION ALL - exercise.html |
177B |
| 037 SELECT DISTINCT - exercise.html |
344B |
| 037 UNION vs UNION ALL - solution.html |
1.85KB |
| 038 SELECT DISTINCT - solution.html |
258B |
| 039 Introduction to aggregate functions_en.srt |
6.79KB |
| 039 Introduction to aggregate functions.mp4 |
14.59MB |
| 039 Introduction-to-Aggregate-Functions.pdf |
737.29KB |
| 040 Introduction to aggregate functions - exercise.html |
256B |
| 041 Introduction to aggregate functions - solution.html |
538B |
| 042 ORDER BY_en.srt |
4.51KB |
| 042 ORDER BY.mp4 |
12.05MB |
| 043 ORDER BY - exercise.html |
94B |
| 044 ORDER BY - solution.html |
252B |
| 045 GROUP BY_en.srt |
7.41KB |
| 045 GROUP BY.mp4 |
24.30MB |
| 045 GROUP-BY.pdf |
455.07KB |
| 046 Using Aliases (AS)_en.srt |
2.85KB |
| 046 Using Aliases (AS).mp4 |
6.76MB |
| 047 Using Aliases (AS) - exercise.html |
338B |
| 048 Using Aliases (AS) - solution.html |
458B |
| 049 HAVING_en.srt |
4.38KB |
| 049 HAVING.mp4 |
12.66MB |
| 049 HAVING.pdf |
463.17KB |
| 050 HAVING - exercise.html |
1.05KB |
| 051 HAVING - solution.html |
731B |
| 052 WHERE-vs-HAVING.pdf |
767.60KB |
| 052 WHERE vs HAVING- Part I_en.srt |
5.07KB |
| 052 WHERE vs HAVING- Part I.mp4 |
27.24MB |
| 053 WHERE vs HAVING- Part II_en.srt |
3.99KB |
| 053 WHERE vs HAVING- Part II.mp4 |
17.84MB |
| 054 WHERE vs HAVING - Part II - exercise.html |
209B |
| 055 WHERE vs HAVING - Part II - solution.html |
468B |
| 056 LIMIT_en.srt |
6.39KB |
| 056 LIMIT.mp4 |
18.67MB |
| 056 LIMIT.pdf |
297.28KB |
| 057 LIMIT - exercise.html |
63B |
| 058 LIMIT - solution.html |
232B |
| Bonus Resources.txt |
386B |
| external-links.txt |
150B |
| external-links.txt |
92B |
| external-links.txt |
200B |
| Get Bonus Downloads Here.url |
183B |