MySQL Database Development: Database Design Fundamentals

MySQL 8.0    |    Beginner
  • 12 Videos | 1h 5m 11s
  • Includes Assessment
  • Earns a Badge
Likes 74 Likes 74
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
    FREE ACCESS
  • Locked
    4. 
    Table and Column Properties
    8m 38s
    FREE ACCESS
  • Locked
    5. 
    Relationships
    4m 2s
    FREE ACCESS
  • Locked
    6. 
    Normalization
    5m 36s
    FREE ACCESS
  • Locked
    7. 
    Normal Forms
    7m 56s
    FREE ACCESS
  • Locked
    8. 
    Benefits of Database Normalization
    5m 24s
    FREE ACCESS
  • Locked
    9. 
    What is Full Stack Development (FSD)?
    3m 16s
    FREE ACCESS
  • Locked
    10. 
    Anatomy of a Full Stack Environment
    2m 59s
    FREE ACCESS
  • Locked
    11. 
    FSD and MySQL
    3m 36s
    FREE ACCESS
  • Locked
    12. 
    Exercise: Database Design and FSD Concepts
    5m 22s
    FREE ACCESS

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 SQL Database Administration
Likes 313 Likes 313  
BOOK Pro SQL Server Relational Database Design and Implementation: Best Practices for Scalability and Performance, Sixth Edition
CHANNEL NoSQL
Likes 32 Likes 32  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SQL 2016 Tables
Likes 166 Likes 166  
COURSE MySQL Database Development: Working with Functions
Likes 32 Likes 32  
COURSE MySQL Database Development: Query & Performance Optimization
Likes 16 Likes 16