MySQL Database Development: Database Design Fundamentals

MySQL 8.0    |    Beginner
  • 12 videos | 1h 5m 11s
  • Includes Assessment
  • Earns a Badge
Likes 149 Likes 149
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

  • 5m 53s
    After completing this video, you will be able to describe the key components of a RDBMS, including table structure, keys, and relationships. FREE ACCESS
  • 6m 51s
    During this video, you will learn how to define standards for data storage in tables, such as removing duplicates, breaking down fields, and using primary keys. FREE ACCESS
  • Locked
    3.  Column Design Concepts
    5m 37s
    In this video, you will learn about the standards used in column design, such as auto increment columns, default and null values, and modifying size and format. FREE ACCESS
  • Locked
    4.  Table and Column Properties
    8m 38s
    In this video, you will learn how to use MySQL Workbench to determine table and column properties. FREE ACCESS
  • Locked
    5.  Relationships
    4m 2s
    During this video, you will learn how to define table relationships in a database, including one-to-many, one-to-one, and many-to-many relationships. FREE ACCESS
  • Locked
    6.  Normalization
    5m 36s
    Upon completion of this video, you will be able to describe database normalization and identify the various levels of normalization. FREE ACCESS
  • Locked
    7.  Normal Forms
    7m 56s
    After completing this video, you will be able to describe the normalization process through each level of the normal forms. FREE ACCESS
  • Locked
    8.  Benefits of Database Normalization
    5m 24s
    In this video, find out how to identify the benefits achieved through the normalization process. FREE ACCESS
  • Locked
    9.  What is Full Stack Development (FSD)?
    3m 16s
    Upon completion of this video, you will be able to describe what Full Stack Development is and the various tasks a developer would perform in each area. FREE ACCESS
  • Locked
    10.  Anatomy of a Full Stack Environment
    2m 59s
    After completing this video, you will be able to describe the components of a full stack environment and how each component interacts. FREE ACCESS
  • Locked
    11.  FSD and MySQL
    3m 36s
    After completing this video, you will be able to describe the most common software stacks that employ MySQL. FREE ACCESS
  • Locked
    12.  Exercise: Database Design and FSD Concepts
    5m 22s
    Upon completion of this video, you will be able to describe the overall structure of a RDBMS and the FSD environment. 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book RDBMS In-Depth: Mastering SQL and PL/SQL Concepts, Database Design, ACID Transactions, and Practice Real Implementation of RDBM (English Edition)
Course Database Fundamentals: Database Administration Basics
Channel SQL Database Development & Design
Likes 349 Likes 349  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course MySQL Database Development: Introduction
Likes 109 Likes 109  
Course Querying & Manipulating Data
Likes 112 Likes 112  
Course Database Fundamentals: Getting Started with SQL