1-877-WEBUCATE
(1-877-932-8228)
info@webucator.com
 
Microsoft Training
Java Training
XML Training
Database & SQL Training
PHP, Perl, ASP, Groovy, Grails, Ruby on Rails Training
HTML, JavaScript, Ajax & CSS Training
Adobe CS3 Training
◊ PRIVATE ORACLE TRAINING


Need a private class for your team delivered at your site or a location near you?
For private groups of three or more, Webucator offers completely customizable and cost-effective Oracle classes delivered at your offices or a location near you.

To have someone contact you about these classes, please fill out the form below.

* (Required)
* (Required)
* (Required)
* (Required)
* (Required)
(The number of people requiring training)
(For Federal Government Pricing)
* (Required)

Oracle Designer Data Modeling Training on Oracle 10g (3 days)


This Oracle class is delivered for private groups onsite at your offices or a location of your choice. It can also be delivered via the Internet for geographically distributed staff.

Click here for our public Oracle classes

Oracle Designer Data Modeling Overview

This Oracle training course considers all the features of building complex logical data models using sophisticated modeling techniques. Numerous "real-world" problems and special situations are presented along with solutions. Classic structures and common models are also given to assist participants in rapidly completing a data model. Traditional modeling techniques as well as newer object-oriented modeling principles are presented providing state-of-the-art modeling skills to attendees. This course may be presented using the modeling syntax of Oracle Designer or independent of any specific modeling tool. The course is intended for all database professionals including developers, database administrators and designers. Non-technical professionals such as business analysts and others concerned with logical database design will also benefit. This course is delivered as a lecture and is not hands-on.

Oracle Designer Data Modeling Course Goals

  • Learn to build a series of logical data models
  • Learn to transform a logical model into a physical model
  • Learn to use the concepts of supertype and subtypes to solve modeling problems
  • Learn the mistakes common to many data models

Oracle Designer Data Modeling Course Outline

  1. Data Modeling Principles
    1. What Is Data Modeling?
    2. Related Methodologies
    3. What You Can Do With A Data Model
    4. What Can Go Wrong Without A Data Model
    5. ERwin Model Notation
    6. SDesignor Model Notation
    7. Oracle Designer Model Notation
    8. Logical Database Design
  2. Building a Data Model
    1. Building A Very Simple Model
    2. How To Start A Data Model
    3. Identifying Entities
    4. Identifying Attributes
    5. Identifying Relationships
    6. Certify the Model With Normalization
    7. Oracle Designer Notation
  3. Transform Model to Logical Database
  4. Semantic & Object-Oriented Concepts
    1. Semantic Data Modeling
    2. OO Concepts
    3. Domains
    4. Flaws That Probably Exist In Your Entities!
    5. Flaws That May Exist In Your Attributes
    6. SuperTypes & SubTypes
    7. Generalization and Specialization
    8. Sample Specialization
    9. Subtype Constraints
    10. Arc
    11. Lattice
    12. Some Scary Stories!
  5. What is a Relational Database?
    1. Relational Database Terms
    2. Views
    3. Indexes
    4. Constraints
    5. Sequences
    6. Triggers
    7. A Logical Database Design
    8. Distributed Database & Data Partitioning
  6. Classic Structures & Patterns
    1. Master-Detail (Generic)
    2. Master-Detail (Invoice specific)
    3. Bill-of-Materials (data model)
    4. Bill-of-Materials (relational schema)
    5. Organization Unit Hierarchy
  7. Sample Models
    1. The Connection Trap (Solution)
    2. A Credit Card Company (Moderate)
    3. Refine Air Travel Model (Moderate)

Oracle Designer Data Modeling Course Materials

In addition to a comprehensive set of materials, including course notes and all the programming examples, each student will also receive a one-year subscription to Webucator's online reference library, which contains hundreds of the most current electronic technology books - a $149.95 per student value.

Oracle Designer Data Modeling Technical Requirements

  1. Oracle 8i or later
    • Download - - Oracle Database 10g Express Edition
      1. The file you want to download is Oracle Database 10g Express Edition (Western European) - OracleXE.exe.
      2. You will need to register for a free account.
      3. Run through the Installer accepting all the defaults. Make sure to write down your password.
      4. Follow steps 1-3 of the Getting Started Guide available at the Oracle Web site
  2. Editor Options
    • (Recommended) Toad for Oracle
      • Download
      • Run through the Installer accepting all the defaults.
    • SQL*Plus Instant Client

Class Files for Oracle Designer Data Modeling

The class files for this course will be sent by email before the class.

home - onsite classes - instructor-led online courses - self-paced online courses - why webucator - partners - contact - sitemap
© 2007 Webucator. All rights reserved. info@webucator.com | Toll Free: 877-WEBUCATE (877-932-8228) | From Outside the USA: 315-446-0560 | Fax: 315-410-5320
Phoenix, AZ | Santa Clara, CA | Santa Clara, CA | Los Angeles, CA | Sacramento, CA | Washington, DC | Atlanta, GA | Chicago, IL | Indianapolis, IN | Muncie, IN
New Orleans, LA Boston, MA | Cambridge, MA | Charlestown, MA | Framingham, MA | Ipswich, MA | Lincoln, MA | Wellesley, MA | Worcester, MA | Bangor, ME | Detroit, MI
Raleigh, NC Winston-Salem, NC | Lincoln, NE | East Hanover, NJ | Eatontown, NJ | Madison, NJ | Parsippany, NJ | Trenton, NJ | Albany, NY | Buffalo, NY | Rochester, NY
New York City, NY | Syracuse, NY | West Babylon, NY | Dayton, OH | Bethlehem, PA | Philadelphia, PA | Pittsburgh, PA | Pittsburgh, PA | State College, PA
Middletown, RI | Rapid City, SD | Austin, TX | Dallas, TX | Houston, TX | Arlington, VA | McLean, VA | Seattle, WA | Toronto, Canada | Ottawa, Canada | Calgary, CA