Course details

MySQL Database Development: Database Design Fundamentals

MySQL Database Development: Database Design Fundamentals


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

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.



Expected Duration (hours)
1.1

Lesson Objectives

MySQL Database Development: Database Design Fundamentals

  • 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
  • Course Number:
    it_dfmydd_02_enus

    Expertise Level
    Beginner