Oracle9i Designer Database Generation Course

This intensive course demonstrates how sophisticated Oracle Designer models may be used to generate complete modules for client/server applications. Participants will walk through the numerous options for the Server Generator. Complex topics of forward and reverse engineering, reconciliation, use of templates and many others are considered.

This course is designed for Oracle client/server developers.

Upon completion of this course, the participant will be able to:
> Know the Server Generator
> Use Forward Engineering
> Use Reverse Engineering

Database Generation With Oracle Designer
Systems Methodologies
Using Oracle Designer

Using The Database Design Transformer
Transformation Using Default Settings
Transformation Using Custom Settings
Transformation Using Additional

Transforming Supertypes & Subtypes
Transforming Supertypes
About Surrogate Keys
A Supertype Scenario

Introducing The Design Editor
A Tour Of The Design Editor
Design Editor Opti_R

Designing Distribution Objects
Building The Production
Defining Distribution Objects

Designing Database Administration Objects
Defining Oracle Databases
Creating Storage Definitions
Defining Tablespaces
Defining Data Files
Defining Log Files
Defining Rollback Segments
Defining Directories

Designing User-Related Objects
About User-Related Objects
Defining Users
Defining Roles
Defining Profiles

Designing The Server Model (Tables)
Using Server Model Diagrams
Defining Tables

Designing The Server Model (Constraints)
Defining Primary Key Constraints
Defining Unique Constraints
Defining Foreign Key Constraints
Defining Check Constraints

Designing The Server Model (Advanced Objects)
Advanced Server Model Objects
Defining Indexes
Defining Synonyms
Defining Relational Views
Defining Materialized Views
Defining Clusters
User-Specific Database Implementations

The Database Server Generator
Generate Database Administration Objects
Generate Server Model

Repository Reports For Database Design
Find A Report
Run A Report
Understanding The Report Groups
Reports You Should Run
Design Capture
Design Capture, Define Physical Objects
Design Capture, Retrofit Logical Objects

Using The Dependency Manager
About The Dependency Manager
Building Dependencies
Showing Dependencies
Working With Individual Dependency Records
Using The Dependency Manager Tools

Oracle9i SQL (RT 262)
Oracle9iDS Designer Data Modeling (RT 287)
Oracle9iDS Designer Systems Analysis & Modeling (RT 288)
Oracle9i Architecture For Developers (RT 284)