Oracle Training : Oracle9i DS Designer Database Generation

Oracle9i DS Designer Database Generation

Oracle Training Overview

This intensive seminar 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.

Oracle Training Prerequisites

The course Introduction To Oracle9i SQL
The course Oracle9iDS Designer Data Modeling
The course Oracle9iDS Designer Systems Analysis & Modeling
The course Oracle9i Architecture For Developers

Oracle Training Audience

Oracle client/server developers

Suggested Next Courses

The course Oracle 9iDS Forms I: Build Internet Applications

Oracle Training At Course Completion

Students will know the Server Generator
Students will understand Forward Engineering
Students will understand Reverse Engineering

Oracle Training Course duration

3 Days

Oracle Training Course outline

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