|
|
001 AND Operator.mp4
|
MP4
|
9.6 MB
|
|
|
001 AND Operator_en.srt
|
SRT
|
3.3 KB
|
|
|
001 Concatenation in MySQL.mp4
|
MP4
|
33.1 MB
|
|
|
001 Concatenation in MySQL_en.srt
|
SRT
|
11.4 KB
|
|
|
001 INNER JOIN.mp4
|
MP4
|
28.5 MB
|
|
|
001 INNER JOIN_en.srt
|
SRT
|
5.7 KB
|
|
|
001 Introduction to Aggregate Functions.mp4
|
MP4
|
22.1 MB
|
|
|
001 Introduction to Aggregate Functions_en.srt
|
SRT
|
6.7 KB
|
|
|
001 Introduction to Data Normalization.mp4
|
MP4
|
62.1 MB
|
|
|
001 Introduction to Data Normalization_en.srt
|
SRT
|
16.1 KB
|
|
|
001 Introduction.mp4
|
MP4
|
17.8 MB
|
|
|
001 Introduction_en.srt
|
SRT
|
3.4 KB
|
|
|
001 Self-contained Subqueries.mp4
|
MP4
|
20.8 MB
|
|
|
001 Self-contained Subqueries_en.srt
|
SRT
|
5.3 KB
|
|
|
001 UNION and UNION ALL.mp4
|
MP4
|
43.7 MB
|
|
|
001 UNION and UNION ALL_en.srt
|
SRT
|
8.2 KB
|
|
|
001 Understanding the Foundations of SQL.mp4
|
MP4
|
27.4 MB
|
|
|
001 Understanding the Foundations of SQL_en.srt
|
SRT
|
10.5 KB
|
|
|
001 Views.mp4
|
MP4
|
38 MB
|
|
|
001 Views_en.srt
|
SRT
|
11.3 KB
|
|
|
001 views-demo.sql
|
SQL
|
1.2 KB
|
|
|
002 Correlated Subqueries.mp4
|
MP4
|
29.6 MB
|
|
|
002 Correlated Subqueries_en.srt
|
SRT
|
7.1 KB
|
|
|
002 Course-Databases-MySQL.sql
|
SQL
|
505.3 KB
|
|
|
002 Create Table Statement.mp4
|
MP4
|
87.3 MB
|
|
|
002 Create Table Statement_en.srt
|
SRT
|
21.2 KB
|
|
|
002 Functional Dependencies.mp4
|
MP4
|
23.5 MB
|
|
|
002 Functional Dependencies_en.srt
|
SRT
|
6.2 KB
|
|
|
002 GROUP BY and Aggregate Functions.mp4
|
MP4
|
23.6 MB
|
|
|
002 GROUP BY and Aggregate Functions_en.srt
|
SRT
|
6.9 KB
|
|
|
002 LEFT OUTER JOIN and RIGHT OUTER JOIN.mp4
|
MP4
|
25.2 MB
|
|
|
002 LEFT OUTER JOIN and RIGHT OUTER JOIN_en.srt
|
SRT
|
4.3 KB
|
|
|
002 OR Operator.mp4
|
MP4
|
10.4 MB
|
|
|
002 OR Operator_en.srt
|
SRT
|
3.5 KB
|
|
|
002 SELECT Statement.mp4
|
MP4
|
31.1 MB
|
|
|
002 SELECT Statement_en.srt
|
SRT
|
12 KB
|
|
|
002 Set Operator Challenges.mp4
|
MP4
|
8.3 MB
|
|
|
002 Set Operator Challenges_en.srt
|
SRT
|
2.4 KB
|
|
|
002 Set-Operator-Challenges-including-hints.pdf
|
PDF
|
143.9 KB
|
|
|
002 Set-Operator-Challenges-without-hints.pdf
|
PDF
|
142.1 KB
|
|
|
002 String Manipulation Functions.mp4
|
MP4
|
30.5 MB
|
|
|
002 String Manipulation Functions_en.srt
|
SRT
|
11.8 KB
|
|
|
002 Windows Installation and setup of Course Databases.mp4
|
MP4
|
60.9 MB
|
|
|
002 Windows Installation and setup of Course Databases_en.srt
|
SRT
|
14 KB
|
|
|
003 CASE Expression.mp4
|
MP4
|
39 MB
|
|
|
003 CASE Expression_en.srt
|
SRT
|
7 KB
|
|
|
003 EXISTS.mp4
|
MP4
|
21.3 MB
|
|
|
003 EXISTS_en.srt
|
SRT
|
4.6 KB
|
|
|
003 FULL OUTER JOIN.mp4
|
MP4
|
17.6 MB
|
|
|
003 FULL OUTER JOIN_en.srt
|
SRT
|
4.4 KB
|
|
|
003 Functional Dependencies.mp4
|
MP4
|
35 MB
|
|
|
003 Functional Dependencies_en.srt
|
SRT
|
9.6 KB
|
|
|
003 HAVING Clause.mp4
|
MP4
|
18.5 MB
|
|
|
003 HAVING Clause_en.srt
|
SRT
|
5.8 KB
|
|
|
003 INSERT Statement.mp4
|
MP4
|
18.3 MB
|
|
|
003 INSERT Statement_en.srt
|
SRT
|
6.3 KB
|
|
|
003 Operator Precedence.mp4
|
MP4
|
15.6 MB
|
|
|
003 Operator Precedence_en.srt
|
SRT
|
4.8 KB
|
|
|
003 Overview of the Course Challenges.mp4
|
MP4
|
13.7 MB
|
|
|
003 Overview of the Course Challenges_en.srt
|
SRT
|
4.6 KB
|
|
|
003 SELECT Statement Challenges.mp4
|
MP4
|
7.9 MB
|
|
|
003 SELECT Statement Challenges_en.srt
|
SRT
|
2.5 KB
|
|
|
003 Solutions to the Set Operator Challenges.mp4
|
MP4
|
63.7 MB
|
|
|
003 Solutions to the Set Operator Challenges_en.srt
|
SRT
|
11 KB
|
|
|
003 Solutions-to-the-Set-Operator-Challenges.sql
|
SQL
|
1.9 KB
|
|
|
004 CASE Expression Challenges.mp4
|
MP4
|
25.6 MB
|
|
|
004 CASE Expression Challenges_en.srt
|
SRT
|
6.2 KB
|
|
|
004 CASE-Expression-Challenges-including-hints.pdf
|
PDF
|
191.3 KB
|
|
|
004 CASE-Expression-Challenges-without-hints.pptx
|
PPTX
|
57.4 KB
|
|
|
004 CREATE-TABLE-Challenges-including-hints.pdf
|
PDF
|
175.2 KB
|
|
|
004 CREATE-TABLE-Challenges-without-hints.pdf
|
PDF
|
157.3 KB
|
|
|
004 Candidate Keys and Super Keys.mp4
|
MP4
|
34.4 MB
|
|
|
004 Candidate Keys and Super Keys_en.srt
|
SRT
|
12.5 KB
|
|
|
004 Create Table Challenges.mp4
|
MP4
|
23.3 MB
|
|
|
004 Create Table Challenges_en.srt
|
SRT
|
6.4 KB
|
|
|
004 Entity-Relationship-Diagram.pdf
|
PDF
|
45.3 KB
|
|
|
004 IN Operator.mp4
|
MP4
|
13.3 MB
|
|
|
004 IN Operator_en.srt
|
SRT
|
3.8 KB
|
|
|
004 Integrity Constraints.mp4
|
MP4
|
63.4 MB
|
|
|
004 Integrity Constraints_en.srt
|
SRT
|
15.7 KB
|
|
|
004 Introduction to Window Functions.mp4
|
MP4
|
33.7 MB
|
|
|
004 Introduction to Window Functions_en.srt
|
SRT
|
7.7 KB
|
|
|
004 Link-to-SQL-Server-Course.txt
|
TXT
|
204.8 B
|
|
|
004 Logical Query Processing Order.mp4
|
MP4
|
38.2 MB
|
|
|
004 Logical Query Processing Order_en.srt
|
SRT
|
9 KB
|
|
|
004 Overview of Popular Relational Database Management Systems (Optional Lecture).mp4
|
MP4
|
21.9 MB
|
|
|
004 Overview of Popular Relational Database Management Systems (Optional Lecture)_en.srt
|
SRT
|
10.2 KB
|
|
|
004 Solutions to the SELECT Challenges.mp4
|
MP4
|
41.4 MB
|
|
|
004 Solutions to the SELECT Challenges_en.srt
|
SRT
|
9.8 KB
|
|
|
004 Solutions-to-the-SELECT-Challenges.sql
|
SQL
|
307.2 B
|
|
|
004 integrity-constraints-demo.sql
|
SQL
|
819.2 B
|
|
|
005 Common Table Expressions.mp4
|
MP4
|
35.7 MB
|
|
|
005 Common Table Expressions_en.srt
|
SRT
|
8.2 KB
|
|
|
005 First Normal Form.mp4
|
MP4
|
47.7 MB
|
|
|
005 First Normal Form_en.srt
|
SRT
|
12.7 KB
|
|
|
005 GROUP BY Challenges.mp4
|
MP4
|
12.2 MB
|
|
|
005 GROUP BY Challenges_en.srt
|
SRT
|
3.5 KB
|
|
|
005 GROUP-BY-Challenges-including-hints.pdf
|
PDF
|
135.1 KB
|
|
|
005 GROUP-BY-Challenges-without-hints.pdf
|
PDF
|
134.8 KB
|
|
|
005 Logical Operator Challenges.mp4
|
MP4
|
6.5 MB
|
|
|
005 Logical Operator Challenges_en.srt
|
SRT
|
2.5 KB
|
|
|
005 Logical-Operator-Challenges-including-hints.pdf
|
PDF
|
139.2 KB
|
|
|
005 Logical-Operator-Challenges-without-hints.pdf
|
PDF
|
138.7 KB
|
|
|
005 Many-to-many Relationships.mp4
|
MP4
|
33.7 MB
|
|
|
005 Many-to-many Relationships_en.srt
|
SRT
|
8.1 KB
|
|
|
005 SELECT DISTINCT.mp4
|
MP4
|
21.5 MB
|
|
|
005 SELECT DISTINCT_en.srt
|
SRT
|
6.8 KB
|
|
|
005 Solutions to the CASE Expression Challenges.mp4
|
MP4
|
97.6 MB
|
|
|
005 Solutions to the CASE Expression Challenges_en.srt
|
SRT
|
17.8 KB
|
|
|
005 Solutions to the Create Table Challenges.mp4
|
MP4
|
45.5 MB
|
|
|
005 Solutions to the Create Table Challenges_en.srt
|
SRT
|
9.7 KB
|
|
|
005 Solutions-to-the-CASE-Expresion-Challenges.sql
|
SQL
|
3 KB
|
|
|
005 Solutions-to-the-CREATE-TABLE-Challenges.sql
|
SQL
|
1.5 KB
|
|
|
006 Avoiding the NOT IN Trap.mp4
|
MP4
|
48 MB
|
|
|
006 Avoiding the NOT IN Trap_en.srt
|
SRT
|
12.3 KB
|
|
|
006 Date and Time Functions in MySQL.mp4
|
MP4
|
90.6 MB
|
|
|
006 Date and Time Functions in MySQL_en.srt
|
SRT
|
17.8 KB
|
|
|
006 Date-and-time-functions.sql
|
SQL
|
4.1 KB
|
|
|
006 Join Challenges.mp4
|
MP4
|
7.8 MB
|
|
|
006 Join Challenges_en.srt
|
SRT
|
2.2 KB
|
|
|
006 Join-Challenges-including-hints.pdf
|
PDF
|
112.7 KB
|
|
|
006 Join-Challenges-without-hints.pdf
|
PDF
|
110.4 KB
|
|
|
006 Restructuring Multi-valued and Multi-Type Fields.mp4
|
MP4
|
21.7 MB
|
|
|
006 Restructuring Multi-valued and Multi-Type Fields_en.srt
|
SRT
|
6.7 KB
|
|
|
006 SELECT DISTINCT Challenges.mp4
|
MP4
|
7.8 MB
|
|
|
006 SELECT DISTINCT Challenges_en.srt
|
SRT
|
2.5 KB
|
|
|
006 Solution-to-the-UPDATE-Challenge.sql
|
SQL
|
102.4 B
|
|
|
006 Solutions to the GROUP BY Challenges.mp4
|
MP4
|
69.3 MB
|
|
|
006 Solutions to the GROUP BY Challenges_en.srt
|
SRT
|
14.2 KB
|
|
|
006 Solutions to the Logical Operator Challenges.mp4
|
MP4
|
41.5 MB
|
|
|
006 Solutions to the Logical Operator Challenges_en.srt
|
SRT
|
7 KB
|
|
|
006 Solutions-to-the-GROUP-BY-Challenges.sql
|
SQL
|
1.6 KB
|
|
|
006 Solutions-to-the-Logical-Operator-Challenges.sql
|
SQL
|
1.1 KB
|
|
|
006 UPDATE Statement.mp4
|
MP4
|
18 MB
|
|
|
006 UPDATE Statement_en.srt
|
SRT
|
5.9 KB
|
|
|
006 create-and-populate-tables-dept-and-emp.sql
|
SQL
|
1 KB
|
|
|
007 DELETE Statement.mp4
|
MP4
|
12.1 MB
|
|
|
007 DELETE Statement_en.srt
|
SRT
|
4 KB
|
|
|
007 Function Challenges.mp4
|
MP4
|
36.8 MB
|
|
|
007 Function Challenges_en.srt
|
SRT
|
8.7 KB
|
|
|
007 Function-Challenges-including-hints.pdf
|
PDF
|
293.7 KB
|
|
|
007 Function-Challenges-without-hints.pdf
|
PDF
|
262.6 KB
|
|
|
007 Second Normal Form.mp4
|
MP4
|
17.1 MB
|
|
|
007 Second Normal Form_en.srt
|
SRT
|
5.7 KB
|
|
|
007 Solution-to-the-DELETE-Challenge.sql
|
SQL
|
102.4 B
|
|
|
007 Solutions to the Join Challenges.mp4
|
MP4
|
38 MB
|
|
|
007 Solutions to the Join Challenges_en.srt
|
SRT
|
7.9 KB
|
|
|
007 Solutions to the SELECT DISTINCT Challenges.mp4
|
MP4
|
19 MB
|
|
|
007 Solutions to the SELECT DISTINCT Challenges_en.srt
|
SRT
|
4.1 KB
|
|
|
007 Solutions-to-SELECT-DISTINCT-Challenges.sql
|
SQL
|
307.2 B
|
|
|
007 Solutions-to-the-Join-Challenges.sql
|
SQL
|
1.2 KB
|
|
|
007 Subquery Challenges.mp4
|
MP4
|
23.4 MB
|
|
|
007 Subquery Challenges_en.srt
|
SRT
|
6.9 KB
|
|
|
007 Subquery-Challenge-including-hints.pdf
|
PDF
|
194.4 KB
|
|
|
007 Subquery-Challenges-without-hints.pdf
|
PDF
|
187.1 KB
|
|
|
007 create-and-populate-tables-dept-and-emp.sql
|
SQL
|
1 KB
|
|
|
008 Composite Joins - joining on multiple columns.mp4
|
MP4
|
39.6 MB
|
|
|
008 Composite Joins - joining on multiple columns_en.srt
|
SRT
|
7.7 KB
|
|
|
008 MySQL-documentation-links.txt
|
TXT
|
409.6 B
|
|
|
008 Row Ordering - ORDER BY.mp4
|
MP4
|
23.8 MB
|
|
|
008 Row Ordering - ORDER BY_en.srt
|
SRT
|
10 KB
|
|
|
008 Solutions to the Function Challenges.mp4
|
MP4
|
71.4 MB
|
|
|
008 Solutions to the Function Challenges_en.srt
|
SRT
|
14.9 KB
|
|
|
008 Solutions to the Subquery Challenges.mp4
|
MP4
|
76 MB
|
|
|
008 Solutions to the Subquery Challenges_en.srt
|
SRT
|
16 KB
|
|
|
008 Solutions-to-the-Function-Challenges.sql
|
SQL
|
2.7 KB
|
|
|
008 Solutions-to-the-Subquery-Challenges.sql
|
SQL
|
2.8 KB
|
|
|
008 TRUNCATE TABLE Statement.mp4
|
MP4
|
38 MB
|
|
|
008 TRUNCATE TABLE Statement_en.srt
|
SRT
|
5.8 KB
|
|
|
008 Third Normal Form.mp4
|
MP4
|
33.1 MB
|
|
|
008 Third Normal Form_en.srt
|
SRT
|
9.7 KB
|
|
|
009 ALTER TABLE Statement.mp4
|
MP4
|
23.8 MB
|
|
|
009 ALTER TABLE Statement_en.srt
|
SRT
|
8.9 KB
|
|
|
009 Boyce-Codd Normal Form.mp4
|
MP4
|
56 MB
|
|
|
009 Boyce-Codd Normal Form_en.srt
|
SRT
|
12.1 KB
|
|
|
009 Joining more than two tables.mp4
|
MP4
|
24.2 MB
|
|
|
009 Joining more than two tables_en.srt
|
SRT
|
6.1 KB
|
|
|
009 LIMIT Clause.mp4
|
MP4
|
17.8 MB
|
|
|
009 LIMIT Clause_en.srt
|
SRT
|
4.9 KB
|
|
|
010 ALTER Table Challenges.mp4
|
MP4
|
5.3 MB
|
|
|
010 ALTER Table Challenges_en.srt
|
SRT
|
1.8 KB
|
|
|
010 ALTER-TABLE-Challenges-including-hints.pdf
|
PDF
|
123.2 KB
|
|
|
010 ALTER-TABLE-Challenges-without-hints.pdf
|
PDF
|
117.4 KB
|
|
|
010 ORDER BY Challenges.mp4
|
MP4
|
7.5 MB
|
|
|
010 ORDER BY Challenges_en.srt
|
SRT
|
2.3 KB
|
|
|
010 ORDER-BY-Challenges-including-hints.pdf
|
PDF
|
163.9 KB
|
|
|
010 ORDER-BY-Challenges-without-hints.pdf
|
PDF
|
161.6 KB
|
|
|
010 Predicate placement - ON clause vs WHERE clause.mp4
|
MP4
|
35.9 MB
|
|
|
010 Predicate placement - ON clause vs WHERE clause_en.srt
|
SRT
|
7.4 KB
|
|
|
011 Self-referencing Joins.mp4
|
MP4
|
17.9 MB
|
|
|
011 Self-referencing Joins_en.srt
|
SRT
|
4.1 KB
|
|
|
011 Solutions to the ALTER TABLE Challenges.mp4
|
MP4
|
33.7 MB
|
|
|
011 Solutions to the ALTER TABLE Challenges_en.srt
|
SRT
|
6.3 KB
|
|
|
011 Solutions to the ORDER BY Challenges.mp4
|
MP4
|
43.6 MB
|
|
|
011 Solutions to the ORDER BY Challenges_en.srt
|
SRT
|
6.3 KB
|
|
|
011 Solutions-to-the-ALTER-TABLE-Challenges.sql
|
SQL
|
614.4 B
|
|
|
011 Solutions-to-the-ORDER-BY-Challenges.sql
|
SQL
|
1.3 KB
|
|
|
012 Cross Joins.mp4
|
MP4
|
8.6 MB
|
|
|
012 Cross Joins_en.srt
|
SRT
|
2.4 KB
|
|
|
012 DROP TABLE Statement.mp4
|
MP4
|
37.8 MB
|
|
|
012 DROP TABLE Statement_en.srt
|
SRT
|
9.2 KB
|
|
|
012 DROP-TABLE-demo.sql
|
SQL
|
716.8 B
|
|
|
012 WHERE Clause - Three-valued Logic.mp4
|
MP4
|
17.7 MB
|
|
|
012 WHERE Clause - Three-valued Logic_en.srt
|
SRT
|
5.6 KB
|
|
|
012 create-and-populate-tables-dept-and-emp.sql
|
SQL
|
921.6 B
|
|
|
013 Advanced Join Challenges.mp4
|
MP4
|
30 MB
|
|
|
013 Advanced Join Challenges_en.srt
|
SRT
|
6.9 KB
|
|
|
013 Advanced-Join-Challenges-including-hints.pdf
|
PDF
|
167.4 KB
|
|
|
013 Advanced-Join-Challenges-without-hints.pdf
|
PDF
|
158.9 KB
|
|
|
013 Entity-Relationship-Diagram.pdf
|
PDF
|
45.3 KB
|
|
|
013 Replacing nulls in queries.mp4
|
MP4
|
26.7 MB
|
|
|
013 Replacing nulls in queries_en.srt
|
SRT
|
6.4 KB
|
|
|
013 Transactions.mp4
|
MP4
|
44.7 MB
|
|
|
013 Transactions_en.srt
|
SRT
|
12.8 KB
|
|
|
013 transaction-example.sql
|
SQL
|
1.7 KB
|
|
|
014 Solutions to the Advanced Join Challenges.mp4
|
MP4
|
142.7 MB
|
|
|
014 Solutions to the Advanced Join Challenges_en.srt
|
SRT
|
25.9 KB
|
|
|
014 Solutions-to-the-Advanced-Join-Challenges.sql
|
SQL
|
2.6 KB
|
|
|
014 Stored Procedures.mp4
|
MP4
|
71.9 MB
|
|
|
014 Stored Procedures_en.srt
|
SRT
|
18.2 KB
|
|
|
014 Stored-procedure-demo.sql
|
SQL
|
1.1 KB
|
|
|
014 WHERE Clause - Comparison Operators.mp4
|
MP4
|
13.8 MB
|
|
|
014 WHERE Clause - Comparison Operators_en.srt
|
SRT
|
4.8 KB
|
|
|
015 Solution-to-the-UNIQUE-Constraint-Challenge.sql
|
SQL
|
1.1 KB
|
|
|
015 Solutions-to-the-WHERE-Clause-Challenges.sql
|
SQL
|
614.4 B
|
|
|
015 UNIQUE Constraints.mp4
|
MP4
|
40.8 MB
|
|
|
015 UNIQUE Constraints_en.srt
|
SRT
|
9.3 KB
|
|
|
015 WHERE Clause Challenges.mp4
|
MP4
|
7.6 MB
|
|
|
015 WHERE Clause Challenges_en.srt
|
SRT
|
2.5 KB
|
|
|
015 WHERE-Clause-Challenges-including-hints.pdf
|
PDF
|
154.9 KB
|
|
|
016 CHECK Constraints.mp4
|
MP4
|
17.7 MB
|
|
|
016 CHECK Constraints_en.srt
|
SRT
|
5.8 KB
|
|
|
016 Solution-to-the-CHECK-Constraint-Challenge.sql
|
SQL
|
204.8 B
|
|
|
016 Solutions to the WHERE Clause Challenges.mp4
|
MP4
|
25.2 MB
|
|
|
016 Solutions to the WHERE Clause Challenges_en.srt
|
SRT
|
4.6 KB
|
|
|
016 WHERE-Clause-Challenges-including-hints.pdf
|
PDF
|
154.9 KB
|
|
|
016 WHERE-Clause-Challenges-without-hints.pdf
|
PDF
|
123.2 KB
|
|
|
017 Introduction to Collations and Pattern Matching.mp4
|
MP4
|
45.4 MB
|
|
|
017 Introduction to Collations and Pattern Matching_en.srt
|
SRT
|
11.6 KB
|
|
|
018 Pattern Matching - Part 2 - The LIKE Operator.mp4
|
MP4
|
17.4 MB
|
|
|
018 Pattern Matching - Part 2 - The LIKE Operator_en.srt
|
SRT
|
5 KB
|
|
|
019 Pattern Matching Challenges.mp4
|
MP4
|
3.8 MB
|
|
|
019 Pattern Matching Challenges_en.srt
|
SRT
|
1.1 KB
|
|
|
019 Pattern-Matching-Challenges-including-hints.pdf
|
PDF
|
139.9 KB
|
|
|
019 Pattern-Matching-Challenges-without-hints.pdf
|
PDF
|
117.4 KB
|
|
|
020 Solutions to the Pattern Matching Challenges.mp4
|
MP4
|
18.4 MB
|
|
|
020 Solutions to the Pattern Matching Challenges_en.srt
|
SRT
|
4.2 KB
|
|
|
020 Solutions-to-Pattern-Matching-Challenges.sql
|
SQL
|
819.2 B
|
|
|
021 MySQL Data Types.mp4
|
MP4
|
32.4 MB
|
|
|
021 MySQL Data Types_en.srt
|
SRT
|
9.6 KB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
