Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
Business Analysis
Business Intelligence
Business Objects
Business Skills
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Datawarehousing
DB2
Desktop Application Software
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Oracle Designer Data Modeling
Oracle Training Overview

This 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. This course is alternately named "Relational Database Design."

Oracle Training Prerequisites

None.

Oracle Training Audience

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.

Suggested Next Courses

  • The course Introduction To Oracle9i SQL
  • The course Introduction To Oracle9i PL/SQL Language
  • The course Oracle9iDS Designer Systems Analysis & Modeling
Oracle Training Objectives

  • Build a series of logical data models
  • Transform a logical model into a physical model
  • Use the concepts of supertype and subtypes to solve modeling problems
  • Learn the mistakes common to many data models
Oracle Training Course duration

3 Days

Oracle Training Course outline

Data Modelling Principles
  • What Is Data Modeling?
  • Related Methodologies
  • What You Can Do With A Data Model
  • What Can Go Wrong Without A Data Model
  • ERwin Model Notation
  • SDesignor Model Notation
  • Oracle Designer Model Notation
  • Logical Database Design
Building A Data Model
  • Building A Very Simple Model
  • How To Start A Data Model
  • Identifying Entities
  • Identifying Attributes
  • Identifying Relationships
  • Certify the Model With Normalization
  • Oracle Designer Notation
Transform Model To Logical Database

Semantic & Object Oriented Concepts
  • Semantic Data Modeling
  • OO Concepts
  • Domains
  • Flaws That Probably Exist In Your Entities!
  • Flaws That May Exist In Your Attributes
  • SuperTypes & SubTypes
  • Generalization and Specialization
  • Sample Specialization
  • Subtype Constraints
  • Arc
  • Lattice
  • Some Scary Stories!
What Is A Relational Database?
  • Relational Database Terms
  • Views
  • Indexes
  • Constraints
  • Sequences
  • Triggers
  • A Logical Database Design
  • Distributed Database & Data Partitioning
Classic Structures & Patterns
  • Master-Detail (Generic)
  • Master-Detail (Invoice specific)
  • Bill-of-Materials (data model)
  • Bill-of-Materials (relational schema)
  • Organization Unit Hierarchy
Sample Models
  • The Connection Trap (Solution)
  • A Credit Card Company (Moderate)
  • Refine Air Travel Model (Moderate)

 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
© Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy