Udemy - Database Design for Relational Databases using SQL Server

seeders: 15
leechers: 9
updated:
Download torrent
Added by freecoursewb in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...
  • Downloads: 123
  • Language: English

Files

[ FreeCourseWeb.com ] Udemy - Database Design for Relational Databases using SQL Server
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1. Introduction
    • 1. Welcome to the Course-en_US.srt (4.0 KB)
    • 1. Welcome to the Course.mp4 (19.4 MB)
    2. Database Basics
    • 1. What is a Database-en_US.srt (0.5 KB)
    • 1. What is a Database.mp4 (1.5 MB)
    • 2. Types of Databases-en_US.srt (0.3 KB)
    • 2. Types of Databases.mp4 (971.8 KB)
    • 3. Flat Files-en_US.srt (0.7 KB)
    • 3. Flat Files.mp4 (2.9 MB)
    • 4. NoSQL Databases-en_US.srt (0.5 KB)
    • 4. NoSQL Databases.mp4 (2.2 MB)
    • 5. Data Warehouses-en_US.srt (0.5 KB)
    • 5. Data Warehouses.mp4 (2.1 MB)
    • 6. Relational Databases-en_US.srt (2.3 KB)
    • 6. Relational Databases.mp4 (9.8 MB)
    • 7. Logical and Physical Design-en_US.srt (2.1 KB)
    • 7. Logical and Physical Design.mp4 (8.2 MB)
    • 8. Common Table Terminology-en_US.srt (2.9 KB)
    • 8. Common Table Terminology.mp4 (7.5 MB)
    3. Getting Started with SQL Server
    • 1. What you will need for the demos-en_US.srt (1.0 KB)
    • 1. What you will need for the demos.mp4 (3.1 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.0 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)
    • Create-and-Query-a-Simple-Table.sql (3.6 KB)
    4. Data Integrity Constraints
    • 1. Data Integrity-en_US.srt (0.6 KB)
    • 1. Data Integrity.mp4 (3.6 MB)
    • 10. Primary Key Recommendations-en_US.srt (1.2 KB)
    • 10. Primary Key Recommendations.mp4 (5.5 MB)
    • 11. Primary Key vs Unique Constraint-en_US.srt (1.3 KB)
    • 11. Primary Key vs Unique Constraint.mp4 (7.4 MB)
    • 12. CHECK Constraints-en_US.srt (4.9 KB)
    • 12. CHECK Constraints.mp4 (19.6 MB)
    • 13. Indexes-en_US.srt (1.7 KB)
    • 13. Indexes.mp4 (5.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)
    • 2. Null Values-en_US.srt (1.0 KB)
    • 2. Null Values.mp4 (5.6 MB)
    • 3. Handling Nulls-en_US.srt (1.5 KB)
    • 3. Handling Nulls.mp4 (6.6 MB)
    • 4. Handling Nulls (demo)-en_US.srt (12.4 KB)
    • 4. Handling Nulls (demo).mp4 (92.5 MB)
    • 5. Primary Key Constraint-en_US.srt (0.7 KB)
    • 5. Primary Key Constraint.mp4 (4.0 MB)
    • 6. Composite Primary Key-en_US.srt (1.0 KB)
    • 6. Composite Primary Key.mp4 (4.9 MB)
    • 7. Natural Keys-en_US.srt (2.0 KB)
    • 7. Natural Keys.mp4 (9.2 MB)
    • 8. Surrogate Keys-en_US.srt (1.0 KB)
    • 8. Surrogate Keys.mp4 (4.1 MB)
    • 9. Main Benefit of Surrogate Keys-en_US.srt (1.8 KB)
    • 9. Main Benefit of Surrogate Keys.mp4 (5.5 MB)
    • Handling-Nulls.sql (6.6 KB)
    • Primary-Key-and-Unique-Constraints.sql (11.9 KB)
    5. Types of Relationships
    • 1. Types of Relationships between Entities-en_US.srt (2.4 KB)
    • 1. Types of Relationships between Entities.mp4 (12.8 MB)
    • 10. Many-to-Many Relationships-en_US.srt (3.3 KB)
    • 10. Many-to-Many Relationships.mp4 (18.1 MB)
    • 11. Self-Referencing Relationships-en_US.srt (1.3 KB)
    • 11. Self-Referencing Relationships.mp4 (5.6 MB)
    • 12. Self-Referencing Relationships (demo)-en_US.srt (4.0 KB)
    • 12. Self-Referencing Relationships (demo).mp4 (29.2 MB)
    • 2. Identifying Relationships between Entities-en_US.srt (3.5 KB)
    • 2. Identifying Relationships between Entities.mp4 (18.3 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)
    • 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. One-to-Many Relationships Part 3-en_US.srt (1.9 KB)
    • 5. One-to-Many Relationships Part 3.mp4 (7.9 MB)
    • 6. Foreign Key Constraint Summary-en_US.srt (0.9 KB)
    • 6. Foreign Key Constraint Summary.mp4 (5.7 MB)
    • 7. One-to-Many Relationships (demo)-en_US.srt (10.5 KB)
    • 7. One-to-Many Relationships (demo).mp4 (83.8 MB)
    • 8. One-to-One Relationships-en_US.srt (3.5 KB)
    • 8. One-to-One Relationships.mp4 (16.0 MB)
    • 9. One-to-One Relationships (demo)-en_US.srt (7.1 KB)
    • 9. One-to-One Relationships (demo).mp4 (53.9 MB)
    • One-to-Many-Relationships.sql (6.4 KB)
    • One-to-One-Relationships.sql (5.7 KB)
    • Self-Referencing-Relationships.sql (1.8 KB)
    6. Data Normalization
    • 1. Introduction to Data Normalization-en_US.srt (1.4 KB)
    • 1. Introduction to Data Normalization.mp4 (6.4 MB)
    • 10. Key and Non-key Attributes-en_US.srt (0.9 KB)
    • 10. Key and Non-key Attributes.mp4 (5.1 MB)
    • 11. First Normal Form-en_US.srt (5.0 KB)
    • 11. First Normal Form.mp4 (22.5 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)
    • 13. First Normal Form (demo)-en_US.srt (11.5 KB)
    • 13. First Normal Form (demo).mp4 (77.6 MB)
    • 14. Second Normal Form-en_US.srt (8.0 KB)
    • 14. Second Normal Form.mp4 (33.8 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)

    • Description

      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.



Download torrent
1.8 GB
seeders:15
leechers:9
Udemy - Database Design for Relational Databases using SQL Server

Trackers

tracker name
udp://tracker.torrent.eu.org:451/announce
udp://tracker.tiny-vps.com:6969/announce
http://tracker.foreverpirates.co:80/announce
udp://tracker.cyberia.is:6969/announce
udp://exodus.desync.com:6969/announce
udp://explodie.org:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://9.rarbg.to:2780/announce
udp://tracker.internetwarriors.net:1337/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://open.stealth.si:80/announce
udp://9.rarbg.to:2900/announce
udp://9.rarbg.me:2720/announce
udp://opentor.org:2710/announce
µTorrent compatible trackers list

Download torrent
1.8 GB
seeders:15
leechers:9
Udemy - Database Design for Relational Databases using SQL Server

Torrent hash: DB3772599382AEEEA3A5025006E93C90040115BA