Course Information

Oracle Developer 11g Course Duration: 40 Hours

Oracle Developer 11g Training Timings: Week days 1-2 Hours per day (or) Weekends: 2-3 Hours per day

Oracle Developer 11g Training Method: Online/Classroom Training

Oracle Developer 11g Study Material: Soft Copy

Course Content

Module I [SQL]

  • Retrieving Data Using the SQL SELECT Statement 
  • Restricting and Sorting Data Using Single-Row Functions to Customize Output 
  • Using Conversion Functions and Conditional Expressions 
  • 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 

Module II  [Oracle 11g: PL/SQL Fundamentals]

  • Introduction to Oracle Forms Developer and Oracle Forms Services   
  • Running a Forms Developer Application   Creating LOVs and Editors  
  • Creating Additional Input Items   
  • Creating No input Items 
  • Creating Windows and Content Canvases
  • Working with Other Canvas Types
  • Introduction to Triggers
  • Working in the Forms Developer Environment
  • Creating a Basic Form Module
  • Working with Data Blocks and Frames
  • Working with Text Items
  • 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
  • Introducing Multiple Form Applications
  • Creating a Menu Module
  • Managing Menu Modules
  • Programming Function Keys
  • Building Multiple Form Applications
  • Defining Data Sources
  • Working with Record Groups
  • Using Database Objects in Forms Applications class.

Reviews

Request For Demo