• Introduction

  • Retrieving Data Using the SQL Select Statement
  • Restricting and Sorting Data
  • Using Single Row Functions to Customize Output
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables
  • Using Subqueries to solve queries
  • Using the Set Operators
  • Manipulating Data
  • Using DDL Statements to Create & Manage Tables
  • Creating Other Schema Objects
  • Managing Objects with Data Dictionary Views

Oracle 10g Database SQL Fundamentals II

• Introduction

  • Controlling User Access
  • Managing Schema Objects
  • Manipulating Large Data Sets
  • Generating Reports by Grouping related Data
  • Managing Data in Different Time Zones
  • Retrieving Data using Subqueries
  • Hierarchical Retrieval
  • Regular Expression Support

 

 

PAPER II

Oracle 10g Database PL/SQL Fundamentals I


• Introduction

  • Introduction to PL/SQL
  • Declaring PL/SQL Variables
  • Writing Executable Statements
  • Interacting with the Oracle Server
  • Writing Control Structures
  • Working with Composite Data Types
  • Using Explicit Cursors
  • Handling Exception
  • Creating Stored Procedures and Functions

Oracle 10g Database Develop PL/SQL Program Units

• Introduction

  • Creating Stored Procedures
  • Creating Stored Functions
  • Creating Packages
  • Using More Package Concepts
  • Using Oracle Supplied Packages in Application Development
  • Dynamic SQL and Metadata
  • Design Consideration for PL/SQL Code
  • Managing Dependencies
  • Manipulating Large Objects
  • Creating Triggers
  • Applications for Triggers
  • Understanding and Influencing the PL/SQL Compiler

PAPER III

Oracle Forms Developer 10g Build Internet Applications

• 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
• Creating a Master-Detail Form
• Working with Data Blocks and Frames
• Working with Text Items
• Creating LOVs and Editors
• Creating Additional Input Items
• Creating Noninput Items
• Creating Windows and Content Canvases
• Working with other Canvas Types
• Introduction to Triggers
• 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
• Introducing Multiple Form Application

Facilities:  1.24 Hrs Lab with Internet Facility 2.Students can do Lab till they pass Online Examination without any extra cost.

Batch Timings:  7 - 9 am / 10 - 1 pm / 2 - 5 pm / 6 - 8 pm / Sat & Sun Only / Sunday Only.