This course helps participants learn an effective approach to developing a relational database. Topics in this course are: defining user requirements, developing an entity-relationship (ER) diagram and mapping your logical database model to a physical database design. Exercises and lab sessions reinforce the learning objectives and provide participants the opportunity to gain practical hands-on experience. A hands-on modeling workshop is facilitated on the third day, providing participants the opportunity to model a real-world database application.

Audience: This course is appropriate for end users, support staff, developers, analysts and administrators.
Course Duration: 3 days
Prerequisites:

An introductory course in a Windows operating system, or equivalent skills and knowledge, is required. CompTIA A+ certification, or the equivalent skills and knowledge, is helpful but not required.

Course Outline:
  • Relational Database Design Overview
    • Business Information Requirements
    • Conceptual Data Modeling
    • Database Design
    • Database Build
  • Conceptual Data Modeling
    • Identify and Model Entities
    • Relationships
    • Relationship Types
    • Relationship Matrix
    • Analyze and Model Relationships
    • E-R Diagrams
    • Attributes
    • Distinguish Attributes and Entities
    • Assign Unique Identifiers
  • Advanced Data Modeling
    • Normalize the Data Model
    • Resolve M:M Relationships
    • Model Recursive Relationships
    • Model Roles with Relationships
    • Model Subtypes
    • Model Exclusive Relationships
    • Model Complex Relationships Relational Database Concepts
    • Primary Keys
    • Foreign Keys
    • Data Integrity
  • ANSI Standard SQL
    • Command Summary
    • Create Schema
    • Populate Tables
    • Query Rows
    • Manipulate Data
  • Relational Database Design
    • Initial Database Design
    • Map Simple Entities
    • Map Attributes to Columns
    • Map UIDs to Primary Keys
    • Map Relationships to Foreign Keys
    • Map Complex E-R Models to Tables
    • Choose Arc Options
    • Choose Subtype Options
    • Single Table Subtype Design
    • Separate Tables Subtype Design
  • Table Normalization
    • Normalize Table
    • Recognize Unnormalized Data
    • Convert to First Normal Form
    • Convert to Second Normal Form
    • Convert to Third Normal Form
  • Modeling Workshop
    • Analyze Business Requirements
    • Model Business Requirements
    • Develop an ER Diagram
    • Review the Model
    • Gather New and Changing Requirements
    • Modify the Model
    • Present Your Model