ByteTrail

Level 6 · Module 27

Database Design

A structured module covering the essential ideas of database design.

Difficulty
intermediate
Published path
10 lessons · 100 min

What you will learn

  • Primary keys
  • Foreign keys
  • Constraints
  • Relationships
  • ER diagrams
  • Normalization
  • 1NF
  • 2NF
  • 3NF
  • Denormalization
Prerequisites:SQL

Start here

Lessons · 100 min

  1. Primary keysPlanned

    Planned lesson: Primary keys. This lesson has not been written yet.

    10 min · intermediate

  2. Foreign keysPlanned

    Planned lesson: Foreign keys. This lesson has not been written yet.

    10 min · intermediate

  3. ConstraintsPlanned

    Planned lesson: Constraints. This lesson has not been written yet.

    10 min · intermediate

  4. RelationshipsPlanned

    Planned lesson: Relationships. This lesson has not been written yet.

    10 min · intermediate

  5. ER diagramsPlanned

    Planned lesson: ER diagrams. This lesson has not been written yet.

    10 min · intermediate

  6. NormalizationPlanned

    Planned lesson: Normalization. This lesson has not been written yet.

    10 min · intermediate

  7. 1NFPlanned

    Planned lesson: 1NF. This lesson has not been written yet.

    10 min · intermediate

  8. 2NFPlanned

    Planned lesson: 2NF. This lesson has not been written yet.

    10 min · intermediate

  9. 3NFPlanned

    Planned lesson: 3NF. This lesson has not been written yet.

    10 min · intermediate

  10. DenormalizationPlanned

    Planned lesson: Denormalization. This lesson has not been written yet.

    10 min · intermediate

What you will cover

Module units

  1. Primary keys

    A planned unit covering Primary keys.

  2. Foreign keys

    A planned unit covering Foreign keys.

  3. Constraints

    A planned unit covering Constraints.

  4. Relationships

    A planned unit covering Relationships.

  5. ER diagrams

    A planned unit covering ER diagrams.

  6. Normalization

    A planned unit covering Normalization.

  7. 1NF

    A planned unit covering 1NF.

  8. 2NF

    A planned unit covering 2NF.

  9. 3NF

    A planned unit covering 3NF.

  10. Denormalization

    A planned unit covering Denormalization.