Oracle

Retrieve row and column data from tables with the SELECT statement
Create reports of sorted and restricted data
Employ SQL functions to generate and retrieve customized data
Display data from multiple tables using the ANSI SQL 99 JOIN syntax
Create reports of aggregated data
Use the SET operators to create subsets of data
Run data manipulation statements (DML) to update data in the Oracle Database 11g
Run data definition language (DDL) statements to create and manage schema objects
Identify the major structural components of the Oracle Database 11g

Application Developers
Forms Developer
PL/SQL Developer
Reports Developer
Technical Consultant
Portal Developer
Functional Implementer
End Users

Familiarity with data processing concepts and techniques

Introduction
Retrieving Data Using the SQL SELECT Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Using Conversion Functions and Conditional Expressions
Reporting Aggregated Data Using the Group Functions
Displaying Data From Multiple Tables
Using Sub-queries to Solve Queries
Using the SET Operators
Manipulating Data
Using DDL Statements to Create and Manage Tables
Controlling User Access
Managing Schema Objects
Managing Objects with Data Dictionary Views
Manipulating Large Data Sets
Managing Data in Different Time Zones
Retrieving Data Using Sub-queries
Regular Expression Support
Creating Other Schema Objects

Write PL/SQL code to interface with the database
Design PL/SQL program units that execute efficiently
Use PL/SQL programming constructs and conditional control statements
Handle run-time errors
Describe stored procedures and functions
Write dynamic SQL for more coding flexibility
Design PL/SQL code for predefined data types, local subprograms, additional programs and standardized constants and exceptions
Use the compiler warnings infrastructure
Manipulate large objects
Create triggers to solve business challenges
Manage dependencies between PL/SQL subprograms
Schedule PL/SQL jobs to run independently
Create stored procedures and functions
Design PL/SQL packages to group and contain related constructs
Create overloaded package subprograms for more flexibility
Categorize the Oracle supplied PL/SQL packages

Databace Designer
PL/SQL Developer
Database Administrators
Forms Developer
Technical Consultant

Oracle Database 10g: Introduction to SQL

Introduction to PL/SQL
Declaring PL/SQL Identifiers
Writing Executable Statements
Interacting with the Oracle Server
Writing Control Structures
Working with Composite Data Types
Using Explicit Cursors
Handling Exceptions
Creating Stored Procedures
Creating Stored Functions
Creating Packages
Using More Package Concepts
Utilizing Oracle Supplied Packages in Application Development
Dynamic SQL and Metadata
Design Considerations for PL/SQL Code
Managing Dependencies
Manipulating Large Objects
Creating Triggers
Applications for Triggers
Understanding and Influencing the PL/SQL Compiler

Create form modules, including components for database interaction and GUI controls
Display form modules in multiple windows and use a variety of layout styles
Test form modules in a Web browser
Debug form modules in a 3-tier environment
Implement triggers
Reuse objects and code
Link one form module to another

Application Developers
Developer
Forms Developer
PL/SQL Developer
Support Engineer
Technical Consultant

A good familiarity with Graphical User Interface (GUI)
Working experience with the Web browser
Oracle Database 10g: Introduction to SQL
Oracle Database 10g: Program with PL/SQL
Oracle Database 10g: Develop PL/SQL Program Units

Introducing Oracle Forms Developer and Forms Services
Creating Forms Modules
Working with Data Blocks and Frames
Working with Input Items
Working with Non Input Items
Working with Windows and Canvases
Producing Triggers. Debugging Triggers
Adding Functionality to Items
Run-Time Messages and Alerts
Query Trigger. Validation
Navigation. Transaction Processing
Writing Flexible Code. Sharing Objects and Code
Using WebUtil to Interact with the Client
Introducing Multiple Form Applications
Creating a Menu Document . Managing Menu Documents
Programming Function Keys. Responding to Mouse Events
Controlling Windows and Canvases Programmatically
Defining Data Sources
Working with Oracle8i Objects in Form Builder
Controlling Data Block Relationships
Building Multiple-Form Applications
Working with Record Groups. Reusable Components
Using Java in Web-Deployed Forms
Using Server Features in Forms
Applying Timers. Including Charts and Reports

Add dynamic data to an existing HTML page
Use report parameters and customize a runtime parameter form
Enhance reports using graphs and PL/SQL trigger code
Maximize report performance using OracleAS Reports Services and tune reports
Publish a report on the Web and build reports to run in various languages
Manage report templates, create mailing labels and letters
Identify the main components in a report document and how they are related
Identify the differences between Web and paper reports
Identify standard report design styles and run existing reports to various output destinations
Create and modify basic tabular reports and high quality Web reports
Create other report styles such as break reports and matrix reports
Create reports by accessing data from various data sources

Technical Consultant
Reports Developer
Business Intelligence Developer

Oracle Database 10g: SQL Fundamentals I
Oracle Database 10g: PL/SQL Fundamentals
Oracle Database 10g: Develop PL/SQL Program Units

Introduction to Oracle Reports Developer
Designing and Running Reports
Working in Oracle Reports Developer
Creating a Paper Report
Enhancing a Basic Paper Report
Managing Report Templates
Creating a Web Report
Enhancing Reports Using the Data Model: Queries and Groups
Enhancing Reports Using the Data Model: Data Sources
Enhancing Reports Using the Data Model: Creating Columns
Enhancing Reports Using the Paper Layout
Controlling the Paper Layout: Common Properties
Controlling the Paper Layout: Specific Properties
Web Reporting
Extending Functionality Using XML
Creating and Using Report Parameters
Embedding a Graph in a Report
Enhancing Matrix Reports
Coding PL/SQL Triggers
Extending Functionality Using the SRW Package
Maximizing Performance Using OracleAS Reports Services
Building Reports: Efficiency Guidelines

Describe Oracle Database Architecture
Install and configure Oracle Database 11g
Configure Oracle Net services
Manage the database storage structures
Create and administer user accounts
Perform basic backup and recovery of a database
Manage users and schemas
Manage data and concurrency
Monitor and administer undo data
Backup and recover a database
Monitor performance
Use the database diagnostic monitor

Database Administrators
Support Engineer
Database Designers
Developer
Technical Administrator

Working knowledge of SQL

Exploring the Oracle Database Architecture
Preparing the Database Environment
Creating an Oracle Database
Managing the Oracle Instance
Configuring the Oracle Network Environment
Managing Database Storage Structures
Administering User Security
Managing Schema Objects
Managing Data and Concurrency
Managing Undo Data
Implementing Oracle Database Security
Database Maintenance
Performance Management
Backup and Recovery Concepts
Performing Database Backups
Performing Database Recovery
Moving Data
Enhancing Database Capabilities

Back up and recover a database
Configure Oracle Database for optimal recovery
Administer ASM disk groups
Use an RMAN backup to duplicate a database
Automating Tasks with the Scheduler

Database Administrators
Support Engineer
Data Warehouse Administrator
Technical Consultant

Oracle Database 11g: Administration Workshop I

Database Architecture and ASM
Configuring for Recoverability
Using the RMAN Recovery Catalog
Configuring Backup Specifications
Creating Backups
Performing User-Managed Backup and Recovery
Using RMAN to Perform Recovery
Using RMAN to Duplicate a Database
Performing Tablespace Point-in-time Recovery
Monitoring and Tuning RMAN
Using Flashback Technology
Using Flashback Database
Diagnosing the Database
Managing Memory
Managing Database Performance
Using the Segment Advisor
Managing Resources
Automating Tasks with the Scheduler
Administering the Scheduler
Globalization

Use Database Statistics and Metrics to identify a performance problem
Interpret Tuning diagnostics
Identify and eliminate performance issues
Set tuning priorities and strategies
Identify problem SQL statements
Influence the optimizer

Database Administrators
Support Engineer
Technical Consultant

Oracle Database 11g: Administration Workshop I
Oracle Database 11g: Administration Workshop II

Introduction
Monitoring With Basic Tools
Using Automatic Workload Repository
Identifying the Problem
Identifying Problem SQL Statements
Influencing the Optimizer
SQL Plan Management
Change Management
Using Metrics and Alerts
Using AWR Based Tools
Monitoring an Application (Using Services)
Baselines
Tuning the Shared Pool
Tuning the Buffer Cache
Tuning PGA and Temporary Space
Automatic Memory Management
Tuning Block Space Usage
Tuning I/O
: Performance Tuning: Summary
Using Statspack

Describe the role of a Web administrator ,Describe the architecture and components of Oracle Application Server (OracleAS) Infrastructure including its components and services
Install OracleAS Infrastructure and OracleAS Middle Tier
Configure and manage OracleAS Infrastructure components
Configure and manage OracleAS Middle Tier components
Manage and configure OracleAS Certificate Authority
Deploy and manage Web applications
Enhancing Oracle Application Server Components to Use SSL

Web Administrator
Technical Consultant

Working experience with Linux Operating System

Oracle Application Server Key Components and Features
Analyzing Oracle Application Server Architecture
Installing OracleAS Infrastructure
Installing the OracleAS Middle Tier
Using Oracle Application Server Management Tools
Managing the Oracle Internet Directory
Managing and Configuring Oracle HTTP Server
Configuring Directives and Virtual Hosts
Configuring mod_rewrite
Managing and Configuring OracleAS Web Cache
Managing and Configuring OC4J
Managing the OracleAS Portal
Configuring OracleAS Portal
Deploying PL/SQL and CGI Applications
Deploying J2EE Applications
Configuring Oracle Application Server Components in OID
Managing Access Using Delegated Administration Service
Administering the OracleAS Single Sign-On Server
Securing OracleAS Components Using SSL
Managing and Configuring OracleAS Certificate Authority

Describe high availability and scalability features available in Oracle Application Server 10g
Install OracleAS Infrastructure using a distributed environment
Choose the deployment topology that fits your needs
Choose the appropriate failover strategy according to their business needs
Manage OracleAS Reports Services, OracleAS Forms Services and OracleAS Discoverer
Deploy Web Services, Forms and Reports application, and XML applications
Reconfigure Oracle Application Server 10g
Describe backup and recovery solutions for Oracle Application Server 10g
Manage and Configure Oracle Application Server Clusters
Manage and Configure OC4J for Failover and Load Balancing
Monitor and tune Oracle Application Server 10g

Technical Consultant
Database Administrators
Sales Consultants
Portal Administrator

Oracle Application Server 10g: Administration I

Managing Customized Oracle Application Server Topologies
Distributing Oracle Application Server 10g Infrastructure Components
Introducing High Availability Concepts
Managing And Configuring Oracle Application Server Web Cache Clusters
Managing and Configuring Oracle Application Server Clusters
Managing and Configuring OC4J For Failover and Load Balancing
Managing Oracle Application Server Cold Failover Clusters
Administer Oracle Application Server 10g Business Intelligence Components
Deploying Reports to Oracle Application Server 10g
Deploying Forms Applications to Oracle Application Server 10g
Deploying XML Applications and Web Services
Monitoring Oracle Application Server 10g using LogLoader and LogViewer
Tuning the Oracle Application Server 10g Middle-Tier
Reconfiguring an Oracle Application Server 10g Middle-Tier Instance
Backing Up and Restoring Oracle Application Server 10g

Display data graphically
Filter data by using conditions and create parameterized reports
Schedule reports in batch mode
Share workbooks with other users
Export workbooks to other applications
Open a workbook and analyze data using OracleAS Discoverer Viewer
Use and customize Discoverer Portlets in OracleAS Portal
Analyze data by using totals, percentages, and advanced calculations
Generate reports and ad hoc queries
Select default worksheet format options
Format data, headings and background in a worksheet

Business Analysts
End Users

Familiarity with Microsoft Windows applications
Familiarity with Web browsers
SQL Basic Knowledge

Introducing OracleAS Discoverer 10g
Creating Ad-hoc Queries
Managing Queries
Customizing Display Properties
Applying Conditions and Using Parameters
Creating Group Sorts and Applying Summary Functions
Creating Calculated Items
Scheduling and Managing Reports in Batch Mode
Analyzing Data with Drills
Analyzing Data Graphically
Exporting a Worksheet to Other Applications and Printing a Worksheet
Introducing Oracle9iAS Discoverer Viewer
Introducing OracleAS Discoverer Viewer