|
|
1. Data Integrity-en_US.srt
|
SRT
|
614.4 B
|
|
|
1. Data Integrity.mp4
|
MP4
|
3.6 MB
|
|
|
1. Data Types-en_US.srt
|
SRT
|
1.2 KB
|
|
|
1. Data Types.mp4
|
MP4
|
4.3 MB
|
|
|
1. Introduction to Data Normalization-en_US.srt
|
SRT
|
1.4 KB
|
|
|
1. Introduction to Data Normalization.mp4
|
MP4
|
6.4 MB
|
|
|
1. Introduction to Indexes-en_US.srt
|
SRT
|
10.8 KB
|
|
|
1. Introduction to Indexes.mp4
|
MP4
|
46.8 MB
|
|
|
1. Library Database Exercise-en_US.srt
|
SRT
|
2.1 KB
|
|
|
1. Library Database Exercise.mp4
|
MP4
|
12.9 MB
|
|
|
1. Types of Relationships between Entities-en_US.srt
|
SRT
|
2.4 KB
|
|
|
1. Types of Relationships between Entities.mp4
|
MP4
|
12.8 MB
|
|
|
1. Welcome to the Course-en_US.srt
|
SRT
|
4 KB
|
|
|
1. Welcome to the Course.mp4
|
MP4
|
19.4 MB
|
|
|
1. What is a Database-en_US.srt
|
SRT
|
512 B
|
|
|
1. What is a Database.mp4
|
MP4
|
1.5 MB
|
|
|
1. What you will need for the demos-en_US.srt
|
SRT
|
1 KB
|
|
|
1. What you will need for the demos.mp4
|
MP4
|
3.1 MB
|
|
|
10. Key and Non-key Attributes-en_US.srt
|
SRT
|
921.6 B
|
|
|
10. Key and Non-key Attributes.mp4
|
MP4
|
5.1 MB
|
|
|
10. Many-to-Many Relationships-en_US.srt
|
SRT
|
3.3 KB
|
|
|
10. Many-to-Many Relationships.mp4
|
MP4
|
18.1 MB
|
|
|
10. Primary Key Recommendations-en_US.srt
|
SRT
|
1.2 KB
|
|
|
10. Primary Key Recommendations.mp4
|
MP4
|
5.5 MB
|
|
|
11. First Normal Form-en_US.srt
|
SRT
|
5 KB
|
|
|
11. First Normal Form.mp4
|
MP4
|
22.5 MB
|
|
|
11. Primary Key vs Unique Constraint-en_US.srt
|
SRT
|
1.3 KB
|
|
|
11. Primary Key vs Unique Constraint.mp4
|
MP4
|
7.4 MB
|
|
|
11. Self-Referencing Relationships-en_US.srt
|
SRT
|
1.3 KB
|
|
|
11. Self-Referencing Relationships.mp4
|
MP4
|
5.6 MB
|
|
|
12. CHECK Constraints-en_US.srt
|
SRT
|
4.9 KB
|
|
|
12. CHECK Constraints.mp4
|
MP4
|
19.6 MB
|
|
|
12. Multi-value and Multi-type Fields-en_US.srt
|
SRT
|
14.3 KB
|
|
|
12. Multi-value and Multi-type Fields.mp4
|
MP4
|
52.4 MB
|
|
|
12. Self-Referencing Relationships (demo)-en_US.srt
|
SRT
|
4 KB
|
|
|
12. Self-Referencing Relationships (demo).mp4
|
MP4
|
29.2 MB
|
|
|
13. First Normal Form (demo)-en_US.srt
|
SRT
|
11.5 KB
|
|
|
13. First Normal Form (demo).mp4
|
MP4
|
77.6 MB
|
|
|
13. Indexes-en_US.srt
|
SRT
|
1.7 KB
|
|
|
13. Indexes.mp4
|
MP4
|
5.8 MB
|
|
|
14. Second Normal Form-en_US.srt
|
SRT
|
8 KB
|
|
|
14. Second Normal Form.mp4
|
MP4
|
33.8 MB
|
|
|
14. Unique Indexes-en_US.srt
|
SRT
|
2.1 KB
|
|
|
14. Unique Indexes.mp4
|
MP4
|
6.6 MB
|
|
|
15. Primary Key and Unique Constraints (demo)-en_US.srt
|
SRT
|
19.2 KB
|
|
|
15. Primary Key and Unique Constraints (demo).mp4
|
MP4
|
147.4 MB
|
|
|
15. Second Normal Form (demo)-en_US.srt
|
SRT
|
8.8 KB
|
|
|
15. Second Normal Form (demo).mp4
|
MP4
|
66.8 MB
|
|
|
16. Transitive Dependencies-en_US.srt
|
SRT
|
1.3 KB
|
|
|
16. Transitive Dependencies.mp4
|
MP4
|
4.4 MB
|
|
|
17. Third Normal Form-en_US.srt
|
SRT
|
9.8 KB
|
|
|
17. Third Normal Form.mp4
|
MP4
|
40.2 MB
|
|
|
18. Third Normal Form (demo)-en_US.srt
|
SRT
|
5.1 KB
|
|
|
18. Third Normal Form (demo).mp4
|
MP4
|
49.5 MB
|
|
|
19. Boyce-Codd Normal Form-en_US.srt
|
SRT
|
4.4 KB
|
|
|
19. Boyce-Codd Normal Form.mp4
|
MP4
|
17.9 MB
|
|
|
2. How to install SQL Server and SSMS-en_US.srt
|
SRT
|
2.6 KB
|
|
|
2. How to install SQL Server and SSMS.mp4
|
MP4
|
19 MB
|
|
|
2. Identifying Relationships between Entities-en_US.srt
|
SRT
|
3.5 KB
|
|
|
2. Identifying Relationships between Entities.mp4
|
MP4
|
18.3 MB
|
|
|
2. Index Types and Indexing Guidelines-en_US.srt
|
SRT
|
18.5 KB
|
|
|
2. Index Types and Indexing Guidelines.mp4
|
MP4
|
88.9 MB
|
|
|
2. Library Database Exercise Solution-en_US.srt
|
SRT
|
9.2 KB
|
|
|
2. Library Database Exercise Solution.mp4
|
MP4
|
77.5 MB
|
|
|
2. Naming Conventions-en_US.srt
|
SRT
|
1.1 KB
|
|
|
2. Naming Conventions.mp4
|
MP4
|
6.1 MB
|
|
|
2. Null Values-en_US.srt
|
SRT
|
1 KB
|
|
|
2. Null Values.mp4
|
MP4
|
5.6 MB
|
|
|
2. Types of Databases-en_US.srt
|
SRT
|
307.2 B
|
|
|
2. Types of Databases.mp4
|
MP4
|
971.8 KB
|
|
|
2. Why Normalize Data-en_US.srt
|
SRT
|
2.4 KB
|
|
|
2. Why Normalize Data.mp4
|
MP4
|
6.2 MB
|
|
|
20. 3NF vs BCNF-en_US.srt
|
SRT
|
1.5 KB
|
|
|
20. 3NF vs BCNF.mp4
|
MP4
|
5.7 MB
|
|
|
21. Remembering the Normal Forms-en_US.srt
|
SRT
|
2 KB
|
|
|
21. Remembering the Normal Forms.mp4
|
MP4
|
9.9 MB
|
|
|
22. Fourth Normal Form and Multivalued Dependencies-en_US.srt
|
SRT
|
5.8 KB
|
|
|
22. Fourth Normal Form and Multivalued Dependencies.mp4
|
MP4
|
28 MB
|
|
|
23. Fourth Normal Form (demo)-en_US.srt
|
SRT
|
4.1 KB
|
|
|
23. Fourth Normal Form (demo).mp4
|
MP4
|
33.4 MB
|
|
|
3. Create and Query a Table (demo)-en_US.srt
|
SRT
|
18.8 KB
|
|
|
3. Create and Query a Table (demo).mp4
|
MP4
|
129.4 MB
|
|
|
3. Decomposition Exercise-en_US.srt
|
SRT
|
2.7 KB
|
|
|
3. Decomposition Exercise.mp4
|
MP4
|
12.6 MB
|
|
|
3. Flat Files-en_US.srt
|
SRT
|
716.8 B
|
|
|
3. Flat Files.mp4
|
MP4
|
2.9 MB
|
|
|
3. Handling Nulls-en_US.srt
|
SRT
|
1.5 KB
|
|
|
3. Handling Nulls.mp4
|
MP4
|
6.6 MB
|
|
|
3. Index Types Part 2 - Composite vs Included Columns-en_US.srt
|
SRT
|
10.2 KB
|
|
|
3. Index Types Part 2 - Composite vs Included Columns.mp4
|
MP4
|
48 MB
|
|
|
3. Naming Conventions (demo)-en_US.srt
|
SRT
|
10.8 KB
|
|
|
3. Naming Conventions (demo).mp4
|
MP4
|
81 MB
|
|
|
3. One-to-Many Relationships Part 1-en_US.srt
|
SRT
|
2.2 KB
|
|
|
3. One-to-Many Relationships Part 1.mp4
|
MP4
|
10.4 MB
|
|
|
3. Update, Insert and Delete Anomalies-en_US.srt
|
SRT
|
5.7 KB
|
|
|
3. Update, Insert and Delete Anomalies.mp4
|
MP4
|
22.7 MB
|
|
|
4. Decomposition Exercise Solution-en_US.srt
|
SRT
|
5.8 KB
|
|
|
4. Decomposition Exercise Solution.mp4
|
MP4
|
35.3 MB
|
|
|
4. Handling Nulls (demo)-en_US.srt
|
SRT
|
12.4 KB
|
|
|
4. Handling Nulls (demo).mp4
|
MP4
|
92.5 MB
|
|
|
4. Introduction to the Normal Forms-en_US.srt
|
SRT
|
921.6 B
|
|
|
4. Introduction to the Normal Forms.mp4
|
MP4
|
3.5 MB
|
|
|
4. NoSQL Databases-en_US.srt
|
SRT
|
512 B
|
|
|
4. NoSQL Databases.mp4
|
MP4
|
2.2 MB
|
|
|
4. One-to-Many Relationships Part 2-en_US.srt
|
SRT
|
3.1 KB
|
|
|
4. One-to-Many Relationships Part 2.mp4
|
MP4
|
17.3 MB
|
|
|
5. Data Warehouses-en_US.srt
|
SRT
|
512 B
|
|
|
5. Data Warehouses.mp4
|
MP4
|
2.1 MB
|
|
|
5. Functional Dependencies-en_US.srt
|
SRT
|
5.9 KB
|
|
|
5. Functional Dependencies.mp4
|
MP4
|
23.5 MB
|
|
|
5. One-to-Many Relationships Part 3-en_US.srt
|
SRT
|
1.9 KB
|
|
|
5. One-to-Many Relationships Part 3.mp4
|
MP4
|
7.9 MB
|
|
|
5. Primary Key Constraint-en_US.srt
|
SRT
|
716.8 B
|
|
|
5. Primary Key Constraint.mp4
|
MP4
|
4 MB
|
|
|
6. Composite Primary Key-en_US.srt
|
SRT
|
1 KB
|
|
|
6. Composite Primary Key.mp4
|
MP4
|
4.9 MB
|
|
|
6. Foreign Key Constraint Summary-en_US.srt
|
SRT
|
921.6 B
|
|
|
6. Foreign Key Constraint Summary.mp4
|
MP4
|
5.7 MB
|
|
|
6. Relational Databases-en_US.srt
|
SRT
|
2.3 KB
|
|
|
6. Relational Databases.mp4
|
MP4
|
9.8 MB
|
|
|
6. Trivial Functional Dependencies-en_US.srt
|
SRT
|
2.1 KB
|
|
|
6. Trivial Functional Dependencies.mp4
|
MP4
|
8.4 MB
|
|
|
7. Functional Dependencies Exercise-en_US.srt
|
SRT
|
9 KB
|
|
|
7. Functional Dependencies Exercise.mp4
|
MP4
|
35 MB
|
|
|
7. Logical and Physical Design-en_US.srt
|
SRT
|
2.1 KB
|
|
|
7. Logical and Physical Design.mp4
|
MP4
|
8.2 MB
|
|
|
7. Natural Keys-en_US.srt
|
SRT
|
2 KB
|
|
|
7. Natural Keys.mp4
|
MP4
|
9.2 MB
|
|
|
7. One-to-Many Relationships (demo)-en_US.srt
|
SRT
|
10.5 KB
|
|
|
7. One-to-Many Relationships (demo).mp4
|
MP4
|
83.8 MB
|
|
|
8. Candidate Keys-en_US.srt
|
SRT
|
4.8 KB
|
|
|
8. Candidate Keys.mp4
|
MP4
|
16.5 MB
|
|
|
8. Common Table Terminology-en_US.srt
|
SRT
|
2.9 KB
|
|
|
8. Common Table Terminology.mp4
|
MP4
|
7.5 MB
|
|
|
8. One-to-One Relationships-en_US.srt
|
SRT
|
3.5 KB
|
|
|
8. One-to-One Relationships.mp4
|
MP4
|
16 MB
|
|
|
8. Surrogate Keys-en_US.srt
|
SRT
|
1 KB
|
|
|
8. Surrogate Keys.mp4
|
MP4
|
4.1 MB
|
|
|
9. Candidate keys vs Super Keys-en_US.srt
|
SRT
|
1.8 KB
|
|
|
9. Candidate keys vs Super Keys.mp4
|
MP4
|
9.8 MB
|
|
|
9. Main Benefit of Surrogate Keys-en_US.srt
|
SRT
|
1.8 KB
|
|
|
9. Main Benefit of Surrogate Keys.mp4
|
MP4
|
5.5 MB
|
|
|
9. One-to-One Relationships (demo)-en_US.srt
|
SRT
|
7.1 KB
|
|
|
9. One-to-One Relationships (demo).mp4
|
MP4
|
53.9 MB
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Create-and-Query-a-Simple-Table.sql
|
SQL
|
3.6 KB
|
|
|
Decomposition-Exercise-Solution.sql
|
SQL
|
1.6 KB
|
|
|
Decomposition-Exercise.sql
|
SQL
|
1.1 KB
|
|
|
First-Normal-Form.sql
|
SQL
|
6.5 KB
|
|
|
Fourth-Normal-Form.sql
|
SQL
|
3.4 KB
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
Handling-Nulls.sql
|
SQL
|
6.6 KB
|
|
|
Library-Database-Exercise.sql
|
SQL
|
2.7 KB
|
|
|
Library-Database-Solution.sql
|
SQL
|
1 KB
|
|
|
Naming-Conventions.sql
|
SQL
|
6.7 KB
|
|
|
One-to-Many-Relationships.sql
|
SQL
|
6.4 KB
|
|
|
One-to-One-Relationships.sql
|
SQL
|
5.7 KB
|
|
|
Primary-Key-and-Unique-Constraints.sql
|
SQL
|
11.9 KB
|
|
|
Second-Normal-Form.sql
|
SQL
|
6.7 KB
|
|
|
Self-Referencing-Relationships.sql
|
SQL
|
1.8 KB
|
|
|
Third-Normal-Form.sql
|
SQL
|
4.8 KB
|
