Relational Database Design

Course ID

31020

Course Description

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. This workshop provides participants the opportunity to model a real world database application.

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.

Audience

  • End Users
  • Support Staff
  • Developers
  • Analysts
  • Administrators

Course Content

    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

For More Information

For training inquiries, call 850-308-1376

or email us at eramos@gbsi.com

Course Details

Duration - 3 days
Price - $1895.00 USD


(Discounts may apply. Call for more information.)

Course Actions

Schedule

Acceletrain Collaborative Learning Environment (formerly know as VILT) places industry certified and expert instructors, peers, learners and multi-media components into a "borderless classroom", and interactive learning environment that can span multiple physical locations. VILT combines the benefits of the traditional brick-and-mortar classroom with innovative learning techniques and the cost savings of internet-based training.