Oracle 10g Developer Training

Course details

This course offers students an introduction to Oracle Database 10g database technology. In this class students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, create database objects, and query meta data.

Oracle Database 10g : Program with PL/SQL

This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks and are introduced to stored procedures and functions. They learn about declaring variables, trapping exceptions and they also learn to declare and control cursors.

Oracle Forms Developer 10g : Build Internet Applications

In this course students build, test, debug, and deploy interactive Internet applications. Working in a graphical user interface (GUI) environment, they develop an order entry application from the ground up. This application incorporates several advanced features that provide a rich user experience while implementing business rules.

Oracle Reports Developer 10g : Build Reports

In this course, students learn how to design and build a variety of standard and custom Web and paper reports using Oracle Reports Developer 10g. Working in the declarative environment of Reports Builder, students learn how to retrieve, display, and format data from any data source in numerous reporting styles and publish the output to any destination.

Course contents

Oracle Database 10g: Introduction to SQL
Course Topics:

• Introduction
• Retrieving Data Using the SQL SELECT Statement
• Restricting and Sorting Data
• Using Single Row Functions to Customize Reports
• 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
• Creating Other Schema Objects
• Managing Objects with Data Dictionary Views
• Controlling User Access
• Manage Schema Objects
• Manipulating Large Data Sets
• Generating Reports by Grouping Related Data
• Managing Data in Different Time Zones
• Searching Data Using Advanced Sub queries
• Hierarchical Data Retrieval
• Performing Regular Expression Support and Case Insensitive

Oracle Database 10g: Program with PL/SQL
Course Topics:

• 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

Oracle Forms Developer 10g: Build Internet Applications
Course Topics:

• 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 Triggers
• Validation
• Navigation
• Transaction Processing
• Writing Flexible Code
• Sharing Objects and Code
• Using WebUtil to Interact with the Client

Oracle Reports Developer 10g: Build Reports
Course Topics:

• 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 Oracle AS Reports Services