Our instructor was great! He was enthusiastic and motivating for the entire two days of the course. He had a great... More Testimonials »
Home > Database > Oracle > Relational Database Design and Data Modeling

Relational Database Design and Data Modeling

Oracle 11g

Delivery Options

Upcoming Live eLearning Classes

There are currently no upcoming Live eLearning classes. Please contact us if you would like us to schedule a class.

Class Description

Class Overview

This database design training class can be customized based on the students' experience working with and building databases.

It is based heavily on Data Modeling, A Beginner's Guide by Andy Oppel and Data Modeling Essentials by Graeme Simsion and Graham Witt. Both books are included with the course.

Class Goals

  • Learn to design relational databases effectively.

Class Outline

  1. Data Modeling Concepts
    1. Introduction to Data Modeling
    2. Relational Database Components
    3. Data and Process Modeling
    4. Organizing Database Project Work
  2. Data Modeling Details
    1. Conceptual Data Modeling
    2. Logical Database Design Using Normalization
    3. Beyond Third Normal Form
    4. Physical Database Design
  3. Design Alternatives
    1. Alternatives for Incorporating Business Rules
    2. Alternatives for Handling Temporal Data
    3. Modeling for Analytical Databases
    4. Enterprise Data Modeling

Class Materials

All students receive a course manual or book and all the class examples.

Students in private onsite classes will also receive:

  • Data Modeling: A Beginner's Guide
  • Data Modeling Essentials, Third Edition

Technical Requirements

Our computer technical requirements and setup process is easy, with support just a click away.

Quick Links
  1. Watch Presentation
  2. Free Demo
  3. Purchase Vouchers
  4. Partners
  5. Remote Courses
  6. Make Payment
  7. Contact Us
  8. Sitemap
  9. Privacy Policy
Courseware
  1. Purchase Courseware
Client Success
  1. Independent Survey
  2. Client List
  3. Testimonials
Join The Team
  1. Learn how you can become a Webucator Trainer
  2. Career Opportunities
Locations
  1. Where We've Trained
  2. We have trainers all over North America.
Compare Us
Compare Webucator to leading Competitors
Training Options
  1. Live eLearning Public Classes
  2. Private Training
  3. Self-Paced eLearning
Microsoft Partner
  1. Microsoft Certifications
  2. Certified Microsoft Courses
  3. Software Assurance Training Vouchers
Watch 3-minute Demo Video
of Live Online Training: Learn the benefits of online training with Webucator
Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.

Recent Blog Articles

SQL Server 2008 Certification Training Overview

Posted on Jun 07, 2011 by Bob Clary

We’ve recently developed new resources to help clients achieve their Microsoft certification goals. We now offer a directory of Microsoft certification ...

SQL Server 2008 Reporting Services

Posted on May 04, 2011 by akenien

This SQL Server Reporting Services 2008 webinar is a quick overview of the the new layout and features of SQL Server Reporting Services 2008. SQL Server ...

Data Modeling in MySQL Workbench

Posted on May 04, 2011 by akenien

This MySQL webinar recording includes concepts from our MySQL training classes to teach you how to use MySQL Workbench for data modeling. The webinar will ...

Writing an Oracle PL/SQL Program

Posted on May 04, 2011 by akenien

This recorded webinar includes concepts from our Oracle training classes to help you write your first Oracle PL/SQL program! Writing an Oracle PL/SQL Program ...

Importing Data Using Oracle SQL Developer

Posted on Feb 27, 2011 by Beth Anglo

There are many methods one can use to import data from operating system files into Oracle tables. These methods include using any of the following: the ...

© Webucator, Inc. All rights reserved. | Toll Free: 1-877-932-8228 | From outside the USA: 315-849-2724| Fax: 315-849-2723