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

COURSE Traditional Data Architectures: Relational Databases
CHANNEL Wintellect NoSQL
Likes 2 Likes 2  
BOOK Pro SQL Server Relational Database Design and Implementation: Best Practices for Scalability and Performance, Sixth Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE MySQL: Getting Started
Likes 61 Likes 61  
COURSE Objects & Retrieving Data
Likes 72 Likes 72  
COURSE MySQL Database Development: Working with Functions
Likes 32 Likes 32