Oracle Developer 11g

  • Tweet
  • Tweet

ORACLE DEVELOPER TRAINING AT INFO SCHOOL

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 Subqueries 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 PL/SQL
  • Explain the need for PL/SQL
  • Explain the benefits of PL/SQL
  • Identify the different types of PL/SQL blocks
  • Output messages in PL/SQL
  • Declaring PL/SQL Variables
  • Recognize valid and invalid identifiers
  • List the uses of variables, declare and initialize variables, use bind variables
  • List and describe various data types using the %TYPE attribute
  •  Writing Executable Statements
  • Identify lexical units in a PL/SQL block
  • Use built-in SQL functions in PL/SQL and sequences in PL/SQL expressions
  • Describe when implicit conversions take place and when explicit conversions have to be dealt with
  • Write nested blocks and qualify variables with labels
  • Write readable code with appropriate indentation
  • Interacting with the Oracle Database Server
  • Create PL/SQL executable blocks using DML and transaction control statements
  • Make use of the INTO clause to hold the values returned by a SQL statement
  • Writing Control Structures
  • Identify the uses and types of control structures (IF, CASE statements and expressions)
  •  Construct and identify loop statements
  • Apply guidelines when using conditional control structures
  •  Working with Composite Data Types
  •  Create user-defined PL/SQL records
  •   Create a record with the %ROWTYPE attribute
  •   Create an INDEX BY table and INDEX BY table of records
  •   Describe the differences among records, tables, and tables of records
  •   Using Explicit Cursors
  •  Distinguish between usage of implicit and explicit cursors, use SQL cursor attributes
  •   Declare and control explicit cursors, use simple loops and cursor FOR loops to fetch data
  •  Declare and use cursors with parameters
  •  Lock rows with the FOR UPDATE clause and reference the current row with the WHERE CURRENT OF clause
  •   Handling Exceptions
  •   Define PL/SQL exceptions
  •   Recognize unhandled exceptions
  •   Handle different types of exceptions (pre-defined exceptions, non-predefined exceptions and user-defined exceptions)
  •   Propagate exceptions in nested blocks and call applications
  •   Creating Stored Procedures and Functions
  •   Differentiate between anonymous blocks and subprograms
  •   Create a simple procedure and invoke it from an anonymous block
  •   Create a simple function
  •   Create a simple function that accepts a parameter
  •   Differentiate between procedures and functions

 Module III  [Oracle 11g: Forms & Reports]

  •   Introduction to Oracle Forms Developer and Oracle Forms Services
  •   Running a Forms Developer Application
  •   Creating LOVs and Editors
  •   Creating Additional Input Items
  •   Creating Noninput 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