| 01 Introduction to databases SQL and MySQL | |||
| 001 What does the course cover.en.srt | 6.33 KB | ||
| 001 What does the course cover.es.srt | 6.81 KB | ||
| 001 What does the course cover.fr.srt | 6.79 KB | ||
| 001 What does the course cover.mp4 | 24.25 MB | ||
| 001 What does the course cover.pt.srt | 6.76 KB | ||
| 002 Why SQL.en.srt | 4.56 KB | ||
| 002 Why SQL.es.srt | 4.97 KB | ||
| 002 Why SQL.fr.srt | 4.96 KB | ||
| 002 Why SQL.mp4 | 14.74 MB | ||
| 002 Why SQL.pt.srt | 5.02 KB | ||
| 003 Why MySQL.en.srt | 2.78 KB | ||
| 003 Why MySQL.es.srt | 2.92 KB | ||
| 003 Why MySQL.fr.srt | 3.01 KB | ||
| 003 Why MySQL.mp4 | 6.53 MB | ||
| 003 Why MySQL.pt.srt | 2.96 KB | ||
| 004 Introduction to databases.en.srt | 6.81 KB | ||
| 004 Introduction to databases.es.srt | 7.46 KB | ||
| 004 Introduction to databases.fr.srt | 7.46 KB | ||
| 004 Introduction to databases.mp4 | 19.6 MB | ||
| 004 Introduction to databases.pt.srt | 7.24 KB | ||
| 02 SQL theory | |||
| 005 Course-Notes-SQL-MySQL-for-Data-Analytics-and-Business-Intelligence.txt | 75 B | ||
| 005 SQL as a declarative language.en.srt | 2.96 KB | ||
| 005 SQL as a declarative language.es.srt | 3.1 KB | ||
| 005 SQL as a declarative language.fr.srt | 3.29 KB | ||
| 005 SQL as a declarative language.mp4 | 10.08 MB | ||
| 005 SQL as a declarative language.pt.srt | 3.19 KB | ||
| 006 DDL.pdf | 1.26 MB | ||
| 006 Data definition language (DDL).en.srt | 5.94 KB | ||
| 006 Data definition language (DDL).es.srt | 6.3 KB | ||
| 006 Data definition language (DDL).fr.srt | 6.34 KB | ||
| 006 Data definition language (DDL).mp4 | 8.69 MB | ||
| 006 Data definition language (DDL).pt.srt | 6.16 KB | ||
| 007 SQL keywords.en.srt | 1.73 KB | ||
| 007 SQL keywords.es.srt | 1.94 KB | ||
| 007 SQL keywords.fr.srt | 1.84 KB | ||
| 007 SQL keywords.mp4 | 2.47 MB | ||
| 007 SQL keywords.pt.srt | 1.89 KB | ||
| 007 SQL-Keywords.pdf | 533.09 KB | ||
| 008 DML.pdf | 913.21 KB | ||
| 008 Data manipulation language (DML).en.srt | 6.14 KB | ||
| 008 Data manipulation language (DML).es.srt | 6.45 KB | ||
| 008 Data manipulation language (DML).fr.srt | 6.69 KB | ||
| 008 Data manipulation language (DML).mp4 | 9.99 MB | ||
| 008 Data manipulation language (DML).pt.srt | 6.43 KB | ||
| 009 DCL.pdf | 682.67 KB | ||
| 009 Data control language (DCL).en.srt | 6.67 KB | ||
| 009 Data control language (DCL).es.srt | 7.18 KB | ||
| 009 Data control language (DCL).fr.srt | 7.36 KB | ||
| 009 Data control language (DCL).mp4 | 8.06 MB | ||
| 009 Data control language (DCL).pt.srt | 7.08 KB | ||
| 010 TCL.pdf | 965.74 KB | ||
| 010 Transaction control language (TCL).en.srt | 4.27 KB | ||
| 010 Transaction control language (TCL).es.srt | 4.54 KB | ||
| 010 Transaction control language (TCL).fr.srt | 4.84 KB | ||
| 010 Transaction control language (TCL).mp4 | 6.86 MB | ||
| 010 Transaction control language (TCL).pt.srt | 4.56 KB | ||
| 03 Basic database terminology | |||
| 011 Relational database essentials.en.srt | 6.67 KB | ||
| 011 Relational database essentials.es.srt | 7.34 KB | ||
| 011 Relational database essentials.fr.srt | 7.57 KB | ||
| 011 Relational database essentials.mp4 | 22.97 MB | ||
| 011 Relational database essentials.pt.srt | 7.23 KB | ||
| 012 Databases vs spreadsheets.en.srt | 11.55 KB | ||
| 012 Databases vs spreadsheets.es.srt | 12.82 KB | ||
| 012 Databases vs spreadsheets.fr.srt | 13.3 KB | ||
| 012 Databases vs spreadsheets.mp4 | 169.95 MB | ||
| 012 Databases vs spreadsheets.pt.srt | 12.39 KB | ||
| 013 Database terminology.en.srt | 6.1 KB | ||
| 013 Database terminology.es.srt | 6.74 KB | ||
| 013 Database terminology.fr.srt | 6.88 KB | ||
| 013 Database terminology.mp4 | 18.96 MB | ||
| 013 Database terminology.pt.srt | 6.66 KB | ||
| 014 Relational schemas - Primary key.en.srt | 6.96 KB | ||
| 014 Relational schemas - Primary key.es.srt | 7.46 KB | ||
| 014 Relational schemas - Primary key.fr.srt | 7.58 KB | ||
| 014 Relational schemas - Primary key.mp4 | 10.41 MB | ||
| 014 Relational schemas - Primary key.pt.srt | 7.41 KB | ||
| 014 Relational-Schemas-Primary-Key.pdf | 1.26 MB | ||
| 015 Relational schemas - Foreign key.en.srt | 6.88 KB | ||
| 015 Relational schemas - Foreign key.es.srt | 7.4 KB | ||
| 015 Relational schemas - Foreign key.fr.srt | 7.44 KB | ||
| 015 Relational schemas - Foreign key.mp4 | 10.35 MB | ||
| 015 Relational schemas - Foreign key.pt.srt | 7.27 KB | ||
| 015 Relational-Schemas-Foreign-Key.pdf | 960.36 KB | ||
| 016 Relational schemas - Unique key and null values.en.srt | 4.42 KB | ||
| 016 Relational schemas - Unique key and null values.es.srt | 4.76 KB | ||
| 016 Relational schemas - Unique key and null values.fr.srt | 4.85 KB | ||
| 016 Relational schemas - Unique key and null values.mp4 | 6.34 MB | ||
| 016 Relational schemas - Unique key and null values.pt.srt | 4.71 KB | ||
| 016 Relational-Schemas-Unique-Key-and-Null-Values.pdf | 773.82 KB | ||
| 017 Relationships.en.srt | 6.24 KB | ||
| 017 Relationships.es.srt | 6.65 KB | ||
| 017 Relationships.fr.srt | 6.4 KB | ||
| 017 Relationships.mp4 | 9.74 MB | ||
| 017 Relationships.pdf | 1.36 MB | ||
| 017 Relationships.pt.srt | 6.57 KB | ||
| 04 Installing MySQL and getting acquainted with the interface | |||
| 018 Installing MySQL.en.srt | 12.65 KB | ||
| 018 Installing MySQL.es.srt | 13.63 KB | ||
| 018 Installing MySQL.fr.srt | 13.82 KB | ||
| 018 Installing MySQL.mp4 | 89.8 MB | ||
| 018 Installing MySQL.pt.srt | 13.59 KB | ||
| 019 Additional note Installing Visual C.html | 1.65 KB | ||
| 020 The Client-Server Model.html | 894 B | ||
| 020 The-Client-Server-Model.pdf | 556.9 KB | ||
| 021 Setting up a connection.en.srt | 3.33 KB | ||
| 021 Setting up a connection.es.srt | 3.6 KB | ||
| 021 Setting up a connection.fr.srt | 3.49 KB | ||
| 021 Setting up a connection.mp4 | 6.14 MB | ||
| 021 Setting up a connection.pt.srt | 3.5 KB | ||
| 022 New Authentication Plugin - Creating a New User.en.srt | 6.73 KB | ||
| 022 New Authentication Plugin - Creating a New User.es.srt | 7.15 KB | ||
| 022 New Authentication Plugin - Creating a New User.fr.srt | 7.42 KB | ||
| 022 New Authentication Plugin - Creating a New User.mp4 | 47.71 MB | ||
| 022 New Authentication Plugin - Creating a New User.pt.srt | 7.18 KB | ||
| 023 Introduction to the MySQL interface.en.srt | 6.27 KB | ||
| 023 Introduction to the MySQL interface.es.srt | 6.79 KB | ||
| 023 Introduction to the MySQL interface.fr.srt | 6.81 KB | ||
| 023 Introduction to the MySQL interface.mp4 | 11.9 MB | ||
| 023 Introduction to the MySQL interface.pt.srt | 6.66 KB | ||
| 05 First steps in SQL | |||
| 024 Creating a Database - Part I.en.srt | 7.15 KB | ||
| 024 Creating a Database - Part I.es.srt | 7.7 KB | ||
| 024 Creating a Database - Part I.fr.srt | 7.9 KB | ||
| 024 Creating a Database - Part I.mp4 | 10.36 MB | ||
| 024 Creating a Database - Part I.pt.srt | 7.6 KB | ||
| 024 Creating-a-Database-Part-I.pdf | 793.56 KB | ||
| 025 MySQL-for-Data-Analytics-and-BI-Lecture-Code-and-Tasks-Solutions.sql | 60.75 KB | ||
| 025 MySQL-for-Data-Analytics-and-BI-Lecture-Code.sql | 42.72 KB | ||
| 025 SQL files.html | 2.05 KB | ||
| 026 Creating a Database - Part I - exercise.html | 1.01 KB | ||
| 027 Creating a Database - Part I - solution.html | 1002 B | ||
| 028 Creating a Database - Part II.en.srt | 3.36 KB | ||
| 028 Creating a Database - Part II.es.srt | 3.59 KB | ||
| 028 Creating a Database - Part II.fr.srt | 3.65 KB | ||
| 028 Creating a Database - Part II.mp4 | 4.87 MB | ||
| 028 Creating a Database - Part II.pt.srt | 3.59 KB | ||
| 029 Creating a Database - Part II - exercise.html | 938 B | ||
| 030 Creating a Database - Part II - solution.html | 915 B | ||
| 031 Introduction to data types.en.srt | 2.86 KB | ||
| 031 Introduction to data types.es.srt | 3.08 KB | ||
| 031 Introduction to data types.fr.srt | 3.16 KB | ||
| 031 Introduction to data types.mp4 | 3.09 MB | ||
| 031 Introduction to data types.pt.srt | 3.1 KB | ||
| 031 Introduction-to-Data-Types.pdf | 496.65 KB | ||
| 032 String data types.en.srt | 6.29 KB | ||
| 032 String data types.es.srt | 6.8 KB | ||
| 032 String data types.fr.srt | 6.88 KB | ||
| 032 String data types.mp4 | 9.14 MB | ||
| 032 String data types.pt.srt | 6.8 KB | ||
| 032 String-Data-Types.pdf | 443.28 KB | ||
| 033 Integers.en.srt | 5.09 KB | ||
| 033 Integers.es.srt | 5.4 KB | ||
| 033 Integers.fr.srt | 5.42 KB | ||
| 033 Integers.mp4 | 8.83 MB | ||
| 033 Integers.pdf | 656.05 KB | ||
| 033 Integers.pt.srt | 5.43 KB | ||
| 034 Fixed and floating-point data types.en.srt | 7.25 KB | ||
| 034 Fixed and floating-point data types.es.srt | 7.73 KB | ||
| 034 Fixed and floating-point data types.fr.srt | 7.67 KB | ||
| 034 Fixed and floating-point data types.mp4 | 11.77 MB | ||
| 034 Fixed and floating-point data types.pt.srt | 7.6 KB | ||
| 034 Fixed-and-Floating-Point-Data-Types.pdf | 701.7 KB | ||
| 035 Other useful data types.en.srt | 7.8 KB | ||
| 035 Other useful data types.es.srt | 8.29 KB | ||
| 035 Other useful data types.fr.srt | 8.34 KB | ||
| 035 Other useful data types.mp4 | 11.8 MB | ||
| 035 Other useful data types.pt.srt | 8.19 KB | ||
| 035 Other-Useful-Data-Types.pdf | 729.04 KB | ||
| 036 Creating a table.en.srt | 6.73 KB | ||
| 036 Creating a table.es.srt | 7.22 KB | ||
| 036 Creating a table.fr.srt | 7.11 KB | ||
| 036 Creating a table.mp4 | 10.66 MB | ||
| 036 Creating a table.pt.srt | 7.12 KB | ||
| 036 Creating-a-Table.pdf | 542.97 KB | ||
| 037 Creating a table - exercise.html | 1.22 KB | ||
| 038 Creating a table - solution.html | 1.33 KB | ||
| 039 Using databases and tables.en.srt | 3.28 KB | ||
| 039 Using databases and tables.es.srt | 3.51 KB | ||
| 039 Using databases and tables.fr.srt | 3.65 KB | ||
| 039 Using databases and tables.mp4 | 6.52 MB | ||
| 039 Using databases and tables.pt.srt | 3.58 KB | ||
| 039 Using-Databases-and-Tables.pdf | 529.82 KB | ||
| 040 Using databases and tables - exercise.html | 1.11 KB | ||
| 041 Using databases and tables - solution.html | 960 B | ||
| 042 Additional notes on using tables.en.srt | 2.61 KB | ||
| 042 Additional notes on using tables.es.srt | 2.8 KB | ||
| 042 Additional notes on using tables.fr.srt | 2.78 KB | ||
| 042 Additional notes on using tables.mp4 | 5.07 MB | ||
| 042 Additional notes on using tables.pt.srt | 2.78 KB | ||
| 042 Additional-Notes-on-Using-Tables.pdf | 382.34 KB | ||
| 043 Additional notes on using tables - exercise.html | 1.12 KB | ||
| 06 MySQL constraints | |||
| 044 PRIMARY KEY constraint.en.srt | 6.78 KB | ||
| 044 PRIMARY KEY constraint.es.srt | 7.45 KB | ||
| 044 PRIMARY KEY constraint.fr.srt | 7.43 KB | ||
| 044 PRIMARY KEY constraint.mp4 | 11.98 MB | ||
| 044 PRIMARY KEY constraint.pt.srt | 7.35 KB | ||
| 044 PRIMARY-KEY-Constraint.pdf | 547.08 KB | ||
| 044 sales-db.pdf | 140.67 KB | ||
| 045 PRIMARY KEY constraint - exercise.html | 2.06 KB | ||
| 046 PRIMARY KEY constraint - solution.html | 2.55 KB | ||
| 047 FOREIGN KEY constraint - Part I.en.srt | 6.55 KB | ||
| 047 FOREIGN KEY constraint - Part I.es.srt | 7.06 KB | ||
| 047 FOREIGN KEY constraint - Part I.fr.srt | 7.01 KB | ||
| 047 FOREIGN KEY constraint - Part I.mp4 | 11.06 MB | ||
| 047 FOREIGN KEY constraint - Part I.pt.srt | 6.92 KB | ||
| 047 FOREIGN-KEY-Constraint.pdf | 1.08 MB | ||
| 048 FOREIGN KEY constraint - Part II.en.srt | 5.79 KB | ||
| 048 FOREIGN KEY constraint - Part II.es.srt | 6.19 KB | ||
| 048 FOREIGN KEY constraint - Part II.fr.srt | 6.19 KB | ||
| 048 FOREIGN KEY constraint - Part II.mp4 | 14.54 MB | ||
| 048 FOREIGN KEY constraint - Part II.pt.srt | 6.17 KB | ||
| 049 FOREIGN KEY constraint - Part II - exercise.html | 1.07 KB | ||
| 050 FOREIGN KEY constraint - Part II - solution.html | 1.05 KB | ||
| 051 UNIQUE Constraint.en.srt | 5.39 KB | ||
| 051 UNIQUE Constraint.es.srt | 5.93 KB | ||
| 051 UNIQUE Constraint.fr.srt | 5.84 KB | ||
| 051 UNIQUE Constraint.mp4 | 11.75 MB | ||
| 051 UNIQUE Constraint.pt.srt | 5.85 KB | ||
| 051 UNIQUE-Constraint.pdf | 726.56 KB | ||
| 052 UNIQUE Constraint - exercise.html | 2.23 KB | ||
| 053 DEFAULT Constraint.en.srt | 6.54 KB | ||
| 053 DEFAULT Constraint.es.srt | 7.07 KB | ||
| 053 DEFAULT Constraint.fr.srt | 7.01 KB | ||
| 053 DEFAULT Constraint.mp4 | 13.12 MB | ||
| 053 DEFAULT Constraint.pt.srt | 6.89 KB | ||
| 053 DEFAULT-Constraint.pdf | 514.9 KB | ||
| 054 DEFAULT Constraint - exercise.html | 1.28 KB | ||
| 055 DEFAULT Constraint - solution.html | 1.34 KB | ||
| 056 NOT NULL Constraint - Part I.en.srt | 6.75 KB | ||
| 056 NOT NULL Constraint - Part I.es.srt | 7.37 KB | ||
| 056 NOT NULL Constraint - Part I.fr.srt | 7.52 KB | ||
| 056 NOT NULL Constraint - Part I.mp4 | 14.91 MB | ||
| 056 NOT NULL Constraint - Part I.pt.srt | 7.16 KB | ||
| 056 NOT-NULL-Constraint.pdf | 680.16 KB | ||
| 057 NOT NULL Constraint - Part I - exercise.html | 1.02 KB | ||
| 058 NOT NULL Constraint - Part I - solution.html | 1.18 KB | ||
| 059 NOT NULL Constraint - Part II.en.srt | 2.47 KB | ||
| 059 NOT NULL Constraint - Part II.es.srt | 2.64 KB | ||
| 059 NOT NULL Constraint - Part II.fr.srt | 2.68 KB | ||
| 059 NOT NULL Constraint - Part II.mp4 | 3.68 MB | ||
| 059 NOT NULL Constraint - Part II.pt.srt | 2.62 KB | ||
| 07 SQL best practices | |||
| 060 Coding techniques and best practices - Part I.en.srt | 6.74 KB | ||
| 060 Coding techniques and best practices - Part I.es.srt | 7.31 KB | ||
| 060 Coding techniques and best practices - Part I.fr.srt | 7.36 KB | ||
| 060 Coding techniques and best practices - Part I.mp4 | 11.56 MB | ||
| 060 Coding techniques and best practices - Part I.pt.srt | 7.35 KB | ||
| 060 Coding-Techniques-and-Best-Practices.pdf | 1.25 MB | ||
| 060 MySQL-Workbench-Shortcuts.pdf | 515.23 KB | ||
| 061 Coding techniques and best practices - Part II.en.srt | 4.82 KB | ||
| 061 Coding techniques and best practices - Part II.es.srt | 5.3 KB | ||
| 061 Coding techniques and best practices - Part II.fr.srt | 5.29 KB | ||
| 061 Coding techniques and best practices - Part II.mp4 | 9.27 MB | ||
| 061 Coding techniques and best practices - Part II.pt.srt | 5.21 KB | ||
| 08 Loading the employees database | |||
| 062 Loading the employees database.en.srt | 2.72 KB | ||
| 062 Loading the employees database.es.srt | 2.93 KB | ||
| 062 Loading the employees database.fr.srt | 3.07 KB | ||
| 062 Loading the employees database.mp4 | 8.14 MB | ||
| 062 Loading the employees database.pt.srt | 2.96 KB | ||
| 063 Loading the employees database.html | 1.78 KB | ||
| 063 SQL-Database.txt | 75 B | ||
| 09 SQL SELECT statement | |||
| 064 SELECT - FROM.en.srt | 5.71 KB | ||
| 064 SELECT - FROM.es.srt | 6.14 KB | ||
| 064 SELECT - FROM.fr.srt | 6.29 KB | ||
| 064 SELECT - FROM.mp4 | 10.96 MB | ||
| 064 SELECT - FROM.pt.srt | 6.06 KB | ||
| 064 SELECT-FROM.pdf | 571.98 KB | ||
| 064 employees-db.pdf | 178.82 KB | ||
| 065 SELECT - FROM - exercise.html | 1.01 KB | ||
| 066 SELECT - FROM - solution.html | 1.2 KB | ||
| 067 WHERE.en.srt | 2.98 KB | ||
| 067 WHERE.es.srt | 3.18 KB | ||
| 067 WHERE.fr.srt | 3.23 KB | ||
| 067 WHERE.mp4 | 6.03 MB | ||
| 067 WHERE.pdf | 413.79 KB | ||
| 067 WHERE.pt.srt | 3.2 KB | ||
| 068 WHERE - exercise.html | 950 B | ||
| 069 WHERE - solution.html | 1.08 KB | ||
| 070 AND.en.srt | 2.52 KB | ||
| 070 AND.es.srt | 2.7 KB | ||
| 070 AND.fr.srt | 2.64 KB | ||
| 070 AND.mp4 | 4.82 MB | ||
| 070 AND.pdf | 489.72 KB | ||
| 070 AND.pt.srt | 2.64 KB | ||
| 071 AND - exercise.html | 933 B | ||
| 072 AND - solution.html | 1.18 KB | ||
| 073 OR.en.srt | 3.89 KB | ||
| 073 OR.es.srt | 4.19 KB | ||
| 073 OR.fr.srt | 4.17 KB | ||
| 073 OR.mp4 | 8.47 MB | ||
| 073 OR.pdf | 351.28 KB | ||
| 073 OR.pt.srt | 4.16 KB | ||
| 074 OR - exercise.html | 939 B | ||
| 075 OR - solution.html | 1.09 KB | ||
| 076 Operator precedence.en.srt | 4.26 KB | ||
| 076 Operator precedence.es.srt | 4.53 KB | ||
| 076 Operator precedence.fr.srt | 4.56 KB | ||
| 076 Operator precedence.mp4 | 8.49 MB | ||
| 076 Operator precedence.pt.srt | 4.48 KB | ||
| 076 Operator-Precedence.pdf | 420.38 KB | ||
| 077 Operator precedence - exercise.html | 963 B | ||
| 078 Operator precedence - solution.html | 1.13 KB | ||
| 079 IN - NOT IN.en.srt | 3.84 KB | ||
| 079 IN - NOT IN.es.srt | 4.08 KB | ||
| 079 IN - NOT IN.fr.srt | 4.17 KB | ||
| 079 IN - NOT IN.mp4 | 8.25 MB | ||
| 079 IN - NOT IN.pt.srt | 4.09 KB | ||
| 080 IN - NOT IN - exercise 1.html | 1005 B | ||
| 081 IN - NOT IN - solution 1.html | 1.1 KB | ||
| 082 IN - NOT IN - exercise 2.html | 983 B | ||
| 083 IN - NOT IN - solution 2.html | 1.1 KB | ||
| 084 LIKE - NOT LIKE.en.srt | 4.39 KB | ||
| 084 LIKE - NOT LIKE.es.srt | 4.64 KB | ||
| 084 LIKE - NOT LIKE.fr.srt | 4.68 KB | ||
| 084 LIKE - NOT LIKE.mp4 | 9.6 MB | ||
| 084 LIKE - NOT LIKE.pt.srt | 4.75 KB | ||
| 085 LIKE - NOT LIKE - exercise.html | 1.27 KB | ||
| 086 LIKE - NOT LIKE - solution.html | 1.71 KB | ||
| 087 Wildcard characters.en.srt | 2.43 KB | ||
| 087 Wildcard characters.es.srt | 2.54 KB | ||
| 087 Wildcard characters.fr.srt | 2.66 KB | ||
| 087 Wildcard characters.mp4 | 3.34 MB | ||
| 087 Wildcard characters.pt.srt | 2.59 KB | ||
| 087 Wildcard-Characters.pdf | 406.42 KB | ||
| 088 Wildcard characters - exercise.html | 1.07 KB | ||
| 089 Wildcard characters - solution.html | 1.35 KB | ||
| 090 BETWEEN - AND.en.srt | 2.38 KB | ||
| 090 BETWEEN - AND.es.srt | 2.51 KB | ||
| 090 BETWEEN - AND.fr.srt | 2.53 KB | ||
| 090 BETWEEN - AND.mp4 | 5.18 MB | ||
| 090 BETWEEN - AND.pt.srt | 2.46 KB | ||
| 090 BETWEEN-AND.pdf | 655.54 KB | ||
| 091 BETWEEN - AND - exercise.html | 1.18 KB | ||
| 092 BETWEEN - AND- solution.html | 1.99 KB | ||
| 093 IS NOT NULL - IS NULL.en.srt | 1.91 KB | ||
| 093 IS NOT NULL - IS NULL.es.srt | 2.06 KB | ||
| 093 IS NOT NULL - IS NULL.fr.srt | 2.11 KB | ||
| 093 IS NOT NULL - IS NULL.mp4 | 3.82 MB | ||
| 093 IS NOT NULL - IS NULL.pt.srt | 2.06 KB | ||
| 093 IS-NOT-NULL-IS-NULL.pdf | 357.26 KB | ||
| 094 IS NOT NULL - IS NULL - exercise.html | 958 B | ||
| 095 IS NOT NULL - IS NULL - solution.html | 1.09 KB | ||
| 096 Other comparison operators.en.srt | 4.99 KB | ||
| 096 Other comparison operators.es.srt | 5.25 KB | ||
| 096 Other comparison operators.fr.srt | 5.45 KB | ||
| 096 Other comparison operators.mp4 | 11.05 MB | ||
| 096 Other comparison operators.pt.srt | 5.3 KB | ||
| 096 Other-Comparison-Operators.pdf | 340.07 KB | ||
| 097 Other comparison operators - exercise.html | 1.13 KB | ||
| 098 Other comparison operators - solution.html | 1.44 KB | ||
| 099 SELECT DISTINCT.en.srt | 2.59 KB | ||
| 099 SELECT DISTINCT.es.srt | 2.78 KB | ||
| 099 SELECT DISTINCT.fr.srt | 2.76 KB | ||
| 099 SELECT DISTINCT.mp4 | 4.58 MB | ||
| 099 SELECT DISTINCT.pt.srt | 2.72 KB | ||
| 099 SELECT-DISTINCT.pdf | 382.83 KB | ||
| 100 SELECT DISTINCT - exercise.html | 1.18 KB | ||
| 101 SELECT DISTINCT - solution.html | 1.05 KB | ||
| 102 Introduction to aggregate functions.en.srt | 6.69 KB | ||
| 102 Introduction to aggregate functions.es.srt | 7.29 KB | ||
| 102 Introduction to aggregate functions.fr.srt | 6.99 KB | ||
| 102 Introduction to aggregate functions.mp4 | 12.66 MB | ||
| 102 Introduction to aggregate functions.pt.srt | 7.2 KB | ||
| 102 Introduction-to-Aggregate-Functions.pdf | 737.29 KB | ||
| 103 Introduction to aggregate functions - exercise.html | 1.12 KB | ||
| 104 Introduction to aggregate functions - solution.html | 1.28 KB | ||
| 105 ORDER BY.en.srt | 4.27 KB | ||
| 105 ORDER BY.es.srt | 4.57 KB | ||
| 105 ORDER BY.fr.srt | 4.61 KB | ||
| 105 ORDER BY.mp4 | 10.77 MB | ||
| 105 ORDER BY.pt.srt | 4.6 KB | ||
| 106 ORDER BY - exercise.html | 966 B | ||
| 107 ORDER BY - solution.html | 1.04 KB | ||
| 108 GROUP BY.en.srt | 6.95 KB | ||
| 108 GROUP BY.es.srt | 7.52 KB | ||
| 108 GROUP BY.fr.srt | 7.46 KB | ||
| 108 GROUP BY.mp4 | 14.82 MB | ||
| 108 GROUP BY.pt.srt | 7.44 KB | ||
| 108 GROUP-BY.pdf | 455.07 KB | ||
| 109 Using Aliases (AS).en.srt | 2.66 KB | ||
| 109 Using Aliases (AS).es.srt | 2.87 KB | ||
| 109 Using Aliases (AS).fr.srt | 2.77 KB | ||
| 109 Using Aliases (AS).mp4 | 5.26 MB | ||
| 109 Using Aliases (AS).pt.srt | 2.8 KB | ||
| 110 Using Aliases (AS) - exercise.html | 1.19 KB | ||
| 111 Using Aliases (AS) - solution.html | 1.22 KB | ||
| 112 HAVING.en.srt | 4.16 KB | ||
| 112 HAVING.es.srt | 4.38 KB | ||
| 112 HAVING.fr.srt | 4.35 KB | ||
| 112 HAVING.mp4 | 8.92 MB | ||
| 112 HAVING.pdf | 463.17 KB | ||
| 112 HAVING.pt.srt | 4.38 KB | ||
| 113 HAVING - exercise.html | 1.74 KB | ||
| 114 HAVING - solution.html | 1.5 KB | ||
| 115 WHERE vs HAVING- Part I.en.srt | 4.81 KB | ||
| 115 WHERE vs HAVING- Part I.es.srt | 5.1 KB | ||
| 115 WHERE vs HAVING- Part I.fr.srt | 5.16 KB | ||
| 115 WHERE vs HAVING- Part I.mp4 | 9.99 MB | ||
| 115 WHERE vs HAVING- Part I.pt.srt | 5.11 KB | ||
| 115 WHERE-vs-HAVING.pdf | 767.6 KB | ||
| 116 WHERE vs HAVING- Part II.en.srt | 3.94 KB | ||
| 116 WHERE vs HAVING- Part II.es.srt | 4.17 KB | ||
| 116 WHERE vs HAVING- Part II.fr.srt | 4.14 KB | ||
| 116 WHERE vs HAVING- Part II.mp4 | 6.74 MB | ||
| 116 WHERE vs HAVING- Part II.pt.srt | 4.1 KB | ||
| 117 WHERE vs HAVING - Part II - exercise.html | 1.06 KB | ||
| 118 WHERE vs HAVING - Part II - solution.html | 1.25 KB | ||
| 119 LIMIT.en.srt | 5.9 KB | ||
| 119 LIMIT.es.srt | 6.53 KB | ||
| 119 LIMIT.fr.srt | 6.46 KB | ||
| 119 LIMIT.mp4 | 12.7 MB | ||
| 119 LIMIT.pdf | 297.28 KB | ||
| 119 LIMIT.pt.srt | 6.46 KB | ||
| 120 LIMIT - exercise.html | 922 B | ||
| 121 LIMIT - solution.html | 1.02 KB | ||
| 10 SQL INSERT statement | |||
| 122 The INSERT statement - Part I.en.srt | 6.93 KB | ||
| 122 The INSERT statement - Part I.es.srt | 7.44 KB | ||
| 122 The INSERT statement - Part I.fr.srt | 7.71 KB | ||
| 122 The INSERT statement - Part I.mp4 | 14.42 MB | ||
| 122 The INSERT statement - Part I.pt.srt | 7.4 KB | ||
| 122 The-INSERT-Statement.pdf | 371.78 KB | ||
| 123 The INSERT statement - Part II.en.srt | 2.58 KB | ||
| 123 The INSERT statement - Part II.es.srt | 2.77 KB | ||
| 123 The INSERT statement - Part II.fr.srt | 2.85 KB | ||
| 123 The INSERT statement - Part II.mp4 | 6.66 MB | ||
| 123 The INSERT statement - Part II.pt.srt | 2.69 KB | ||
| 124 The INSERT statement - exercise 1.html | 2.29 KB | ||
| 125 The INSERT statement - solution 1.html | 1.86 KB | ||
| 126 The INSERT statement - exercise 2.html | 1.21 KB | ||
| 127 The INSERT statement - solution 2.html | 1.76 KB | ||
| 128 Inserting data INTO a new table.en.srt | 4.52 KB | ||
| 128 Inserting data INTO a new table.es.srt | 4.84 KB | ||
| 128 Inserting data INTO a new table.fr.srt | 4.83 KB | ||
| 128 Inserting data INTO a new table.mp4 | 9.62 MB | ||
| 128 Inserting data INTO a new table.pt.srt | 4.75 KB | ||
| 128 Inserting-Data-INTO-a-New-Table.pdf | 302.31 KB | ||
| 129 Inserting Data INTO a New Table - exercise.html | 1.04 KB | ||
| 130 Inserting Data INTO a New Table - solution.html | 968 B | ||
| 11 SQL UPDATE Statement | |||
| 131 TCLs COMMIT and ROLLBACK.en.srt | 3.49 KB | ||
| 131 TCLs COMMIT and ROLLBACK.es.srt | 3.78 KB | ||
| 131 TCLs COMMIT and ROLLBACK.fr.srt | 3.92 KB | ||
| 131 TCLs COMMIT and ROLLBACK.mp4 | 7.81 MB | ||
| 131 TCLs COMMIT and ROLLBACK.pt.srt | 3.7 KB | ||
| 131 TCLs-COMMIT-and-ROLLBACK.pdf | 580.19 KB | ||
| 132 The UPDATE Statement - Part I.en.srt | 3.63 KB | ||
| 132 The UPDATE Statement - Part I.es.srt | 3.98 KB | ||
| 132 The UPDATE Statement - Part I.fr.srt | 3.87 KB | ||
| 132 The UPDATE Statement - Part I.mp4 | 7.91 MB | ||
| 132 The UPDATE Statement - Part I.pt.srt | 3.88 KB | ||
| 132 The-UPDATE-Statement.pdf | 455.86 KB | ||
| 133 The UPDATE Statement - Part II.en.srt | 3.42 KB | ||
| 133 The UPDATE Statement - Part II.es.srt | 3.73 KB | ||
| 133 The UPDATE Statement - Part II.fr.srt | 3.74 KB | ||
| 133 The UPDATE Statement - Part II.mp4 | 7.39 MB | ||
| 133 The UPDATE Statement - Part II.pt.srt | 3.7 KB | ||
| 134 The UPDATE Statement Part II - exercise.html | 1.03 KB | ||
| 135 The UPDATE Statement Part II - solution.html | 1.09 KB | ||
| 12 SQL DELETE Statement | |||
| 136 The DELETE Statement - Part I.en.srt | 4.89 KB | ||
| 136 The DELETE Statement - Part I.es.srt | 5.32 KB | ||
| 136 The DELETE Statement - Part I.fr.srt | 5.31 KB | ||
| 136 The DELETE Statement - Part I.mp4 | 10.31 MB | ||
| 136 The DELETE Statement - Part I.pt.srt | 5.21 KB | ||
| 136 The-DELETE-Statement.pdf | 360.6 KB | ||
| 137 The DELETE Statement - Part II.en.srt | 1.79 KB | ||
| 137 The DELETE Statement - Part II.es.srt | 1.92 KB | ||
| 137 The DELETE Statement - Part II.fr.srt | 2 KB | ||
| 137 The DELETE Statement - Part II.mp4 | 3.68 MB | ||
| 137 The DELETE Statement - Part II.pt.srt | 1.92 KB | ||
| 138 The DELETE Statement Part II - exercise.html | 960 B | ||
| 139 The DELETE Statement Part II - solution.html | 1017 B | ||
| 140 DROP vs TRUNCATE vs DELETE.en.srt | 3.97 KB | ||
| 140 DROP vs TRUNCATE vs DELETE.es.srt | 4.22 KB | ||
| 140 DROP vs TRUNCATE vs DELETE.fr.srt | 4.35 KB | ||
| 140 DROP vs TRUNCATE vs DELETE.mp4 | 7.48 MB | ||
| 140 DROP vs TRUNCATE vs DELETE.pt.srt | 4.24 KB | ||
| 140 DROP-vs-TRUNCATE-vs-DELETE.pdf | 1.02 MB | ||
| 13 MySQL - Aggregate functions | |||
| 141 COUNT().en.srt | 5.21 KB | ||
| 141 COUNT().es.srt | 5.56 KB | ||
| 141 COUNT().fr.srt | 5.61 KB | ||
| 141 COUNT().mp4 | 9.24 MB | ||
| 141 COUNT().pt.srt | 5.5 KB | ||
| 141 COUNT.pdf | 1.07 MB | ||
| 142 COUNT() - exercise.html | 982 B | ||
| 143 COUNT() - solution.html | 1.01 KB | ||
| 144 SUM().en.srt | 1.86 KB | ||
| 144 SUM().es.srt | 2.01 KB | ||
| 144 SUM().fr.srt | 2.08 KB | ||
| 144 SUM().mp4 | 3.22 MB | ||
| 144 SUM().pt.srt | 1.96 KB | ||
| 144 SUM.pdf | 494.07 KB | ||
| 145 SUM() - exercise.html | 984 B | ||
| 146 SUM() - solution.html | 1.09 KB | ||
| 147 MIN() and MAX().en.srt | 1.56 KB | ||
| 147 MIN() and MAX().es.srt | 1.65 KB | ||
| 147 MIN() and MAX().fr.srt | 1.59 KB | ||
| 147 MIN() and MAX().mp4 | 2.96 MB | ||
| 147 MIN() and MAX().pt.srt | 1.6 KB | ||
| 147 MIN-and-MAX.pdf | 284.85 KB | ||
| 148 MIN() and MAX() - exercise.html | 993 B | ||
| 149 MIN() and MAX() - solution.html | 1.26 KB | ||
| 150 AVG().en.srt | 2.56 KB | ||
| 150 AVG().es.srt | 2.66 KB | ||
| 150 AVG().fr.srt | 2.78 KB | ||
| 150 AVG().mp4 | 4.16 MB | ||
| 150 AVG().pt.srt | 2.71 KB | ||
| 150 AVG.pdf | 442.81 KB | ||
| 151 AVG() - exercise.html | 969 B | ||
| 152 AVG() - solution.html | 1.1 KB | ||
| 153 ROUND().en.srt | 2.58 KB | ||
| 153 ROUND().es.srt | 2.68 KB | ||
| 153 ROUND().fr.srt | 2.63 KB | ||
| 153 ROUND().mp4 | 4.74 MB | ||
| 153 ROUND().pt.srt | 2.76 KB | ||
| 153 ROUND.pdf | 334.72 KB | ||
| 154 ROUND() - exercise.html | 1014 B | ||
| 155 ROUND() - solution.html | 1.1 KB | ||
| 156 COALESCE() - Preamble.html | 890 B | ||
| 156 COALESCE-Preamble.pdf | 581.89 KB | ||
| 157 IFNULL() and COALESCE().en.srt | 7.4 KB | ||
| 157 IFNULL() and COALESCE().es.srt | 7.88 KB | ||
| 157 IFNULL() and COALESCE().fr.srt | 7.87 KB | ||
| 157 IFNULL() and COALESCE().mp4 | 15.75 MB | ||
| 157 IFNULL() and COALESCE().pt.srt | 7.83 KB | ||
| 157 IFNULL-and-COALESCE.pdf | 715.62 KB | ||
| 158 Another Example of Using COALESCE().en.srt | 1.96 KB | ||
| 158 Another Example of Using COALESCE().es.srt | 2.06 KB | ||
| 158 Another Example of Using COALESCE().fr.srt | 2.13 KB | ||
| 158 Another Example of Using COALESCE().mp4 | 3.7 MB | ||
| 158 Another Example of Using COALESCE().pt.srt | 2.08 KB | ||
| 159 Another example of using COALESCE() - exercise 1.html | 1.1 KB | ||
| 160 Another example of using COALESCE() - solution 1.html | 1.2 KB | ||
| 161 Another example of using COALESCE() - exercise 2.html | 1.18 KB | ||
| 162 Another example of using COALESCE() - solution 2.html | 1.33 KB | ||
| 14 SQL Joins | |||
| 163 Introduction to JOINs.en.srt | 5.08 KB | ||
| 163 Introduction to JOINs.es.srt | 5.48 KB | ||
| 163 Introduction to JOINs.fr.srt | 5.56 KB | ||
| 163 Introduction to JOINs.mp4 | 7.22 MB | ||
| 163 Introduction to JOINs.pt.srt | 5.53 KB | ||
| 163 Introduction-to-Joins.pdf | 775.87 KB | ||
| 164 Intro to JOINs - exercise 1.html | 1.81 KB | ||
| 165 Intro to JOINs - solution 1.html | 2.44 KB | ||
| 166 Intro to JOINs - exercise 2.html | 2.48 KB | ||
| 167 INNER JOIN - Part I.en.srt | 6.78 KB | ||
| 167 INNER JOIN - Part I.es.srt | 7.44 KB | ||
| 167 INNER JOIN - Part I.fr.srt | 7.41 KB | ||
| 167 INNER JOIN - Part I.mp4 | 12.42 MB | ||
| 167 INNER JOIN - Part I.pt.srt | 7.35 KB | ||
| 167 INNER-JOIN.pdf | 778.46 KB | ||
| 168 INNER JOIN - Part II.en.srt | 6.64 KB | ||
| 168 INNER JOIN - Part II.es.srt | 7.14 KB | ||
| 168 INNER JOIN - Part II.fr.srt | 7.07 KB | ||
| 168 INNER JOIN - Part II.mp4 | 11.62 MB | ||
| 168 INNER JOIN - Part II.pt.srt | 7.06 KB | ||
| 169 INNER JOIN - Part II - exercise.html | 1012 B | ||
| 170 INNER JOIN - Part II - solution.html | 1.35 KB | ||
| 171 A Note on Using Joins.en.srt | 5.01 KB | ||
| 171 A Note on Using Joins.es.srt | 5.38 KB | ||
| 171 A Note on Using Joins.fr.srt | 5.38 KB | ||
| 171 A Note on Using Joins.mp4 | 10.76 MB | ||
| 171 A Note on Using Joins.pt.srt | 5.36 KB | ||
| 172 Duplicate Records.en.srt | 5.26 KB | ||
| 172 Duplicate Records.es.srt | 5.56 KB | ||
| 172 Duplicate Records.fr.srt | 5.67 KB | ||
| 172 Duplicate Records.mp4 | 12.73 MB | ||
| 172 Duplicate Records.pt.srt | 5.57 KB | ||
| 172 Duplicate-Records.pdf | 336.98 KB | ||
| 173 LEFT JOIN - Part I.en.srt | 5.8 KB | ||
| 173 LEFT JOIN - Part I.es.srt | 6.38 KB | ||
| 173 LEFT JOIN - Part I.fr.srt | 6.36 KB | ||
| 173 LEFT JOIN - Part I.mp4 | 14.02 MB | ||
| 173 LEFT JOIN - Part I.pt.srt | 6.21 KB | ||
| 173 LEFT-JOIN.pdf | 739.04 KB | ||
| 174 LEFT JOIN - Part II.en.srt | 6.99 KB | ||
| 174 LEFT JOIN - Part II.es.srt | 7.56 KB | ||
| 174 LEFT JOIN - Part II.fr.srt | 7.45 KB | ||
| 174 LEFT JOIN - Part II.mp4 | 14.82 MB | ||
| 174 LEFT JOIN - Part II.pt.srt | 7.47 KB | ||
| 175 LEFT JOIN - Part II - exercise.html | 1.28 KB | ||
| 176 LEFT JOIN - Part II - solution.html | 1.48 KB | ||
| 177 RIGHT JOIN.en.srt | 5.1 KB | ||
| 177 RIGHT JOIN.es.srt | 5.66 KB | ||
| 177 RIGHT JOIN.fr.srt | 5.66 KB | ||
| 177 RIGHT JOIN.mp4 | 32.09 MB | ||
| 177 RIGHT JOIN.pt.srt | 5.49 KB | ||
| 177 RIGHT-JOIN.pdf | 856.26 KB | ||
| 178 The new and the old join syntax.en.srt | 5.33 KB | ||
| 178 The new and the old join syntax.es.srt | 5.76 KB | ||
| 178 The new and the old join syntax.fr.srt | 5.67 KB | ||
| 178 The new and the old join syntax.mp4 | 9.17 MB | ||
| 178 The new and the old join syntax.pt.srt | 5.7 KB | ||
| 178 The-New-and-the-Old-Join-Syntax.pdf | 718.72 KB | ||
| 179 The new and the old join syntax - exercise.html | 1.05 KB | ||
| 180 The new and the old join syntax - solution.html | 1.9 KB | ||
| 181 JOIN and WHERE Used Together.en.srt | 3.47 KB | ||
| 181 JOIN and WHERE Used Together.es.srt | 3.66 KB | ||
| 181 JOIN and WHERE Used Together.fr.srt | 3.67 KB | ||
| 181 JOIN and WHERE Used Together.mp4 | 6.55 MB | ||
| 181 JOIN and WHERE Used Together.pt.srt | 3.61 KB | ||
| 181 JOIN-and-WHERE-Used-Together.pdf | 397.99 KB | ||
| 182 JOIN and WHERE Used Together - exercise.html | 1.02 KB | ||
| 183 JOIN and WHERE Used Together - solution.html | 1.46 KB | ||
| 184 CROSS JOIN.en.srt | 9.89 KB | ||
| 184 CROSS JOIN.es.srt | 10.84 KB | ||
| 184 CROSS JOIN.fr.srt | 10.7 KB | ||
| 184 CROSS JOIN.mp4 | 89.99 MB | ||
| 184 CROSS JOIN.pt.srt | 10.68 KB | ||
| 184 CROSS-JOIN.pdf | 313.67 KB | ||
| 185 CROSS JOIN - exercise 1.html | 1014 B | ||
| 186 CROSS JOIN - solution 1.html | 1.24 KB | ||
| 187 CROSS JOIN - exercise 2.html | 1 KB | ||
| 188 CROSS JOIN - solution 2.html | 1.4 KB | ||
| 189 Using Aggregate Functions with Joins.en.srt | 2.79 KB | ||
| 189 Using Aggregate Functions with Joins.es.srt | 3 KB | ||
| 189 Using Aggregate Functions with Joins.fr.srt | 3.12 KB | ||
| 189 Using Aggregate Functions with Joins.mp4 | 6.21 MB | ||
| 189 Using Aggregate Functions with Joins.pt.srt | 3.02 KB | ||
| 190 JOIN more than two tables in SQL.en.srt | 4.83 KB | ||
| 190 JOIN more than two tables in SQL.es.srt | 5.29 KB | ||
| 190 JOIN more than two tables in SQL.fr.srt | 5.19 KB | ||
| 190 JOIN more than two tables in SQL.mp4 | 10.94 MB | ||
| 190 JOIN more than two tables in SQL.pt.srt | 5.21 KB | ||
| 190 JOIN-More-Than-Two-Tables-in-SQL.pdf | 624.23 KB | ||
| 191 Join more than two tables in SQL - exercise.html | 993 B | ||
| 192 Join more than two tables in SQL - solution.html | 2.86 KB | ||
| 193 Tips and tricks for joins.en.srt | 6.84 KB | ||
| 193 Tips and tricks for joins.es.srt | 7.38 KB | ||
| 193 Tips and tricks for joins.fr.srt | 7.33 KB | ||
| 193 Tips and tricks for joins.mp4 | 50.91 MB | ||
| 193 Tips and tricks for joins.pt.srt | 7.29 KB | ||
| 193 Tips-and-Tricks-for-Joins.pdf | 479.19 KB | ||
| 194 Tips and tricks for joins - exercise.html | 970 B | ||
| 195 Tips and tricks for joins - solution.html | 1.19 KB | ||
| 196 UNION vs UNION ALL.en.srt | 6.33 KB | ||
| 196 UNION vs UNION ALL.es.srt | 6.8 KB | ||
| 196 UNION vs UNION ALL.fr.srt | 6.72 KB | ||
| 196 UNION vs UNION ALL.mp4 | 8.54 MB | ||
| 196 UNION vs UNION ALL.pt.srt | 6.7 KB | ||
| 196 UNION-vs-UNION-ALL.pdf | 823.75 KB | ||
| 197 UNION vs UNION ALL - exercise.html | 1.02 KB | ||
| 198 UNION vs UNION ALL - solution.html | 2.04 KB | ||
| 15 SQL Subqueries | |||
| 199 SQL Subqueries with IN nested inside WHERE.en.srt | 5.04 KB | ||
| 199 SQL Subqueries with IN nested inside WHERE.es.srt | 5.58 KB | ||
| 199 SQL Subqueries with IN nested inside WHERE.fr.srt | 5.51 KB | ||
| 199 SQL Subqueries with IN nested inside WHERE.mp4 | 6.71 MB | ||
| 199 SQL Subqueries with IN nested inside WHERE.pt.srt | 5.5 KB | ||
| 199 Subqueries-IN-WHERE.pdf | 1.07 MB | ||
| 200 SQL Subqueries with IN nested inside WHERE - exercise.html | 1.03 KB | ||
| 201 SQL Subqueries with IN nested inside WHERE - solution.html | 1.42 KB | ||
| 202 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE.en.srt | 4.21 KB | ||
| 202 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE.es.srt | 4.74 KB | ||
| 202 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE.fr.srt | 4.71 KB | ||
| 202 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE.mp4 | 8.64 MB | ||
| 202 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE.pt.srt | 4.58 KB | ||
| 202 Subqueries-EXISTS-WHERE.pdf | 1 MB | ||
| 203 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - exercise.html | 1.06 KB | ||
| 204 SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - solution.html | 1.49 KB | ||
| 205 SQL Subqueries nested in SELECT and FROM.en.srt | 8.63 KB | ||
| 205 SQL Subqueries nested in SELECT and FROM.es.srt | 9.29 KB | ||
| 205 SQL Subqueries nested in SELECT and FROM.fr.srt | 9.06 KB | ||
| 205 SQL Subqueries nested in SELECT and FROM.mp4 | 19.91 MB | ||
| 205 SQL Subqueries nested in SELECT and FROM.pt.srt | 9.11 KB | ||
| 205 Subqueries-SELECT-FROM.pdf | 403.81 KB | ||
| 206 SQL Subqueries nested in SELECT and FROM - exercise 1.html | 1.08 KB | ||
| 207 SQL Subqueries nested in SELECT and FROM - solution 1.html | 1.17 KB | ||
| 208 SQL Subqueries nested in SELECT and FROM - exercise 2.html | 1.93 KB | ||
| 209 SQL Subqueries nested in SELECT and FROM - solution 2.html | 909 B | ||
| 209 Subqueries-SELECT-FROM-Solution.sql | 1.85 KB | ||
| 16 SQL Self Join | |||
| 210 SQL-Self-Join.pdf | 703.86 KB | ||
| 210 Self Join.en.srt | 8.65 KB | ||
| 210 Self Join.es.srt | 9.12 KB | ||
| 210 Self Join.fr.srt | 9.25 KB | ||
| 210 Self Join.mp4 | 20.83 MB | ||
| 210 Self Join.pt.srt | 9.14 KB | ||
| 17 SQL Views | |||
| 211 SQL-Views.pdf | 1.01 MB | ||
| 211 Views.en.srt | 8.13 KB | ||
| 211 Views.es.srt | 8.82 KB | ||
| 211 Views.fr.srt | 8.57 KB | ||
| 211 Views.mp4 | 17.48 MB | ||
| 211 Views.pt.srt | 8.79 KB | ||
| 212 Views - exercise.html | 1.12 KB | ||
| 213 Views - solution.html | 1.24 KB | ||
| 18 Stored routines | |||
| 214 Introduction to stored routines.en.srt | 4.39 KB | ||
| 214 Introduction to stored routines.es.srt | 4.74 KB | ||
| 214 Introduction to stored routines.fr.srt | 4.72 KB | ||
| 214 Introduction to stored routines.mp4 | 7.23 MB | ||
| 214 Introduction to stored routines.pt.srt | 4.76 KB | ||
| 214 Introduction-to-Stored-Routines.pdf | 729.67 KB | ||
| 215 The MySQL syntax for stored procedures.en.srt | 5.7 KB | ||
| 215 The MySQL syntax for stored procedures.es.srt | 6.01 KB | ||
| 215 The MySQL syntax for stored procedures.fr.srt | 5.99 KB | ||
| 215 The MySQL syntax for stored procedures.mp4 | 5.96 MB | ||
| 215 The MySQL syntax for stored procedures.pt.srt | 6.07 KB | ||
| 215 The-MySQL-Syntax-for-Stored-Procedures.pdf | 911.08 KB | ||
| 216 Stored procedures - Example - Part I.en.srt | 3.35 KB | ||
| 216 Stored procedures - Example - Part I.es.srt | 3.66 KB | ||
| 216 Stored procedures - Example - Part I.fr.srt | 3.61 KB | ||
| 216 Stored procedures - Example - Part I.mp4 | 7.23 MB | ||
| 216 Stored procedures - Example - Part I.pt.srt | 3.59 KB | ||
| 217 Stored procedures - Example - Part II.en.srt | 6.13 KB | ||
| 217 Stored procedures - Example - Part II.es.srt | 6.79 KB | ||
| 217 Stored procedures - Example - Part II.fr.srt | 6.73 KB | ||
| 217 Stored procedures - Example - Part II.mp4 | 11.17 MB | ||
| 217 Stored procedures - Example - Part II.pt.srt | 6.69 KB | ||
| 218 Stored procedures - Example - Part II - exercise.html | 1005 B | ||
| 219 Stored procedures - Example - Part II - solution.html | 1.6 KB | ||
| 220 Another way to create a procedure.en.srt | 3.62 KB | ||
| 220 Another way to create a procedure.es.srt | 4.06 KB | ||
| 220 Another way to create a procedure.fr.srt | 3.95 KB | ||
| 220 Another way to create a procedure.mp4 | 5.43 MB | ||
| 220 Another way to create a procedure.pt.srt | 3.98 KB | ||
| 221 Stored procedures with an input parameter.en.srt | 7.56 KB | ||
| 221 Stored procedures with an input parameter.es.srt | 8.2 KB | ||
| 221 Stored procedures with an input parameter.fr.srt | 8.18 KB | ||
| 221 Stored procedures with an input parameter.mp4 | 17.07 MB | ||
| 221 Stored procedures with an input parameter.pt.srt | 8.08 KB | ||
| 221 Stored-Procedures-with-an-Input-Parameter.pdf | 547.71 KB | ||
| 222 Stored procedures with an output parameter.en.srt | 4 KB | ||
| 222 Stored procedures with an output parameter.es.srt | 4.23 KB | ||
| 222 Stored procedures with an output parameter.fr.srt | 4.26 KB | ||
| 222 Stored procedures with an output parameter.mp4 | 8.52 MB | ||
| 222 Stored procedures with an output parameter.pt.srt | 4.16 KB | ||
| 222 Stored-Procedures-with-an-Output-Parameter.pdf | 429.39 KB | ||
| 223 Stored procedures with an output parameter - exercise.html | 1.02 KB | ||
| 224 Stored procedures with an output parameter - solution.html | 1.83 KB | ||
| 225 Variables.en.srt | 7.5 KB | ||
| 225 Variables.es.srt | 7.88 KB | ||
| 225 Variables.fr.srt | 7.84 KB | ||
| 225 Variables.mp4 | 15.97 MB | ||
| 225 Variables.pdf | 718.33 KB | ||
| 225 Variables.pt.srt | 7.88 KB | ||
| 226 Variables - exercise.html | 1.14 KB | ||
| 227 Variables - solution.html | 1023 B | ||
| 228 User-Defined-Functions-in-MySQL.pdf | 511.99 KB | ||
| 228 User-defined functions in MySQL.en.srt | 5.75 KB | ||
| 228 User-defined functions in MySQL.es.srt | 6.18 KB | ||
| 228 User-defined functions in MySQL.fr.srt | 6.09 KB | ||
| 228 User-defined functions in MySQL.mp4 | 8.03 MB | ||
| 228 User-defined functions in MySQL.pt.srt | 6 KB | ||
| 229 User-defined functions in MySQL - exercise.html | 1.29 KB | ||
| 230 User-defined functions in MySQL - solution.html | 2.55 KB | ||
| 231 Stored routines - conclusion.en.srt | 4.69 KB | ||
| 231 Stored routines - conclusion.es.srt | 5.13 KB | ||
| 231 Stored routines - conclusion.fr.srt | 5.2 KB | ||
| 231 Stored routines - conclusion.mp4 | 8.18 MB | ||
| 231 Stored routines - conclusion.pt.srt | 5.05 KB | ||
| 231 Stored-Routines-Conclusion.pdf | 713.87 KB | ||
| 19 Advanced SQL Topics | |||
| 232 Types of MySQL Variables - Local Variables.en.srt | 5.73 KB | ||
| 232 Types of MySQL Variables - Local Variables.es.srt | 6.15 KB | ||
| 232 Types of MySQL Variables - Local Variables.fr.srt | 6.2 KB | ||
| 232 Types of MySQL Variables - Local Variables.mp4 | 11.57 MB | ||
| 232 Types of MySQL Variables - Local Variables.pt.srt | 6.1 KB | ||
| 232 Types-of-MySQL-Variables-Local-Variables.pdf | 866.29 KB | ||
| 233 Session Variables.en.srt | 6.56 KB | ||
| 233 Session Variables.es.srt | 6.81 KB | ||
| 233 Session Variables.fr.srt | 6.94 KB | ||
| 233 Session Variables.mp4 | 11.96 MB | ||
| 233 Session Variables.pt.srt | 6.83 KB | ||
| 233 Session-Variables.pdf | 1.82 MB | ||
| 234 Global Variables.en.srt | 2.72 KB | ||
| 234 Global Variables.es.srt | 2.95 KB | ||
| 234 Global Variables.fr.srt | 2.9 KB | ||
| 234 Global Variables.mp4 | 5.01 MB | ||
| 234 Global Variables.pt.srt | 3.01 KB | ||
| 234 Global-Variables.pdf | 676.25 KB | ||
| 235 User-Defined vs System Variables.en.srt | 5.07 KB | ||
| 235 User-Defined vs System Variables.es.srt | 5.55 KB | ||
| 235 User-Defined vs System Variables.fr.srt | 5.67 KB | ||
| 235 User-Defined vs System Variables.mp4 | 10.96 MB | ||
| 235 User-Defined vs System Variables.pt.srt | 5.66 KB | ||
| 235 User-Defined-vs-System-Variables.pdf | 699.41 KB | ||
| 236 MySQL Triggers.html | 1.36 KB | ||
| 236 MySQL-Triggers.sql | 9.73 KB | ||
| 237 MySQL Triggers - exercise.html | 1.03 KB | ||
| 238 MySQL Triggers - solution.html | 1.88 KB | ||
| 239 MySQL Indexes.en.srt | 8.25 KB | ||
| 239 MySQL Indexes.es.srt | 8.94 KB | ||
| 239 MySQL Indexes.fr.srt | 8.95 KB | ||
| 239 MySQL Indexes.mp4 | 18.21 MB | ||
| 239 MySQL Indexes.pt.srt | 8.94 KB | ||
| 239 MySQL-Indexes.pdf | 1.29 MB | ||
| 240 MySQL Indexes - exercise 1.html | 907 B | ||
| 241 MySQL Indexes - solution 1.html | 1 KB | ||
| 242 MySQL Indexes - exercise 2.html | 1.1 KB | ||
| 243 MySQL Indexes - solution 2.html | 1.44 KB | ||
| 244 The CASE Statement.en.srt | 6.86 KB | ||
| 244 The CASE Statement.es.srt | 7.49 KB | ||
| 244 The CASE Statement.fr.srt | 7.33 KB | ||
| 244 The CASE Statement.mp4 | 59.41 MB | ||
| 244 The CASE Statement.pt.srt | 7.35 KB | ||
| 244 The-CASE-Statement.pdf | 302.12 KB | ||
| 245 The CASE Statement - exercise 1.html | 1.21 KB | ||
| 246 The CASE Statement - solution 1.html | 1.57 KB | ||
| 247 The CASE Statement - exercise 2.html | 1.22 KB | ||
| 248 The CASE Statement - solution 2.html | 2.63 KB | ||
| 249 The CASE Statement - exercise 3.html | 1.25 KB | ||
| 250 The CASE Statement - solution 3.html | 1.58 KB | ||
| 20 Combining SQL and Tableau - Introduction | |||
| 251 The Advantages of Software Integration.en.srt | 7.08 KB | ||
| 251 The Advantages of Software Integration.es.srt | 7.55 KB | ||
| 251 The Advantages of Software Integration.fr.srt | 7.56 KB | ||
| 251 The Advantages of Software Integration.mp4 | 92.4 MB | ||
| 251 The Advantages of Software Integration.pt.srt | 7.48 KB | ||
| 252 Why Combining SQL and Tableau is useful.en.srt | 6.28 KB | ||
| 252 Why Combining SQL and Tableau is useful.es.srt | 6.88 KB | ||
| 252 Why Combining SQL and Tableau is useful.fr.srt | 7.02 KB | ||
| 252 Why Combining SQL and Tableau is useful.mp4 | 85.35 MB | ||
| 252 Why Combining SQL and Tableau is useful.pt.srt | 6.79 KB | ||
| 253 Installing Tableau Public.en.srt | 2.24 KB | ||
| 253 Installing Tableau Public.es.srt | 2.4 KB | ||
| 253 Installing Tableau Public.fr.srt | 2.42 KB | ||
| 253 Installing Tableau Public.mp4 | 27.35 MB | ||
| 253 Installing Tableau Public.pt.srt | 2.45 KB | ||
| 254 Loading the employees_mod Database.en.srt | 4 KB | ||
| 254 Loading the employees_mod Database.es.srt | 4.36 KB | ||
| 254 Loading the employees_mod Database.fr.srt | 4.47 KB | ||
| 254 Loading the employees_mod Database.mp4 | 28.53 MB | ||
| 254 Loading the employees_mod Database.pt.srt | 4.36 KB | ||
| 254 The-employees-mod-Database.txt | 66 B | ||
| 254 employees-mod-db.pdf | 129.65 KB | ||
| 255 Loading the employees_mod Database.html | 1.45 KB | ||
| 255 The-employees-mod-Database.txt | 66 B | ||
| 255 employees-mod-db.pdf | 129.65 KB | ||
| 21 Combining SQL and Tableau - Task 1 | |||
| 256 Task 1.en.srt | 7.13 KB | ||
| 256 Task 1.es.srt | 7.61 KB | ||
| 256 Task 1.fr.srt | 7.8 KB | ||
| 256 Task 1.mp4 | 33.52 MB | ||
| 256 Task 1.pt.srt | 7.63 KB | ||
| 257 Task 1 - Text.html | 1003 B | ||
| 258 Task 1 SQL Solution.en.srt | 5.62 KB | ||
| 258 Task 1 SQL Solution.es.srt | 6.02 KB | ||
| 258 Task 1 SQL Solution.fr.srt | 5.91 KB | ||
| 258 Task 1 SQL Solution.mp4 | 43.16 MB | ||
| 258 Task 1 SQL Solution.pt.srt | 5.9 KB | ||
| 259 Task 1 SQL Solution - Code.html | 1.37 KB | ||
| 260 Transferring a Dataset from SQL to Tableau.en.srt | 5.05 KB | ||
| 260 Transferring a Dataset from SQL to Tableau.es.srt | 5.46 KB | ||
| 260 Transferring a Dataset from SQL to Tableau.fr.srt | 5.52 KB | ||
| 260 Transferring a Dataset from SQL to Tableau.mp4 | 31.42 MB | ||
| 260 Transferring a Dataset from SQL to Tableau.pt.srt | 5.42 KB | ||
| 261 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I.en.srt | 7.46 KB | ||
| 261 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I.es.srt | 8.1 KB | ||
| 261 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I.fr.srt | 8.15 KB | ||
| 261 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I.mp4 | 40.54 MB | ||
| 261 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part I.pt.srt | 7.94 KB | ||
| 262 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II.en.srt | 6.8 KB | ||
| 262 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II.es.srt | 7.33 KB | ||
| 262 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II.fr.srt | 7.51 KB | ||
| 262 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II.mp4 | 45.1 MB | ||
| 262 Chart 1 Visualizing and Analyzing the Solution in Tableau - Part II.pt.srt | 7.31 KB | ||
| 22 Combining SQL and Tableau - Task 2 | |||
| 263 Task 2.en.srt | 4.64 KB | ||
| 263 Task 2.es.srt | 4.91 KB | ||
| 263 Task 2.fr.srt | 4.89 KB | ||
| 263 Task 2.mp4 | 28.84 MB | ||
| 263 Task 2.pt.srt | 4.82 KB | ||
| 264 Task 2 - Text.html | 991 B | ||
| 265 Task 2 SQL Solution.en.srt | 4.28 KB | ||
| 265 Task 2 SQL Solution.es.srt | 4.62 KB | ||
| 265 Task 2 SQL Solution.fr.srt | 4.48 KB | ||
| 265 Task 2 SQL Solution.mp4 | 39.28 MB | ||
| 265 Task 2 SQL Solution.pt.srt | 4.52 KB | ||
| 266 Task 2 SQL Solution - Code.html | 1.62 KB | ||
| 267 Chart 2 Visualizing and Analyzing the Solution in Tableau.en.srt | 7.33 KB | ||
| 267 Chart 2 Visualizing and Analyzing the Solution in Tableau.es.srt | 8.02 KB | ||
| 267 Chart 2 Visualizing and Analyzing the Solution in Tableau.fr.srt | 8.04 KB | ||
| 267 Chart 2 Visualizing and Analyzing the Solution in Tableau.mp4 | 48.93 MB | ||
| 267 Chart 2 Visualizing and Analyzing the Solution in Tableau.pt.srt | 7.84 KB | ||
| 23 Combining SQL and Tableau - Task 3 | |||
| 268 Task 3.en.srt | 2.84 KB | ||
| 268 Task 3.es.srt | 2.95 KB | ||
| 268 Task 3.fr.srt | 3.01 KB | ||
| 268 Task 3.mp4 | 13.07 MB | ||
| 268 Task 3.pt.srt | 3.02 KB | ||
| 269 Task 3 - Text.html | 1021 B | ||
| 270 Task 3 SQL Solution.en.srt | 3.88 KB | ||
| 270 Task 3 SQL Solution.es.srt | 4.12 KB | ||
| 270 Task 3 SQL Solution.fr.srt | 4.1 KB | ||
| 270 Task 3 SQL Solution.mp4 | 33.12 MB | ||
| 270 Task 3 SQL Solution.pt.srt | 4.12 KB | ||
| 271 Task 3 SQL Solution - Code.html | 1.34 KB | ||
| 272 Chart 3 Visualizing and Analyzing the Solution in Tableau.en.srt | 5.81 KB | ||
| 272 Chart 3 Visualizing and Analyzing the Solution in Tableau.es.srt | 6.28 KB | ||
| 272 Chart 3 Visualizing and Analyzing the Solution in Tableau.fr.srt | 6.1 KB | ||
| 272 Chart 3 Visualizing and Analyzing the Solution in Tableau.mp4 | 40.32 MB | ||
| 272 Chart 3 Visualizing and Analyzing the Solution in Tableau.pt.srt | 6.23 KB | ||
| 24 Combining SQL and Tableau - Task 4 | |||
| 273 Task 4.en.srt | 3.6 KB | ||
| 273 Task 4.es.srt | 3.88 KB | ||
| 273 Task 4.fr.srt | 3.79 KB | ||
| 273 Task 4.mp4 | 23.56 MB | ||
| 273 Task 4.pt.srt | 3.83 KB | ||
| 274 Task 4 - Text.html | 1.15 KB | ||
| 275 Task 4 Solution in SQL.en.srt | 3.14 KB | ||
| 275 Task 4 Solution in SQL.es.srt | 3.4 KB | ||
| 275 Task 4 Solution in SQL.fr.srt | 3.32 KB | ||
| 275 Task 4 Solution in SQL.mp4 | 30.25 MB | ||
| 275 Task 4 Solution in SQL.pt.srt | 3.33 KB | ||
| 276 Task 4 Solution in SQL - Code.html | 1.53 KB | ||
| 277 Chart 4 Visualizing and Analyzing the Solution in Tableau.en.srt | 3.78 KB | ||
| 277 Chart 4 Visualizing and Analyzing the Solution in Tableau.es.srt | 4.1 KB | ||
| 277 Chart 4 Visualizing and Analyzing the Solution in Tableau.fr.srt | 4.12 KB | ||
| 277 Chart 4 Visualizing and Analyzing the Solution in Tableau.mp4 | 22.28 MB | ||
| 277 Chart 4 Visualizing and Analyzing the Solution in Tableau.pt.srt | 4.03 KB | ||
| 25 Combining SQL and Tableau - Task 5 | |||
| 278 Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau.en.srt | 6.69 KB | ||
| 278 Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau.es.srt | 7.23 KB | ||
| 278 Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau.fr.srt | 7.34 KB | ||
| 278 Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau.mp4 | 55.98 MB | ||
| 278 Task 5 Organizing Charts 1-4 into a Beautiful Dashboard using Tableau.pt.srt | 7.13 KB | ||
| 26 BONUS LECTURE | |||
| 279 Bonus Lecture Next Steps.html | 2.8 KB | ||
| ▲ 902 total files | |||
SQL -MySQL for Data Analytics and Business Intelligence 720p MP4
Description
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 274.1 MB | freecoursewb | 1 week | 17 | 1 | |
|
Udemy - Data Analytics for Beginners - Excel, SQL, and AI Dashboards Posted by
freecoursewb in Other
|
2.1 GB | freecoursewb | 4 weeks | 0 | 0 |
|
Udemy - Databricks Spark Streaming, Delta Lake and SQL, AI Analytics Posted by
freecoursewb in Other
|
3.3 GB | freecoursewb | 4 weeks | 1 | 5 |
| 2.5 GB | freecoursewb | 4 weeks | 26 | 4 | |
| 1.6 GB | freecoursewb | 1 month | 9 | 8 |
All Comments