db-Training: Oracle Internet Developer Certification Program

Oracle Internet Developer Certification Program - Detailed Outline

Introduction to the Oracle Relational Database Management System

Information Technology Overview
The Oracle Business
The Relational Database Model
The Oraclei Relational Database Management System
- Oraclei Components
  - The Oraclei Database
    - Physical Structure
    - Logical Structure
  - The Oraclei Instance
  - The Oraclei Data Dictionary
Oracle Net
Installing Personal Oraclei
- Installation Procedures
- Installing the Oraclei Software
- Starting and Stopping the Database
- Altering the Database
- Adding New Users
Data Modeling Overview
- Formatting Standards and Conventions
- Requirements Gathering/Analysis
- Logical Database Design
  - Entities
  - Attributes
  - Relationships
- Physical Database Design
  - Schema’s
  - Tables
  - Columns
  - Datatypes
  - Rows
  - Referential Integrity
- Physical Database Implementation
- Application Development
- Integration Testing
- System Deployment
- Maintenance and Enhancements
The JASCO Corporation Application Overview
The Oraclei Utilities
- Import
- Export
- Loader

Introduction to Programming for the Oracle RDBMS

Structured Query Language (SQL) Programming
- Data Definition Language
  - Syntax
  - GRANT
  - REVOKE
  - CREATE
  - CONSTRAINTS
  - ALTER
  - DROP
  - COMMIT
  - SAVEPOINT
  - ROLLBACK
- Data Manipulation Language
  - SELECT Statements
  - Single table queries
  - Operators
  - Subqueries
  - Multiple table queries
  - Joins
  - EXISTS
  - Functions
    - Single Row (Scalar)
    - Group (Aggregate)
  - Advanced queries
  - Set Operations
  - Nested Functions
  - Correlated Subqueries
  - INSERT Statements
  - UPDATE Statements
  - DELETE Statements
SQL*Plus Programming
- Report Formatting
  - COLUMN
  - BREAK
  - COMPUTE
  - TITLE
- SET Command
  - HEADING
  - ECHO
  - FEEDBACK
  - PAGESIZE
  - LINESIZE
  - PAUSE
  - SPOOL
Procedural Language/Structured Query Language (PL/SQL) Programming
- PL/SQL Blocks
  - Declarative Section Formatting and Naming Conventions
  - Variables
  - Constants
  - Cursors
  - Exceptions
- Processing Section
  - Using (SQL) in PL/SQL
  - Variable Usage
  - Flow Control
  - Loops
  - Cursors
  - Cursor FOR Loop
  - Advanced variable typing
- Exception Handling Section
  - Raising and handing an exception
  - Application Exceptions
  - User defined exceptions
  - Scoping exceptions
  - Nested exceptions
  - Database Exceptions
- Local Programs
  - Anonymous Blocks
- Database (Stored) Programs
  - Syntax and components of stored programs
  - Parameters
  - Procedures
  - Functions
  - Executing stored programs in SQL
- Packages
  - Specification
  - Body
  - Built-In packages
  - User defined packages
- Database Triggers
- Overloaded Modules
- Bind Variables

Introduction to the Oracle Developer Toolset

Developing and Deploying Forms using Oracle Forms Version 6i

Form Builder
- Form Module
  - Object Navigator
    - Components
      - Data Blocks
        
        The Data Block Wizard
        
        Table Based
        View Based
        Stored Procedure Based
        
        Creating Data Blocks Manually
      - Canvases
        
        The Canvas Wizard
        
        Content
        Stacked
        Tab
        
        Creating Canvases Manually
      - Editors
        
        Default
        System
        User-Named
      - List Of Values (LOV)
        
        Creating
        Attaching
      - Object Groups
        
        Creating
        Using in forms
      - Parameters
        
        Program Units
        
        Creating
        
        Procedure
        Function
        Package Specification
        Package Body
        
        Using in forms
        
        Property Classes
        
        Creating
        Inheritance
        
        Record Groups
        
        Creating
        Use with LOV’s
        
        Reports
        Visual Attributes
        Windows
        
        Microsoft MDI
        Forms Windows
      - Triggers
        
        Module
        Block
        Item
        SmartTriggers
    - Single-Record Forms
    - Multi-Record Forms
    - Master-Detail Forms
      - Property Palette
      - Popup Menus
      - PL/SQL Editor
    - Processing Flow Charts
  - Layout Editor
  - PL/SQL Editor
- Menu Module
- PL/SQL Libraries
- Object Libraries
- Form Compiler
- Forms Runtime

Developing and Deploying Reports using Oracle Reports 6i

Reports
- Data Model
  - Queries
  - Groups
  - Links
  - Columns
  - Parameters
- Layout Model
  - Frame Types and Use
- Live Previewer
  - Realigning Objects
  - Adding Summary and Formula Columns
- Parameter Form
- Static Reports
- Using parameters to create dynamic reports
- Report Triggers
Templates
- Columnar Reports
- Tabular Reports
- Break Reports
- Summary Reports
- Master-Detail Reports
- Form Letters
- Matrix Reports