Relational Database Design Training

 

Relational Database Design – 3 Days

Course Description – Relational Database Design

This Relational Database Design Training 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.

Intended Audience

This course is appropriate for end users, support staff, developers, analysts and administrators.

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.

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

Other courses to explore:

Oracle 12c Release 1 DBA I Training – Onsite, Tailored, Low Cost

Data Modeling: Logical Database Design Training – Onsite, Tailored

Oracle 12c Release 1 PL/SQL Development Training – Onsite, Tailored

Don’t forget to check out our monthly specials to save – Monthly Specials

MindIQ.com

Print Friendly, PDF & Email