Oracle 9i Designer Part 2 (O320) Training Course

Training Course Objectives

This practical course covers the physical implementation of the Oracle Designer logical model, developed in the Oracle 9i Designer Part 1 course.

In particular, it covers the physical database design implementation together with the development and implementation of PL/SQL server side routines using the Designer 9i Design Editor tools.

Using the module specification components of the Design Editor, the course covers detailed generation techniques and also considers reverse engineering processes.

Who Should Attend

• Oracle Analyst/Programmers
• Oracle Technicians
• Oracle Designers

Training Course Prerequisites

• Oracle 9i SQL (O010)
• Oracle 9i PL/SQL (O020)
• Oracle 9i Forms Part 1 (O210)
• Oracle 9i Designer Part 1 (O310)
• View Learning Path

Training Course Duration

5 Days

Training Course Contents

Database Transformer

• Introduction
• Database Design Transformer
• Transformer Dialog
• Tab Dialog Options
• Table Mappings
• Other Mappings
• Run Options
• Options

Data Modelling

• Conversion
• Models to Databases and Implementation
• Entities
• Looking at Software Reality
• Table Naming Conventions
• Implementing Relationships
• Implementing Recursion
• Recursion
• Conversion - Indexes
• Implementing Sub-Types & Exclusivity
• Sub-Type Methods
• Domain Conversion
• Operational Issues
• Normalisation
• De-Normalisation

Design Editor

• Introduction
• Navigator and Properties
• General Settings
• Customisations
• File Menu
• Edit Menu
• View Menu
• Navigator Menu
• Utilities Menu
• Generate Menu
• Tools Menu
• Options Menu
• Run Menu

Server Model - Schema

• Introduction
• Domains
• Tables
• Indexes
• Primary Key Constraints
• Foreign Key Constraints
• Check Constraints
• Sequences
• Views
• Materialised Views
• Clusters
• Schema Diagrams
• Advanced Queues

Application Transformer

• Introduction
• Application Transformer Dialog

Modules

• Introduction
• Module Definition
• LOVs
• Navigators (Trees)
• Arguments
• Windows
• Module Components
• Usage
• Linking Usage
• Other Item Definitions
• Reusable Components
• Application Logic
• Module Diagrams
• Types of Usage
• Linking Usage
• Module Display Diagram
• Generate Default Links

Menus

• Introduction
• Module Structure Diagram

Preferences

• Introduction
• Preferences Navigator
• Preference Sets
• Templates
• Forms Preferences
• Reports Preferences

Generators

• Introduction
• Forms Generation
• Form Options
• Menu Option
• Compile
• Run
• Standard
• Other
• The Reports Generator
• Report Options
• Using Different Layouts

Reverse Engineering

• Introduction
• Regeneration
• Reverse Engineering
• Reconciliation

Version Control

• Merge
• Compare
• Configurations
• Dependency Analysis

Schema Model - PL/SQL

• Introduction
• PL/SQL Development
• Database Implementation
• PL/SQL Development
• Triggers
• Table API - Examples

Next Available Dates

iTrain delivers this course as company specific training. Please contact us for more information or course dates.