One-to-many relationships

Contents

• Introduction Introduction

  • Organizing data in a database

    54s
  • What you should know

    40s
  • Making the most of the exercise files

    1m 4s
  • Set up the database servers

    7m 23s
• 1. Data Types 1. Data Types

  • Data integrity concepts

    4m 52s
  • The role of data types

    3m 55s
  • Numeric data types

    6m 21s
  • Character data types

    6m 33s
  • Date and time data types

    6m 24s
  • Additional common types

    5m 34s
  • Challenge: Choosing data types

    1m 16s
  • Solution: Choosing data types

    7m 21s
• 2. Design a Normalized Database 2. Design a Normalized Database

  • Protect data integrity with normalization

    4m 10s
  • First normal form

    3m 16s
  • Second normal form

    3m 27s
  • Third normal form

    3m 3s
  • Denormalization considerations

    4m 11s
• 3. Identify Rows with Primary Keys 3. Identify Rows with Primary Keys

  • Purpose of a primary key

    3m 55s
  • Establish the table's primary key

    6m 59s
  • Natural keys

    2m 42s
  • Composite keys

    5m 33s
  • Surrogate keys

    4m 40s
  • Challenge: Add a primary key to a table

    53s
  • Solution: Add a primary key to a table

    5m 51s
• 4. Link Data with Foreign Keys 4. Link Data with Foreign Keys

  • What are foreign keys?

    2m 1s
  • Add a foreign key column to a table

    4m 37s
  • Create a relationship between tables

    6m 50s
  • IDENTITY column sequences

    1m 36s
• 5. Formalize Data Relationships 5. Formalize Data Relationships

  • One-to-many relationships

    2m 13s
  • One-to-one relationships

    1m 27s
  • Many-to-many relationships

    2m 14s
  • Self-referencing relationships

    1m 56s
  • Cascade updates and deletes

    4m 35s
  • Challenge: Link tables with keys

    1m 8s
  • Solution: Link tables with keys

    6m 23s
• 6. Indexes 6. Indexes

  • Table indexes

    3m 31s
  • Add indexes to a table

    3m 37s
  • View index statistics

    6m 57s
• 7. Constraints 7. Constraints

  • Validate data with constraints

    3m 9s
  • Null constraints

    5m 34s
  • Unique constraints

    3m 46s
  • Setting default values

    3m 14s
  • Check constraints

    3m 8s
  • Challenge: Add constraints to a table

    46s
  • Solution: Add constraints to a table

    6m 29s
• Conclusion Conclusion

  • Next steps

    44s