SQL

PL SQL

• Introduction
• Writing Basic SQL SELECT Statements
• Restricting and sorting Data
• Single -Row Functions
• Displaying Data from Multiple Tables
• Aggregating Data Using Group Functions
• Subqueries
• Producing Readable Output with iSQL* Plus
• Manipulating Data
• Creating and Managing Tables
• Including Constraints
• Creating Views
• Other Database Objects
• Controlling User Access
• Using SET Operators
• Oracle 9i Datetime Functions
• Enhancements to the Group by Clause
• Advanced Subqueries
• Hierarchical Retrieval
• Oracle 9i Extensions to DML and DDL Statements

• Introduction
• Declaring Variables
• Writing Executable Statements
• Interacting with the Oracle Server
• Writing Control Structures
• Working with composite Data Types
• Writing Explicit Cursors
• Advanced Explicit Cursor Concepts
• Handling Exceptions
• Creating Procedures
• Creating Functions
• Managing Subprograms
• Creating Packages
• More Package Concepts
• Oracle Supplied Packages
• Manipulating Large Objects
• Creating Database Triggers
• More Trigger Concepts
• Managing Dependencie

FORMS

REPORTS

• Introduction to Oracle Forms Developer and
  Oracle Forms Services
• Running a Forms Developer Application
• Working in the Forms Developer Environment
• Creating a Basic Form Module
• Working with Data Blocks and Frames
• Working with text Items
• Creating LOVs and Editors
• Creating Additional Input Items
• Creating Windows and content Canvases
• Working with Other Canvas Types
• Producing Triggers
• Debugging Triggers
• Adding functionally to Items
• Run Time Messages and Alerts
• Query Triggers
• Validation
• Navigation
• Transaction Processing
• Writing Flexible Code
• Sharing Objects and Code
• Introducing Multiple Form Applications

• Introduction to Oracle 9i Reports Developer
• Designing and Running Reports
• Working in Oracle 9i 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 j
• Extending Functionally Using XML
• Creating and Using Report Parameters
• Embedded a Graph in a Report
• Enhancing Matrix Reports
• Building Reports: Efficiency Guidelines
• Coding PL/SQL Triggers

SQL

DATABASE ADMINISTRATOR FUNDAMENTAL I

• Introduction
• Writing Basic SQL SELECT Statements
• Restricting and sorting Data
• Single -Row Functions
• Displaying Data from Multiple Tables
• Aggregating Data Using Group Functions
• Subqueries
• Producing Readable Output with iSQL* Plus
• Manipulating Data
• Creating and Managing Tables
• Including Constraints
• Creating Views
• Other Database Objects
• Controlling User Access
• Using SET Operators
• Oracle 9i Datetime Functions
• Enhancements to the Group by Clause
• Advanced Subqueries
• Hierarchical Retrieval
• Oracle 9i Extensions to DML and DDL Statements

• Networking Overview
• Oracle Net Architecture
• Basic Oracle Net Server Side Configuration
• Naming Method Configuration
• Using and Configuration of the Oracle Shared
• Server
• Backup and Recovery Overview
• Instance and Media Recovery Structures
• Configurating the Database Archiving Mode
• Oracle Recovery Manager Overview and Configuration
• User-Managed Backups
• RMAN Backups
• User-Managed Complete Recovery
• RMAN Complete Recovery
• RMAN Complete Recovery
• RMAN Incomplete Recovery
• RMAN Maintenance
• Workshop

DATABASE ADMINISTRATOR FUNDAMENTAL II

DATABASE PERFORMANCE TUNING

• Networking Overview
• Oracle Net Architecture
• Basic Oracle Net Server Side Configuration
• Naming Method Configuration
• Using and Configuration of the Oracle Shared Server
• Backup and Recovery Overview
• Instance and Media Recovery Structures
• Configurating the Database Archiving Mode
• Oracle Recovery Manager Overview and Configuration
• User-Managed Backups
• RMAN Backups
• User-Managed Complete Recovery
• RMAN Complete Recovery
• RMAN Complete Recovery
• RMAN Incomplete Recovery
• RMAN Maintenance
• Recovery Catalog Creation and Maintenance
• Transporting Data Between Databases
• Workshop

• Overview of Oracle 9i Performance Tuning
• Diagnostic and Tuning Tools
• Sizing the Shared Pool
• Sizing the Buffer Cache
• Sizing Other SGA Structures
• Database Configuration and I/O Issues
• Optimizing Sort Operations
• Diagnosing Contention for Latches
• Tuning Undo Segments
• Monitoring and Detecting Lock Contention
• Tuning the Oracle Shared Server
• SQL Statement Tuning
• Using Oracle Blocks Efficiently
• Application Tuning
• Tuning the Operating System &
• Using Resource Manager
• Workshop Overview

All Right Reserved To System Domain | Advt. by PuneDiary.Com