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