Module 1: Introduction to SQL

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

Module 2: Java Programming

• Introduction to Java and Oracle platforms
• Object Oriented Programming (OOP) principles
• Syntax and coding conventions
• Operators and Primitive Data Types
• Control Flow
• Oracle JDeveloper
• Creation of classes and objects
• Class loading, object lifecycle  and internal classes
• String manipulation, StringBuffer, wrapper classes and format classes
• Code reutilization by means of Hierarchy and Polymorphism
• Matrix manipulation
• Interfaces and abstract classes
• Throwing and catching exceptions
• Graphical user interfaces
• Event manipulation
• JDBC database access
• Java Web Start

Module 3: Oracle Application Development Framework (ADF)

• UML diagrams
• Problem analysis and design of classes
• Development and testing of a Java program
• Object referencing
• Constructors
• Unidimensional and Multidimensional matrices
• Extensibility by Hierarchy
• Error and exception management
• Multithreading programs
• TCP/IP connectivity