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
describe the overall structure of a RDBMS and the FSD environment
Course Number: it_dfmydd_02_enus
Expertise Level
Beginner