• Online, Self-Paced
Course 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.

Learning 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
  • describe the overall structure of a RDBMS and the FSD environment

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.