Site NEWS just posted! Please click here to check it out!

Udemy SQL MySQL for Data Analytics and Business Intelligence FreeCourseWeb

Torrent Info
Category Other
Added Thursday 17th August 2023 04:35:04 PM (3 years ago)
Size2.9 GB
Peers5 Peers (5 Seeders and 0 leechers) update
Downloaded28 times
UploaderFreeCourseWeb  Thank You  (0) Report Torrent 00/0
CommentsNone
Uploader Comments
None
Tags English
Seeders5
Leechers0
Torrent Screenshots

There are no images posted for this torrent.

NFO
None
Torrent Files (587)
FilenameSize
Get Bonus Downloads Here.url183 bytes
001 What does the course cover.mp473.6 MB
001 What does the course cover_en.srt6.3 KB
002 SQL-FAQ.pdf753.1 KB
002 Why SQL.mp458.1 MB
002 Why SQL_en.srt4.6 KB
003 Why MySQL.mp423.7 MB
003 Why MySQL_en.srt2.8 KB
004 Introduction to databases.mp483.5 MB
004 Introduction to databases_en.srt6.8 KB
001 Course-Notes-SQL-MySQL-for-Data-Analytics-and-Business-Intelligence.url97 bytes
001 SQL as a declarative language.mp47.1 MB
001 SQL as a declarative language_en.srt3.0 KB
002 DDL.pdf1.3 MB
002 Data definition language (DDL).mp49.1 MB
002 Data definition language (DDL)_en.srt5.9 KB
003 SQL keywords.mp42.5 MB
003 SQL keywords_en.srt1.7 KB
003 SQL-Keywords.pdf533.1 KB
004 DML.pdf913.2 KB
004 Data manipulation language (DML).mp410.7 MB
004 Data manipulation language (DML)_en.srt6.1 KB
005 DCL.pdf682.7 KB
005 Data control language (DCL).mp413.5 MB
005 Data control language (DCL)_en.srt6.7 KB
006 TCL.pdf965.7 KB
006 Transaction control language (TCL).mp49.1 MB
006 Transaction control language (TCL)_en.srt4.3 KB
external-links.txt150 bytes
001 Relational database essentials.mp491.7 MB
001 Relational database essentials_en.srt6.8 KB
002 Databases vs spreadsheets.mp4141.3 MB
002 Databases vs spreadsheets_en.srt12.1 KB
003 Database terminology.mp413.3 MB
003 Database terminology_en.srt6.3 KB
004 Relational schemas - Primary key.mp414.4 MB
004 Relational schemas - Primary key_en.srt7.3 KB
004 Relational-Schemas-Primary-Key.pdf1.3 MB
005 Relational schemas - Foreign key.mp411.9 MB
005 Relational schemas - Foreign key_en.srt7.1 KB
005 Relational-Schemas-Foreign-Key.pdf960.4 KB
006 Relational schemas - Unique key and null values.mp47.0 MB
006 Relational schemas - Unique key and null values_en.srt4.5 KB
006 Relational-Schemas-Unique-Key-and-Null-Values.pdf773.8 KB
007 Relationships.mp413.2 MB
007 Relationships.pdf1.4 MB
007 Relationships_en.srt6.7 KB
001 Installing MySQL.mp460.2 MB
001 Installing MySQL_en.srt13.1 KB
002 Additional note – Installing – Visual C.html839 bytes
003 Installing MySQL on macOS and Unix systems.html2.6 KB
004 The Client-Server Model.html30 bytes
004 The-Client-Server-Model.pdf556.9 KB
005 Setting up a connection.mp46.4 MB
005 Setting up a connection_en.srt3.6 KB
006 Read me!!!.html1018 bytes
007 New Authentication Plugin - Creating a New User.mp419.1 MB
007 New Authentication Plugin - Creating a New User_en.srt7.4 KB
008 Introduction to the MySQL interface.mp414.1 MB
008 Introduction to the MySQL interface_en.srt6.6 KB
001 Creating a Database - Part I.mp420.3 MB
001 Creating a Database - Part I_en.srt7.3 KB
001 Creating-a-Database-Part-I.pdf793.6 KB
002 MySQL-for-Data-Analytics-and-BI-Lecture-Code-and-Tasks-Solutions.sql60.8 KB
002 MySQL-for-Data-Analytics-and-BI-Lecture-Code.sql42.7 KB
002 SQL files.html1.3 KB
002 SQL-FAQ.pdf1.2 MB
003 Creating a Database - Part I - exercise.html145 bytes
004 Creating a Database - Part I - solution.html126 bytes
005 Creating a Database - Part II.mp46.0 MB
005 Creating a Database - Part II_en.srt3.3 KB
006 Creating a Database - Part II - exercise.html57 bytes
007 Creating a Database - Part II - solution.html34 bytes
008 Introduction to data types.mp44.8 MB
008 Introduction to data types_en.srt3.0 KB
008 Introduction-to-Data-Types.pdf496.6 KB
009 String data types.mp411.1 MB
009 String data types_en.srt6.6 KB
009 String-Data-Types.pdf443.3 KB
010 Integers.mp415.3 MB
010 Integers.pdf656.1 KB
010 Integers_en.srt5.3 KB
011 Fixed and floating-point data types.mp418.6 MB
011 Fixed and floating-point data types_en.srt7.7 KB
011 Fixed-and-Floating-Point-Data-Types.pdf701.7 KB
012 Other useful data types.mp414.0 MB
012 Other useful data types_en.srt7.8 KB
012 Other-Useful-Data-Types.pdf729.0 KB
013 Creating a table.mp416.4 MB
013 Creating a table_en.srt7.2 KB
013 Creating-a-Table.pdf543.0 KB
014 Creating a table - exercise.html368 bytes
015 Creating a table - solution.html697 bytes
016 Using databases and tables.mp49.1 MB
016 Using databases and tables_en.srt3.5 KB
016 Using-Databases-and-Tables.pdf529.8 KB
017 Using databases and tables - exercise.html256 bytes
018 Using databases and tables - solution.html86 bytes
019 Additional notes on using tables.mp47.2 MB
019 Additional notes on using tables_en.srt2.8 KB
019 Additional-Notes-on-Using-Tables.pdf382.3 KB
020 Additional notes on using tables - exercise.html259 bytes
001 PRIMARY KEY constraint.mp417.7 MB
001 PRIMARY KEY constraint_en.srt7.2 KB
001 PRIMARY-KEY-Constraint.pdf547.1 KB
001 sales-db.pdf140.7 KB
002 PRIMARY KEY constraint - exercise.html1.5 KB
003 PRIMARY KEY constraint - solution.html2.6 KB
004 FOREIGN KEY constraint - Part I.mp417.7 MB
004 FOREIGN KEY constraint - Part I_en.srt6.9 KB
004 FOREIGN-KEY-Constraint.pdf1.1 MB
005 FOREIGN KEY constraint - Part II.mp421.3 MB
005 FOREIGN KEY constraint - Part II_en.srt6.2 KB
006 FOREIGN KEY constraint - Part II - exercise.html182 bytes
007 FOREIGN KEY constraint - Part II - solution.html208 bytes
008 UNIQUE Constraint.mp413.5 MB
008 UNIQUE Constraint_en.srt5.7 KB
008 UNIQUE-Constraint.pdf726.6 KB
009 UNIQUE Constraint - exercise.html1.6 KB
010 DEFAULT Constraint.mp414.7 MB
010 DEFAULT Constraint_en.srt6.8 KB
010 DEFAULT-Constraint.pdf514.9 KB
011 DEFAULT Constraint - exercise.html444 bytes
012 DEFAULT Constraint - solution.html488 bytes
013 NOT NULL Constraint - Part I.mp434.6 MB
013 NOT NULL Constraint - Part I_en.srt7.1 KB
013 NOT-NULL-Constraint.pdf680.2 KB
014 NOT NULL Constraint - Part I - exercise.html163 bytes
015 NOT NULL Constraint - Part I - solution.html357 bytes
016 NOT NULL Constraint - Part II.mp44.3 MB
016 NOT NULL Constraint - Part II_en.srt2.7 KB
001 Coding techniques and best practices - Part I.mp413.8 MB
001 Coding techniques and best practices - Part I_en.srt7.3 KB
001 Coding-Techniques-and-Best-Practices.pdf1.2 MB
001 MySQL-Workbench-Shortcuts.pdf515.2 KB
002 Coding techniques and best practices - Part II.mp411.6 MB
002 Coding techniques and best practices - Part II_en.srt5.1 KB
001 Loading the 'employees' database.mp48.1 MB
001 Loading the 'employees' database_en.srt2.8 KB
002 Loading the 'employees' database.html964 bytes
002 The-employees-database.url84 bytes
external-links.txt92 bytes
001 SELECT - FROM.mp415.1 MB
001 SELECT - FROM_en.srt6.1 KB
001 SELECT-FROM.pdf572.0 KB
001 employees-db.pdf178.8 KB
002 SELECT - FROM - exercise.html160 bytes
003 SELECT - FROM - solution.html457 bytes
004 WHERE.mp417.0 MB
004 WHERE.pdf413.8 KB
004 WHERE_en.srt3.2 KB
005 WHERE - exercise.html77 bytes
006 WHERE - solution.html311 bytes
007 AND.mp45.7 MB
007 AND.pdf489.7 KB
007 AND_en.srt2.9 KB
008 AND - exercise.html82 bytes
009 AND - solution.html413 bytes
010 OR.mp410.6 MB
010 OR.pdf351.3 KB
010 OR_en.srt4.1 KB
011 OR - exercise.html85 bytes
012 OR - solution.html326 bytes
013 Operator precedence.mp410.2 MB
013 Operator precedence_en.srt4.4 KB
013 Operator-Precedence.pdf420.4 KB
014 Operator precedence - exercise.html92 bytes
015 Operator precedence - solution.html339 bytes
016 IN - NOT IN.mp49.8 MB
016 IN - NOT IN_en.srt4.2 KB
017 IN - NOT IN - exercise 1.html122 bytes
018 IN - NOT IN - solution 1.html324 bytes
019 IN - NOT IN - exercise 2.html112 bytes
020 IN - NOT IN - solution 2.html319 bytes
021 LIKE - NOT LIKE.mp410.9 MB
021 LIKE - NOT LIKE_en.srt4.6 KB
022 LIKE - NOT LIKE - exercise.html431 bytes
023 LIKE - NOT LIKE - solution.html1.1 KB
024 Wildcard characters.mp43.7 MB
024 Wildcard characters_en.srt2.5 KB
024 Wildcard-Characters.pdf406.4 KB
025 Wildcard characters - exercise.html207 bytes
026 Wildcard characters - solution.html629 bytes
027 BETWEEN - AND.mp45.5 MB
027 BETWEEN - AND_en.srt2.6 KB
027 BETWEEN-AND.pdf655.5 KB
028 BETWEEN - AND - exercise.html317 bytes
029 BETWEEN - AND- solution.html1.5 KB
030 IS NOT NULL - IS NULL.mp44.5 MB
030 IS NOT NULL - IS NULL_en.srt2.0 KB
030 IS-NOT-NULL-IS-NULL.pdf357.3 KB
031 IS NOT NULL - IS NULL - exercise.html85 bytes
032 IS NOT NULL - IS NULL - solution.html304 bytes
033 Other comparison operators.mp416.3 MB
033 Other comparison operators_en.srt5.5 KB
033 Other-Comparison-Operators.pdf340.1 KB
034 Other comparison operators - exercise.html280 bytes
035 Other comparison operators - solution.html794 bytes
036 SELECT DISTINCT.mp47.7 MB
036 SELECT DISTINCT_en.srt2.7 KB
036 SELECT-DISTINCT.pdf382.8 KB
037 SELECT DISTINCT - exercise.html344 bytes
038 SELECT DISTINCT - solution.html258 bytes
039 Introduction to aggregate functions.mp414.6 MB
039 Introduction to aggregate functions_en.srt6.8 KB
039 Introduction-to-Aggregate-Functions.pdf737.3 KB
040 Introduction to aggregate functions - exercise.html256 bytes
041 Introduction to aggregate functions - solution.html538 bytes
042 ORDER BY.mp412.0 MB
042 ORDER BY_en.srt4.5 KB
043 ORDER BY - exercise.html94 bytes
044 ORDER BY - solution.html252 bytes
045 GROUP BY.mp424.3 MB
045 GROUP BY_en.srt7.4 KB
045 GROUP-BY.pdf455.1 KB
046 Using Aliases (AS).mp46.8 MB
046 Using Aliases (AS)_en.srt2.9 KB
047 Using Aliases (AS) - exercise.html338 bytes
048 Using Aliases (AS) - solution.html458 bytes
049 HAVING.mp412.7 MB
049 HAVING.pdf463.2 KB
049 HAVING_en.srt4.4 KB
050 HAVING - exercise.html1.0 KB
051 HAVING - solution.html731 bytes
052 WHERE vs HAVING- Part I.mp427.2 MB
052 WHERE vs HAVING- Part I_en.srt5.1 KB
052 WHERE-vs-HAVING.pdf767.6 KB
053 WHERE vs HAVING- Part II.mp417.8 MB
053 WHERE vs HAVING- Part II_en.srt4.0 KB
054 WHERE vs HAVING - Part II - exercise.html209 bytes
055 WHERE vs HAVING - Part II - solution.html468 bytes
056 LIMIT.mp418.7 MB
056 LIMIT.pdf297.3 KB
056 LIMIT_en.srt6.4 KB
057 LIMIT - exercise.html63 bytes
058 LIMIT - solution.html232 bytes
001 The INSERT statement - Part I.mp421.4 MB
001 The INSERT statement - Part I_en.srt7.6 KB
001 The-INSERT-Statement.pdf371.8 KB
002 The INSERT statement - Part II.mp47.3 MB
002 The INSERT statement - Part II_en.srt2.9 KB
003 The INSERT statement - exercise 1.html1.4 KB
004 The INSERT statement - solution 1.html1.4 KB
005 The INSERT statement - exercise 2.html364 bytes
006 The INSERT statement - solution 2.html1.2 KB
007 Inserting data INTO a new table.mp411.7 MB
007 Inserting data INTO a new table_en.srt4.9 KB
007 Inserting-Data-INTO-a-New-Table.pdf302.3 KB
008 Inserting Data INTO a New Table - exercise.html163 bytes
009 Inserting Data INTO a New Table - solution.html85 bytes
001 TCL's COMMIT and ROLLBACK.mp49.6 MB
001 TCL's COMMIT and ROLLBACK_en.srt3.8 KB
001 TCLs-COMMIT-and-ROLLBACK.pdf580.2 KB
002 The UPDATE Statement - Part I.mp49.7 MB
002 The UPDATE Statement - Part I_en.srt3.8 KB
002 The-UPDATE-Statement.pdf455.9 KB
003 ROLLBACK; ARTICLE.html1.3 KB
004 The UPDATE Statement - Part II.mp48.7 MB
004 The UPDATE Statement - Part II_en.srt3.7 KB
005 The UPDATE Statement – Part II - exercise.html156 bytes
006 The UPDATE Statement – Part II - solution.html279 bytes
001 The DELETE Statement - Part I.mp412.7 MB
001 The DELETE Statement - Part I_en.srt5.1 KB
001 The-DELETE-Statement.pdf360.6 KB
002 The DELETE Statement - Part II.mp45.6 MB
002 The DELETE Statement - Part II_en.srt1.8 KB
003 The DELETE Statement – Part II - exercise.html73 bytes
004 The DELETE Statement – Part II - solution.html158 bytes
005 DROP vs TRUNCATE vs DELETE.mp47.6 MB
005 DROP vs TRUNCATE vs DELETE_en.srt4.3 KB
005 DROP-vs-TRUNCATE-vs-DELETE.pdf1.0 MB
001 COUNT().mp419.1 MB
001 COUNT()_en.srt5.6 KB
001 COUNT.pdf1.1 MB
002 COUNT() - exercise.html111 bytes
003 COUNT() - solution.html212 bytes
004 SUM().mp43.8 MB
004 SUM()_en.srt2.0 KB
004 SUM.pdf494.1 KB
005 SUM() - exercise.html127 bytes
006 SUM() - solution.html311 bytes
007 MIN() and MAX().mp43.5 MB
007 MIN() and MAX()_en.srt1.5 KB
007 MIN-and-MAX.pdf284.9 KB
008 MIN() and MAX() - exercise.html130 bytes
009 MIN() and MAX() - solution.html535 bytes
010 AVG().mp46.6 MB
010 AVG()_en.srt2.7 KB
010 AVG.pdf442.8 KB
011 AVG() - exercise.html112 bytes
012 AVG() - solution.html343 bytes
013 ROUND().mp46.0 MB
013 ROUND()_en.srt2.6 KB
013 ROUND.pdf334.7 KB
014 ROUND() - exercise.html155 bytes
015 ROUND() - solution.html321 bytes
016 COALESCE() - Preamble.html28 bytes
016 COALESCE-Preamble.pdf581.9 KB
017 IFNULL() and COALESCE().mp428.1 MB
017 IFNULL() and COALESCE()_en.srt8.0 KB
017 IFNULL-and-COALESCE.pdf715.6 KB
018 Another Example of Using COALESCE().mp44.1 MB
018 Another Example of Using COALESCE()_en.srt2.0 KB
019 Another example of using COALESCE() - exercise 1.html208 bytes
020 Another example of using COALESCE() - solution 1.html407 bytes
021 Another example of using COALESCE() - exercise 2.html302 bytes
022 Another example of using COALESCE() - solution 2.html610 bytes
001 Introduction to JOINs.mp421.6 MB
001 Introduction to JOINs_en.srt5.2 KB
001 Introduction-to-Joins.pdf775.9 KB
002 Intro to JOINs - exercise 1.html921 bytes
003 Intro to JOINs - solution 1.html1.6 KB
004 Intro to JOINs - exercise 2.html1.6 KB
005 INNER JOIN - Part I.mp413.8 MB
005 INNER JOIN - Part I_en.srt7.3 KB
005 INNER-JOIN.pdf778.5 KB
006 INNER JOIN - Part II.mp426.2 MB
006 INNER JOIN - Part II_en.srt6.9 KB
007 INNER JOIN - Part II - exercise.html141 bytes
008 INNER JOIN - Part II - solution.html689 bytes
009 A Note on Using Joins.mp413.3 MB
009 A Note on Using Joins_en.srt5.4 KB
010 Duplicate Records.mp416.8 MB
010 Duplicate Records_en.srt5.4 KB
010 Duplicate-Records.pdf337.0 KB
011 LEFT JOIN - Part I.mp420.4 MB
011 LEFT JOIN - Part I_en.srt6.0 KB
011 LEFT-JOIN.pdf739.0 KB
012 LEFT JOIN - Part II.mp420.8 MB
012 LEFT JOIN - Part II_en.srt7.4 KB
013 LEFT JOIN - Part II - exercise.html429 bytes
014 LEFT JOIN - Part II - solution.html593 bytes
015 RIGHT JOIN.mp424.5 MB
015 RIGHT JOIN_en.srt5.2 KB
015 RIGHT-JOIN.pdf856.3 KB
016 The new and the old join syntax.mp414.5 MB
016 The new and the old join syntax_en.srt5.7 KB
016 The-New-and-the-Old-Join-Syntax.pdf718.7 KB
017 The new and the old join syntax - exercise.html189 bytes
018 The new and the old join syntax - solution.html1.4 KB
019 JOIN and WHERE Used Together.mp418.9 MB
019 JOIN and WHERE Used Together_en.srt3.6 KB
019 JOIN-and-WHERE-Used-Together.pdf398.0 KB
020 Important – Prevent Error Code 1055!.html3.4 KB
021 JOIN and WHERE Used Together - exercise.html157 bytes
022 JOIN and WHERE Used Together - solution.html768 bytes
023 CROSS JOIN.mp431.1 MB
023 CROSS JOIN_en.srt10.4 KB
023 CROSS-JOIN.pdf313.7 KB
024 CROSS JOIN - exercise 1.html150 bytes
025 CROSS JOIN - solution 1.html520 bytes
026 CROSS JOIN - exercise 2.html163 bytes
027 CROSS JOIN - solution 2.html558 bytes
028 Using Aggregate Functions with Joins.mp48.6 MB
028 Using Aggregate Functions with Joins_en.srt2.8 KB
029 JOIN more than two tables in SQL.mp412.6 MB
029 JOIN more than two tables in SQL_en.srt5.2 KB
029 JOIN-More-Than-Two-Tables-in-SQL.pdf624.2 KB
030 Join more than two tables in SQL - exercise.html106 bytes
031 Join more than two tables in SQL - solution.html2.8 KB
032 Tips and tricks for joins.mp436.8 MB
032 Tips and tricks for joins_en.srt7.3 KB
032 Tips-and-Tricks-for-Joins.pdf479.2 KB
033 Tips and tricks for joins - exercise.html87 bytes
034 Tips and tricks for joins - solution.html432 bytes
035 UNION vs UNION ALL.mp415.2 MB
035 UNION vs UNION ALL_en.srt6.8 KB
035 UNION-vs-UNION-ALL.pdf823.8 KB
036 UNION vs UNION ALL - exercise.html177 bytes
037 UNION vs UNION ALL - solution.html1.8 KB
001 SQL Subqueries with IN nested inside WHERE.mp412.2 MB
001 SQL Subqueries with IN nested inside WHERE_en.srt5.3 KB
001 Subqueries-IN-WHERE.pdf1.1 MB
002 SQL Subqueries with IN nested inside WHERE - exercise.html162 bytes
003 SQL Subqueries with IN nested inside WHERE - solution.html825 bytes
004 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE.mp49.8 MB
004 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE_en.srt4.5 KB
004 Subqueries-EXISTS-WHERE.pdf1.0 MB
005 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - exercise.html179 bytes
006 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - solution.html944 bytes
007 SQL Subqueries nested in SELECT and FROM.mp432.8 MB
007 SQL Subqueries nested in SELECT and FROM_en.srt8.8 KB
007 Subqueries-SELECT-FROM.pdf403.8 KB
008 SQL Subqueries nested in SELECT and FROM - exercise 1.html198 bytes
009 SQL Subqueries nested in SELECT and FROM - solution 1.html366 bytes
010 SQL Subqueries nested in SELECT and FROM - exercise 2.html1.2 KB
011 SQL Subqueries nested in SELECT and FROM - solution 2.html15 bytes
011 Subqueries-SELECT-FROM-Solution.sql1.8 KB
001 SQL-Self-Join.pdf703.9 KB
001 Self Join.mp447.3 MB
001 Self Join_en.srt9.1 KB
001 SQL-Views.pdf1.0 MB
001 Views.mp420.7 MB
001 Views_en.srt8.3 KB
002 Views - exercise.html284 bytes
003 Views - solution.html590 bytes
001 Introduction to stored routines.mp48.1 MB
001 Introduction to stored routines_en.srt4.4 KB
001 Introduction-to-Stored-Routines.pdf729.7 KB
002 The MySQL syntax for stored procedures.mp425.2 MB
002 The MySQL syntax for stored procedures_en.srt6.0 KB
002 The-MySQL-Syntax-for-Stored-Procedures.pdf911.1 KB
003 Stored procedures - Example - Part I.mp47.7 MB
003 Stored procedures - Example - Part I_en.srt3.6 KB
004 Stored procedures - Example - Part II.mp414.4 MB
004 Stored procedures - Example - Part II_en.srt6.4 KB
005 Stored procedures - Example - Part II - exercise.html120 bytes
006 Stored procedures - Example - Part II - solution.html1.1 KB
007 Another way to create a procedure.mp410.1 MB
007 Another way to create a procedure_en.srt3.9 KB
008 Stored procedures with an input parameter.mp419.4 MB
008 Stored procedures with an input parameter_en.srt8.1 KB
008 Stored-Procedures-with-an-Input-Parameter.pdf547.7 KB
009 Stored procedures with an output parameter.mp412.5 MB
009 Stored procedures with an output parameter_en.srt4.2 KB
009 Stored-Procedures-with-an-Output-Parameter.pdf429.4 KB
010 Stored procedures with an output parameter - exercise.html146 bytes
011 Stored procedures with an output parameter - solution.html1.7 KB
012 Variables.mp422.5 MB
012 Variables.pdf718.3 KB
012 Variables_en.srt8.0 KB
013 Variables - exercise.html295 bytes
014 Variables - solution.html170 bytes
015 User-Defined-Functions-in-MySQL.pdf512.0 KB
015 User-defined functions in MySQL.mp443.9 MB
015 User-defined functions in MySQL_en.srt7.6 KB
016 Error Code 1418.html2.8 KB
017 User-defined functions in MySQL - exercise.html433 bytes
018 User-defined functions in MySQL - solution.html1.8 KB
019 Stored routines - conclusion.mp411.4 MB
019 Stored routines - conclusion_en.srt5.0 KB
019 Stored-Routines-Conclusion.pdf713.9 KB
001 Types of MySQL Variables - Local Variables.mp417.9 MB
001 Types of MySQL Variables - Local Variables_en.srt6.1 KB
001 Types-of-MySQL-Variables-Local-Variables.pdf866.3 KB
002 Session Variables.mp416.1 MB
002 Session Variables_en.srt6.9 KB
002 Session-Variables.pdf1.8 MB
003 Global Variables.mp46.6 MB
003 Global Variables_en.srt2.8 KB
003 Global-Variables.pdf676.3 KB
004 User-Defined vs System Variables.mp430.4 MB
004 User-Defined vs System Variables_en.srt5.3 KB
004 User-Defined-vs-System-Variables.pdf699.4 KB
005 MySQL Triggers.html743 bytes
005 MySQL-Triggers.pdf447.5 KB
005 MySQL-Triggers.sql9.7 KB
006 MySQL Triggers.mp443.5 MB
006 MySQL Triggers_en.srt18.3 KB
007 MySQL Triggers - exercise.html191 bytes
008 MySQL Triggers - solution.html1.3 KB
009 MySQL Indexes.mp426.4 MB
009 MySQL Indexes_en.srt8.9 KB
009 MySQL-Indexes.pdf1.3 MB
010 MySQL Indexes - exercise 1.html34 bytes
011 MySQL Indexes - solution 1.html169 bytes
012 MySQL Indexes - exercise 2.html247 bytes
013 MySQL Indexes - solution 2.html735 bytes
014 The CASE Statement.mp422.7 MB
014 The CASE Statement_en.srt7.3 KB
014 The-CASE-Statement.pdf302.1 KB
015 The CASE Statement - exercise 1.html360 bytes
016 The CASE Statement - solution 1.html697 bytes
017 The CASE Statement - exercise 2.html377 bytes
018 The CASE Statement - solution 2.html1.6 KB
019 The CASE Statement - exercise 3.html377 bytes
020 The CASE Statement - solution 3.html708 bytes
001 Introduction to MySQL Window Functions.mp44.6 MB
001 Introduction to MySQL Window Functions_en.srt2.7 KB
002 The ROW_NUMBER() Ranking Window Function and the Relevant MySQL Syntax.mp459.5 MB
002 The ROW_NUMBER() Ranking Window Function and the Relevant MySQL Syntax_en.srt11.8 KB
003 The ROW_NUMBER() Ranking Window Function - Exercises.html684 bytes
004 The ROW_NUMBER() Ranking Window Function - Solution.html704 bytes
005 A Note on Using Several Window Functions in a Query.mp410.3 MB
005 A Note on Using Several Window Functions in a Query_en.srt3.6 KB
006 A Note on Using Several Window Functions - Exercise.html1.7 KB
007 A Note on Using Several Window Functions - Solution.html1.2 KB
008 MySQL Window Functions Syntax.mp412.9 MB
008 MySQL Window Functions Syntax_en.srt4.9 KB
009 MySQL Window Functions Syntax - Exercise.html447 bytes
010 MySQL Window Functions Syntax - Solution.html352 bytes
011 The PARTITION BY Clause VS the GROUP BY Clause.mp418.5 MB
011 The PARTITION BY Clause VS the GROUP BY Clause_en.srt8.9 KB
012 The PARTITION BY Clause VS the GROUP BY Clause - Exercise.html2.1 KB
013 The PARTITION BY Clause VS the GROUP BY Clause - Solution.html2.2 KB
014 The MySQL RANK() and DENSE_RANK() Window Functions.mp427.9 MB
014 The MySQL RANK() and DENSE_RANK() Window Functions_en.srt10.1 KB
015 The MySQL RANK() and DENSE_RANK() Window Functions - Exercise.html1.2 KB
016 The MySQL RANK() and DENSE_RANK() Window Functions - Solution.html1.6 KB
017 Working with MySQL Ranking Window Functions and Joins Together.mp435.5 MB
017 Working with MySQL Ranking Window Functions and Joins Together_en.srt11.5 KB
018 Working with MySQL Ranking Window Functions and Joins Together - Exercise.html1.1 KB
019 Working with MySQL Ranking Window Functions and Joins Together - Solution.html1.4 KB
020 The LAG() and LEAD() Value Window Functions.mp435.3 MB
020 The LAG() and LEAD() Value Window Functions_en.srt11.6 KB
021 The LAG() and LEAD() Value Window Functions - Exercise.html1.6 KB
022 The LAG() and LEAD() Value Window Functions - Solution.html1.3 KB
023 MySQL Aggregate Functions in the Context of Window Functions - Part I.mp434.2 MB
023 MySQL Aggregate Functions in the Context of Window Functions - Part I_en.srt9.0 KB
024 MySQL Aggregate Functions in the Context of Window Functions - Part I-Exercise.html342 bytes
025 MySQL Aggregate Functions in the Context of Window Functions - Part I-Solution.html710 bytes
026 MySQL Aggregate Functions in the Context of Window Functions - Part II.mp443.5 MB
026 MySQL Aggregate Functions in the Context of Window Functions - Part II_en.srt9.5 KB
027 MySQL Aggregate Functions in the Context of Window Functions - Part II-Exercise.html1.6 KB
028 MySQL Aggregate Functions in the Context of Window Functions - Part II-Solution.html2.0 KB
001 MySQL Common Table Expressions - Introduction.mp449.2 MB
001 MySQL Common Table Expressions - Introduction_en.srt9.6 KB
002 An Alternative Solution to the Same Task.mp48.4 MB
002 An Alternative Solution to the Same Task_en.srt2.7 KB
003 An Alternative Solution to the Same Task-Exercise.html1.1 KB
004 An Alternative Solution to the Same Task-Solution.html2.5 KB
005 Using Multiple Subclauses in a WITH Clause - Part I.mp424.6 MB
005 Using Multiple Subclauses in a WITH Clause - Part I_en.srt7.6 KB
006 Using Multiple Subclauses in a WITH Clause - Part II.mp421.2 MB
006 Using Multiple Subclauses in a WITH Clause - Part II_en.srt7.3 KB
007 Using Multiple Subclauses in a WITH Clause-Exercise.html686 bytes
008 Using Multiple Subclauses in a WITH Clause-Solution.html2.2 KB
009 Referring to Common Table Expressions in a WITH Clause.mp416.7 MB
009 Referring to Common Table Expressions in a WITH Clause_en.srt5.5 KB
001 MySQL Temporary Tables - Introduction.mp410.7 MB
001 MySQL Temporary Tables - Introduction_en.srt4.3 KB
002 MySQL Temporary Tables in Action.mp429.7 MB
002 MySQL Temporary Tables in Action_en.srt7.0 KB
003 MySQL Temporary Tables in Action-Exercise.html372 bytes
004 MySQL Temporary Tables in Action-Solution.html676 bytes
005 Other Features of MySQL Temporary Tables.mp433.2 MB
005 Other Features of MySQL Temporary Tables_en.srt9.6 KB
006 Other Features of MySQL Temporary Tables-Exercise.html1.2 KB
007 Other Features of MySQL Temporary Tables-Solution.html1.5 KB
001 The Advantages of Software Integration.mp456.4 MB
001 The Advantages of Software Integration_en.srt7.3 KB
002 Why Combining SQL and Tableau is useful.mp414.7 MB
002 Why Combining SQL and Tableau is useful_en.srt6.3 KB
003 Installing Tableau Public.mp47.1 MB
003 Installing Tableau Public_en.srt2.4 KB
004 Loading the 'employees_mod' Database.mp416.5 MB
004 Loading the 'employees_mod' Database_en.srt4.1 KB
004 The-employees-mod-Database.url88 bytes
004 employees-mod-db.pdf129.7 KB
005 Loading the 'employees_mod' Database.html602 bytes
005 The-employees-mod-database.url88 bytes
005 employees-mod-db.pdf129.7 KB
external-links.txt200 bytes
001 Task 1.mp413.8 MB
001 Task 1_en.srt7.4 KB
002 Task 1 - Text.html147 bytes
003 Important clarification!.html1.4 KB
004 Task 1 SQL Solution.mp420.1 MB
004 Task 1 SQL Solution_en.srt6.0 KB
005 Task 1 SQL Solution - Code.html481 bytes
006 Transferring a Dataset from SQL to Tableau.mp412.7 MB
006 Transferring a Dataset from SQL to Tableau_en.srt5.3 KB
007 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I.mp415.9 MB
007 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I_en.srt8.3 KB
008 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II.mp419.8 MB
008 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II_en.srt7.0 KB
001 Task 2.mp48.8 MB
001 Task 2_en.srt5.1 KB
002 Task 2 - Text.html137 bytes
003 Task 2 SQL Solution.mp411.5 MB
003 Task 2 SQL Solution_en.srt4.5 KB
004 Task 2 SQL Solution - Code.html665 bytes
005 Chart 2 Visualizing and Analyzing the Solution in Tableau.mp430.0 MB
005 Chart 2 Visualizing and Analyzing the Solution in Tableau_en.srt8.0 KB
001 Task 3.mp45.0 MB
001 Task 3_en.srt3.2 KB
002 Task 3 - Text.html167 bytes
003 Task 3 SQL Solution.mp414.3 MB
003 Task 3 SQL Solution_en.srt4.1 KB
004 Task 3 SQL Solution - Code.html444 bytes
005 Chart 3 Visualizing and Analyzing the Solution in Tableau.mp418.8 MB
005 Chart 3 Visualizing and Analyzing the Solution in Tableau_en.srt6.0 KB
001 Task 4.mp48.7 MB
001 Task 4_en.srt3.6 KB
002 Task 4 - Text.html327 bytes
003 Task 4 Solution in SQL.mp413.0 MB
003 Task 4 Solution in SQL_en.srt3.4 KB
004 Task 4 Solution in SQL - Code.html653 bytes
005 Chart 4 Visualizing and Analyzing the Solution in Tableau.mp48.7 MB
005 Chart 4 Visualizing and Analyzing the Solution in Tableau_en.srt4.0 KB
001 Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau.mp441.7 MB
001 Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau_en.srt7.1 KB
001 10-Practice-Final-Query-Questions-SOLUTIONS.sql6.9 KB
001 10-Practice-SQL-Final-Query-Questions.pdf557.1 KB
001 Practice SQL – 10 Final Query Questions.html1019 bytes
001 Bonus Lecture Next Steps.html2.7 KB
Bonus Resources.txt386 bytes
Comments