Course Content
Introduction to SQL
- Introduction
- Writing a Basic SQL statement
- Restricting and Sorting Data
- Single Row Functions
- Displaying Data from Multiple Tables
- Aggregating Data by using Group functions
- Writing Sub queries
- Producing Readable Output with iSQL *Plus
- Manipulating Data
- Creating and Managing Tables
- Including Constraints
- Creating Views
- Other Database Objects
- Controlling User Access
- SQL Workshop
- Using Set Operators
- Oracle 9i Date time Functions
- Enhancements to GROUP By clause
- Advanced Sub queries
- Hierarchical Retrieval
- Oracle 9i Extensions to DML and DDL Statements
PL/SQL
- 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
- Using Oracle-Supplied Packages
- Creating Database Triggers
- More Trigger Concepts
- Managing Dependencies
Oracle Forms Release - (Option 1)
- Introduction to Forms
- Overview of the Designer Interface
- The Runtime Interface
- Querying the Database
- Normal and Enter Query Mode
- Manipulating the Database
- Enhancing the Form
- The Forms Designer
- The object navigator
- The layout editor
- The properties Window
- The Menu Editor
- Forms Objects
- Blocks and Relations
- Items
- Control
- Windows and Dialogue Boxes
- Record Structures and other Objects
- Menus and Toolbars
Oracle Reports Release-(Option 2)
- Introduction to Reports
- Overview of Designer Interface
- The Object Navigator the Data Model
- Defining the Data Model
- The layout model
- Specifying a Runtime Parameter form
- Creating Reports
- Formulas & Summaries
- Changing Fonts and modifying field properties
- Page layout adjusting page size
- Report Headers and Footers
- Anchors
- Creating Forms
- Creating Form letters
- Creating Mailing labels
- Creating matrix reports
- Combination Reports
- Creating Parameter Forms
- Adding Buttons, Images and other Objects to your reports
- Creating Templates
- Adding Templates to the default design interface
- The Runtime interface.