Database Design Fundamentals

MySQL 8.0
  • 12 Videos | 1h 10m 41s
  • Includes Assessment
  • Earns a Badge
Likes 49 Likes 49
A database is only as good as its initial design. Explores RDBMS design fundamentals, such as table design, normalization, and relationships. Full Stack Development and how MySQL fits into the FDS landscape is also covered.

WHAT YOU WILL LEARN

  • describe the key components of a RDBMS, including table structure, keys, and relationships
    define the standards used in tables for data storage, such as removing duplicates, breaking down fields, and the use of primary keys
    define the standards used in column design and properties, such as auto increment columns, default and null values, and modifying size and format
    use MySQL Workbench to determine table and column properties
    define table relationships in a database, including one-to-many, one-to-one, and many-to-many
    describe database normalization and identify the various levels of normalization
  • describe the normalization process through each level of the normal forms
    identify the benefits achieved through the normalization process
    describe what Full Stack Development is and the various tasks a developer would perform in each area
    describe the components of a full stack environment and how each component interacts
    describe the most common software stacks available that employ MySQL
    describe the overall structure of a RDBMS and the FSD environment

IN THIS COURSE

  • Playable
    1. 
    RDBMS Essentials
    5m 53s
    UP NEXT
  • Playable
    2. 
    Table Design Concepts
    6m 51s
  • Locked
    3. 
    Column Design Concepts
    5m 37s
  • Locked
    4. 
    Table and Column Properties
    8m 38s
  • Locked
    5. 
    Relationships
    4m 2s
  • Locked
    6. 
    Normalization
    5m 36s
  • Locked
    7. 
    Normal Forms
    7m 56s
  • Locked
    8. 
    Benefits of Database Normalization
    5m 24s
  • Locked
    9. 
    What is Full Stack Development (FSD)?
    3m 16s
  • Locked
    10. 
    Anatomy of a Full Stack Environment
    2m 59s
  • Locked
    11. 
    FSD and MySQL
    3m 36s
  • Locked
    12. 
    Exercise: Database Design and FSD Concepts
    5m 22s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

CHANNEL MariaDB
Likes 7 Likes 7  
Likes 8 Likes 8  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 66 Likes 66  
Likes 38 Likes 38  
Likes 61 Likes 61