| 1. Data Integrity-en_US.srt | 614.4 B | ||
| 1. Data Integrity.mp4 | 3.6 MB | ||
| 1. Data Types-en_US.srt | 1.2 KB | ||
| 1. Data Types.mp4 | 4.3 MB | ||
| 1. Introduction to Data Normalization-en_US.srt | 1.4 KB | ||
| 1. Introduction to Data Normalization.mp4 | 6.4 MB | ||
| 1. Introduction to Indexes-en_US.srt | 10.8 KB | ||
| 1. Introduction to Indexes.mp4 | 46.8 MB | ||
| 1. Library Database Exercise-en_US.srt | 2.1 KB | ||
| 1. Library Database Exercise.mp4 | 12.9 MB | ||
| 1. Types of Relationships between Entities-en_US.srt | 2.4 KB | ||
| 1. Types of Relationships between Entities.mp4 | 12.8 MB | ||
| 1. Welcome to the Course-en_US.srt | 4 KB | ||
| 1. Welcome to the Course.mp4 | 19.4 MB | ||
| 1. What is a Database-en_US.srt | 512 B | ||
| 1. What is a Database.mp4 | 1.5 MB | ||
| 1. What you will need for the demos-en_US.srt | 1 KB | ||
| 1. What you will need for the demos.mp4 | 3.1 MB | ||
| 10. Key and Non-key Attributes-en_US.srt | 921.6 B | ||
| 10. Key and Non-key Attributes.mp4 | 5.1 MB | ||
| 10. Many-to-Many Relationships-en_US.srt | 3.3 KB | ||
| 10. Many-to-Many Relationships.mp4 | 18.1 MB | ||
| 10. Primary Key Recommendations-en_US.srt | 1.2 KB | ||
| 10. Primary Key Recommendations.mp4 | 5.5 MB | ||
| 11. First Normal Form-en_US.srt | 5 KB | ||
| 11. First Normal Form.mp4 | 22.5 MB | ||
| 11. Primary Key vs Unique Constraint-en_US.srt | 1.3 KB | ||
| 11. Primary Key vs Unique Constraint.mp4 | 7.4 MB | ||
| 11. Self-Referencing Relationships-en_US.srt | 1.3 KB | ||
| 11. Self-Referencing Relationships.mp4 | 5.6 MB | ||
| 12. CHECK Constraints-en_US.srt | 4.9 KB | ||
| 12. CHECK Constraints.mp4 | 19.6 MB | ||
| 12. Multi-value and Multi-type Fields-en_US.srt | 14.3 KB | ||
| 12. Multi-value and Multi-type Fields.mp4 | 52.4 MB | ||
| 12. Self-Referencing Relationships (demo)-en_US.srt | 4 KB | ||
| 12. Self-Referencing Relationships (demo).mp4 | 29.2 MB | ||
| 13. First Normal Form (demo)-en_US.srt | 11.5 KB | ||
| 13. First Normal Form (demo).mp4 | 77.6 MB | ||
| 13. Indexes-en_US.srt | 1.7 KB | ||
| 13. Indexes.mp4 | 5.8 MB | ||
| 14. Second Normal Form-en_US.srt | 8 KB | ||
| 14. Second Normal Form.mp4 | 33.8 MB | ||
| 14. Unique Indexes-en_US.srt | 2.1 KB | ||
| 14. Unique Indexes.mp4 | 6.6 MB | ||
| 15. Primary Key and Unique Constraints (demo)-en_US.srt | 19.2 KB | ||
| 15. Primary Key and Unique Constraints (demo).mp4 | 147.4 MB | ||
| 15. Second Normal Form (demo)-en_US.srt | 8.8 KB | ||
| 15. Second Normal Form (demo).mp4 | 66.8 MB | ||
| 16. Transitive Dependencies-en_US.srt | 1.3 KB | ||
| 16. Transitive Dependencies.mp4 | 4.4 MB | ||
| 17. Third Normal Form-en_US.srt | 9.8 KB | ||
| 17. Third Normal Form.mp4 | 40.2 MB | ||
| 18. Third Normal Form (demo)-en_US.srt | 5.1 KB | ||
| 18. Third Normal Form (demo).mp4 | 49.5 MB | ||
| 19. Boyce-Codd Normal Form-en_US.srt | 4.4 KB | ||
| 19. Boyce-Codd Normal Form.mp4 | 17.9 MB | ||
| 2. How to install SQL Server and SSMS-en_US.srt | 2.6 KB | ||
| 2. How to install SQL Server and SSMS.mp4 | 19 MB | ||
| 2. Identifying Relationships between Entities-en_US.srt | 3.5 KB | ||
| 2. Identifying Relationships between Entities.mp4 | 18.3 MB | ||
| 2. Index Types and Indexing Guidelines-en_US.srt | 18.5 KB | ||
| 2. Index Types and Indexing Guidelines.mp4 | 88.9 MB | ||
| 2. Library Database Exercise Solution-en_US.srt | 9.2 KB | ||
| 2. Library Database Exercise Solution.mp4 | 77.5 MB | ||
| 2. Naming Conventions-en_US.srt | 1.1 KB | ||
| 2. Naming Conventions.mp4 | 6.1 MB | ||
| 2. Null Values-en_US.srt | 1 KB | ||
| 2. Null Values.mp4 | 5.6 MB | ||
| 2. Types of Databases-en_US.srt | 307.2 B | ||
| 2. Types of Databases.mp4 | 971.8 KB | ||
| 2. Why Normalize Data-en_US.srt | 2.4 KB | ||
| 2. Why Normalize Data.mp4 | 6.2 MB | ||
| 20. 3NF vs BCNF-en_US.srt | 1.5 KB | ||
| 20. 3NF vs BCNF.mp4 | 5.7 MB | ||
| 21. Remembering the Normal Forms-en_US.srt | 2 KB | ||
| 21. Remembering the Normal Forms.mp4 | 9.9 MB | ||
| 22. Fourth Normal Form and Multivalued Dependencies-en_US.srt | 5.8 KB | ||
| 22. Fourth Normal Form and Multivalued Dependencies.mp4 | 28 MB | ||
| 23. Fourth Normal Form (demo)-en_US.srt | 4.1 KB | ||
| 23. Fourth Normal Form (demo).mp4 | 33.4 MB | ||
| 3. Create and Query a Table (demo)-en_US.srt | 18.8 KB | ||
| 3. Create and Query a Table (demo).mp4 | 129.4 MB | ||
| 3. Decomposition Exercise-en_US.srt | 2.7 KB | ||
| 3. Decomposition Exercise.mp4 | 12.6 MB | ||
| 3. Flat Files-en_US.srt | 716.8 B | ||
| 3. Flat Files.mp4 | 2.9 MB | ||
| 3. Handling Nulls-en_US.srt | 1.5 KB | ||
| 3. Handling Nulls.mp4 | 6.6 MB | ||
| 3. Index Types Part 2 - Composite vs Included Columns-en_US.srt | 10.2 KB | ||
| 3. Index Types Part 2 - Composite vs Included Columns.mp4 | 48 MB | ||
| 3. Naming Conventions (demo)-en_US.srt | 10.8 KB | ||
| 3. Naming Conventions (demo).mp4 | 81 MB | ||
| 3. One-to-Many Relationships Part 1-en_US.srt | 2.2 KB | ||
| 3. One-to-Many Relationships Part 1.mp4 | 10.4 MB | ||
| 3. Update, Insert and Delete Anomalies-en_US.srt | 5.7 KB | ||
| 3. Update, Insert and Delete Anomalies.mp4 | 22.7 MB | ||
| 4. Decomposition Exercise Solution-en_US.srt | 5.8 KB | ||
| 4. Decomposition Exercise Solution.mp4 | 35.3 MB | ||
| 4. Handling Nulls (demo)-en_US.srt | 12.4 KB | ||
| 4. Handling Nulls (demo).mp4 | 92.5 MB | ||
| 4. Introduction to the Normal Forms-en_US.srt | 921.6 B | ||
| 4. Introduction to the Normal Forms.mp4 | 3.5 MB | ||
| 4. NoSQL Databases-en_US.srt | 512 B | ||
| 4. NoSQL Databases.mp4 | 2.2 MB | ||
| 4. One-to-Many Relationships Part 2-en_US.srt | 3.1 KB | ||
| 4. One-to-Many Relationships Part 2.mp4 | 17.3 MB | ||
| 5. Data Warehouses-en_US.srt | 512 B | ||
| 5. Data Warehouses.mp4 | 2.1 MB | ||
| 5. Functional Dependencies-en_US.srt | 5.9 KB | ||
| 5. Functional Dependencies.mp4 | 23.5 MB | ||
| 5. One-to-Many Relationships Part 3-en_US.srt | 1.9 KB | ||
| 5. One-to-Many Relationships Part 3.mp4 | 7.9 MB | ||
| 5. Primary Key Constraint-en_US.srt | 716.8 B | ||
| 5. Primary Key Constraint.mp4 | 4 MB | ||
| 6. Composite Primary Key-en_US.srt | 1 KB | ||
| 6. Composite Primary Key.mp4 | 4.9 MB | ||
| 6. Foreign Key Constraint Summary-en_US.srt | 921.6 B | ||
| 6. Foreign Key Constraint Summary.mp4 | 5.7 MB | ||
| 6. Relational Databases-en_US.srt | 2.3 KB | ||
| 6. Relational Databases.mp4 | 9.8 MB | ||
| 6. Trivial Functional Dependencies-en_US.srt | 2.1 KB | ||
| 6. Trivial Functional Dependencies.mp4 | 8.4 MB | ||
| 7. Functional Dependencies Exercise-en_US.srt | 9 KB | ||
| 7. Functional Dependencies Exercise.mp4 | 35 MB | ||
| 7. Logical and Physical Design-en_US.srt | 2.1 KB | ||
| 7. Logical and Physical Design.mp4 | 8.2 MB | ||
| 7. Natural Keys-en_US.srt | 2 KB | ||
| 7. Natural Keys.mp4 | 9.2 MB | ||
| 7. One-to-Many Relationships (demo)-en_US.srt | 10.5 KB | ||
| 7. One-to-Many Relationships (demo).mp4 | 83.8 MB | ||
| 8. Candidate Keys-en_US.srt | 4.8 KB | ||
| 8. Candidate Keys.mp4 | 16.5 MB | ||
| 8. Common Table Terminology-en_US.srt | 2.9 KB | ||
| 8. Common Table Terminology.mp4 | 7.5 MB | ||
| 8. One-to-One Relationships-en_US.srt | 3.5 KB | ||
| 8. One-to-One Relationships.mp4 | 16 MB | ||
| 8. Surrogate Keys-en_US.srt | 1 KB | ||
| 8. Surrogate Keys.mp4 | 4.1 MB | ||
| 9. Candidate keys vs Super Keys-en_US.srt | 1.8 KB | ||
| 9. Candidate keys vs Super Keys.mp4 | 9.8 MB | ||
| 9. Main Benefit of Surrogate Keys-en_US.srt | 1.8 KB | ||
| 9. Main Benefit of Surrogate Keys.mp4 | 5.5 MB | ||
| 9. One-to-One Relationships (demo)-en_US.srt | 7.1 KB | ||
| 9. One-to-One Relationships (demo).mp4 | 53.9 MB | ||
| Bonus Resources.txt | 307.2 B | ||
| Create-and-Query-a-Simple-Table.sql | 3.6 KB | ||
| Decomposition-Exercise-Solution.sql | 1.6 KB | ||
| Decomposition-Exercise.sql | 1.1 KB | ||
| First-Normal-Form.sql | 6.5 KB | ||
| Fourth-Normal-Form.sql | 3.4 KB | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| Handling-Nulls.sql | 6.6 KB | ||
| Library-Database-Exercise.sql | 2.7 KB | ||
| Library-Database-Solution.sql | 1 KB | ||
| Naming-Conventions.sql | 6.7 KB | ||
| One-to-Many-Relationships.sql | 6.4 KB | ||
| One-to-One-Relationships.sql | 5.7 KB | ||
| Primary-Key-and-Unique-Constraints.sql | 11.9 KB | ||
| Second-Normal-Form.sql | 6.7 KB | ||
| Self-Referencing-Relationships.sql | 1.8 KB | ||
| Third-Normal-Form.sql | 4.8 KB | ||
| ▲ 161 total files | |||
Database Design for Relational Databases using SQL Server
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.76 GB | Duration: 5h 34m
What you'll learn
Learn Best Practices for Relational Database Design
Understand Relational Theory
Learn the data normalization process
Understand the First, Second, Third and Fourth Normal Forms
Understand Boyce-Codd normal form
Identify relationship types between entities
How to enforce database relationships including one-to-one, one-to-many, and many-to-many
Learn functional dependencies
Learn multivalued dependencies
Learn what Update, Insert and Delete anomalies are
Surrogate keys vs Natural keys
Learn the difference Candidate keys and Super Keys
Learn how to implement physical design using SQL Server
Create database tables and alter existing tables
Create SQL Queries and Views
Requirements
A basic knowledge of computers
Description
Start learning Database Design Today!
A lot of IT professionals have a good working knowledge of SQL yet lack the foundational knowledge of relational database design. Learning database design and the relational model will put you ahead of the game. This course covers all the essential aspects of relational database design with practical s given in SQL Server. You will learn how to spot un-normalized data structures and how to correct them. You will learn all about the process of data normalization and why it is important. This includes the various normal forms such as Boyce-Codd normal form and fourth normal form. This course also covers tips on how to identify relationships between entities and how to correctly model them in a relational database.
You will be able to understand advanced database design concepts with the aid of intuitive diagrams and practical examples. You will learn how to identify functional dependencies and transitive dependencies in your data. You will learn the different types of keys and when to use them. In addition, you will learn the different types of relationships such as one-to-one, one-to-many, many-to-many, and self-referencing relationships. More importantly, the end of the course you will know how to enforce these relationships by using integrity constraints.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
|
Udemy - Trial Abap System With Hana Database On Cloud Platform (BTP) Posted by
freecoursewb in Other
|
286.9 MB | freecoursewb | 1 month | 3 | 1 |
| 784.5 MB | freecoursewb | 2 months | 15 | 1 | |
| 799.5 MB | freecoursewb | 4 months | 11 | 0 | |
| 1.5 GB | freecoursewb | 5 months | 7 | 3 | |
| 653.3 MB | freecoursewb | 5 months | 1 | 0 |
All Comments