Oracle Reports Developer: Build Reports

Duration: 5 days
Course description:
In this course participants will learn how to design and build a variety of standard and custom Web and paper reports using Oracle Reports Developer. Working in the declarative environment of Reports Builder, participants will learn how to retrieve, display, and format data from any data source in numerous reporting styles and publish the output to any destination.

Who would benefit:
Database administrators and web application designers

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
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

Oracle Forms Developer: Build Internet Applications

Duration: 5 days
Course description:
This course focuses on the use of Oracle Forms Developer to rapidly build scalable, high-performance applications for the Internet. Participants will learn to build, test, debug and deploy interactive Internet applications. Working in a graphical user interface (GUI) environment, they will develop an order entry application from the ground up.

Who would benefit:
Database administrators and web application designers

Producing triggers
Debugging triggers
Adding Functionality to Items
Run-Time messages
Transaction processing
Writing flexible code
Query triggers
Sharing objects and code

Oracle Database: Program with PL/SQL

Duration: 5 days
Course description:
This course is applicable to Oracle Database users. It introduces participants to PL/SQL and helps them understand the benefits of this powerful programming language. Participants will learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications.

Who would benefit:
Database administrators

Declaring PL/SQL edentifiers
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

Oracle Database: Administration Workshop I

Duration: 5 days
Course description:
This course is the first step towards success as an Oracle professional, designed to give a firm foundation in basic database administration. It will explore on how to install and maintain an Oracle database and will provide a conceptual understanding of the Ora- cle database architecture and how its components work and interact with one another.

Who would benefit:
Database administrators

Database maintenance
Performance management
Backup and recovery concepts
Performing database backups
Performing database recovery
Moving data
Managing the Oracle Database instance
Manage the ASM instance
Configuring the Oracle network environment
Managing database storage structures
Administering user security
Managing undo data

Oracle Database: Administration Workshop II

Duration: 2 days
Course description:
This course takes the database administrator beyond the basic tasks covered in the first workshop. The participant begins by gaining a much deeper understanding of possibly the most important job of a DBA – backup and recovery. The concepts and architec- ture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail.

Who would benefit:
Database administrators

Configuring for recoverability
Using the RMAN recovery catalog
Configuring backup settings
Creating backups with RMAN
Automating tasks with the scheduler
Managing space in blocks
Managing space in segments
Managing space for the database

Oracle SQL

Duration: 5 days
Course description:
Raw data needs to be manipulated into information that can be used for checking performance, setting strategies and for decision making. SQL is a data definition and data manipulation language for relational databases. By using SQL it is possible to create a database, load it with data and read & update both data and data definitions.

Who would benefit:
Anyone who handles large volumes of data

Data Dictionary
The SELECT statement
Substitution variables
Joining tables
Report formatting
Users, privileges and synonyms, security