Relational Database Design

Course Number:

N/A

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 Objectives:
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

Related Posts

About Us
Ntier company logo

IT Training, Agile Ways of Working and High Impact Talent Development Strategies

Let Us Come to You!

Classes recently delivered in: Atlanta, Boston, Chicago, Columbus, Dallas, Detroit, Indianapolis, Jerusalem, London, Milan, New York, Palo Alto, Phoenix, Pittsburgh, Portland, Raleigh, San Antonio, San Diego, San Francisco, San Jose, Seattle, Springfield, Mass., St. Louis, Tampa and more!