Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Oracle 11g: Programing with PL/SQL

GK# 400139

Course Overview

TOP

Oracle Database 11g delivers economies of scale on easily managed low-cost grids, making it easier to:

  • Reduce cost of downtime with maximum availability architecture
  • Change IT systems faster using Real Application Testing
  • Partition and compress data to run queries faster using less disks
  • Securely protect and audit data, and enable total recall of data
  • Make productive use of standby resources with Active Data Guard

This course addresses Oracle Database 11g programming with PL/SQL and is focused on:

Oracle Database 11g: PL/SQL Fundamentals

  • PL/SQL Variables, Attributes, and Executable Statements
  • Using DML, DDL, Cursors, Control Structures, and Loops
  • Using Data Types, INDEX BY Tables, and Cursors in PL/SQL
  • Working with Exceptions, Subprograms, JDeveloper, and REF Cursors

Oracle Database 11g: Program with PL/SQL

  • Getting Started With PL/SQL
  • Using DML, DDL, Cursors, Loops, and Control Structures
  • Using Data Types, INDEX BY Tables, and Cursors
  • Using Exceptions, Subprograms, JDeveloper, and REF Cursors
  • Subprograms, Packages, and Exception Handling
  • Packages, Dynamic SQL, and Coding Considerations
  • Using Triggers and the PL/SQL Compiler
  • PL/SQL Code and Dependency Management

 

For self-paced learning, you will have access to this course for 12 months from the purchase date.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP

Oracle Database 11g: PL/SQL Fundamentals

  • Steps for getting started with PL/SQL, benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules
  • Steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.
  • Ways to create user-defined PL/SQL records and INDEX BY tables and steps for declaring and controlling explicit cursors and cursors with parameters
  • Ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables

Oracle Database 11g: Program with PL/SQL

  • Steps for getting started with PL/SQL, benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules
  • Steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures
  • Ways to create user-defined PL/SQL records and INDEX BY tables and steps for declaring and controlling explicit cursors and cursors with parameters
  • Ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables
  • Steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their ex
  • Steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code
  • Steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings
  • Steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies

Outline

TOP
Viewing outline for:

Self-Paced Outline

Oracle Database 11g: PL/SQL Fundamentals

1. Oracle Database 11g: PL/SQL Variables, Attributes, and Executable Statements

  • Features and capabilities of SQL Developer, SQL*Plus, and JDeveloper
  • Features and benefits of PL/SQL and the steps for building basic PL/SQL blocks
  • Declaring and initializing PL/SQL variables
  • Uses of different PL/SQL data types, the %TYPE attribute, and BIND variables
  • Constructing executable statements using various PL/SQL block elements
  • Evaluate a block of PL/SQL code with respect to scoping and nesting rules and write and test PL/SQL blocks

2. Oracle Database 11g: Using DML, DDL, Cursors, Control Structures, and Loops

  • Performing basic data manipulation and transaction control in PL/SQL and determining the outcome of SQL statements
  • Writing control structures, such as IF statements and CASE expressions, in a PL/SQL block
  • Writing and identifying loop statements
  • Create PL/SQL blocks that incorporate loops and conditional control structures

3. Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors in PL/SQL

  • Creating user-defined PL/SQL records and records with the %ROWTYPE attribute
  • Creating an INDEX BY table and table of records and the uses of nested tables and VARRAYs
  • Define, create, and use INDEX BY tables and a PL/SQL record in a given scenario
  • Declaring and controlling explicit cursors and writing FOR loops to fetch data from them
  • Declaring and using cursors with parameters, locking rows, and referencing the current row in an explicit cursor

4. Oracle Database 11g: Working with Exceptions, Subprograms, JDeveloper, and REF Cursors

  • Trapping non-predefined exceptions in PL/SQL
  • Trapping user-defined exceptions
  • Create an exception handler in a given scenario
  • Creating and invoking simple stored procedures and functions
  • Scope and capabilities of JDeveloper for developing and deploying Java applications and Web services
  • Using cursor variables to pass query result sets and fetching rows from them

Oracle Database 11g: Program with PL/SQL

1. Oracle Database 11g: Getting Started With PL/SQL

  • Features and capabilities of SQL Developer, SQL*Plus, and JDeveloper
  • Features and benefits of PL/SQL and the steps for building basic PL/SQL blocks
  • Steps for declaring and initializing PL/SQL variables
  • Uses of different PL/SQL data types, the %TYPE attribute, and BIND variables
  • Constructing executable statements using various PL/SQL block elements
  • Evaluate a block of PL/SQL code with respect to scoping and nesting rules and write and test PL/SQL blocks

2. Oracle Database 11g: Using DML, DDL, Cursors, Loops, and Control Structures

  • Performing basic data manipulation and transaction control in PL/SQL and determining the outcome of SQL statements
  • Writing control structures, such as IF statements and CASE expressions, in a PL/SQL block
  • Writing and identifying loop statements
  • Create PL/SQL blocks that incorporate loops and conditional control structures

3. Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors

  • Creating user-defined PL/SQL records and records with the %ROWTYPE attribute
  • Creating an INDEX BY table and table of records and the uses of nested tables and VARRAYs
  • Define, create, and use INDEX BY tables and a PL/SQL record in a given scenario
  • Declaring and controlling explicit cursors and for writing FOR loops to fetch data from them
  • Declaring and using cursors with parameters, locking rows, and referencing the current row in an explicit cursor

4. Oracle Database 11g: Using Exceptions, Subprograms, JDeveloper, and REF Cursors

  • Trapping non-predefined exceptions in PL/SQL
  • Trapping user-defined exceptions
  • Create an exception handler in a given scenario
  • Creating and invoking simple stored procedures and functions
  • Scope and capabilities of JDeveloper for developing and deploying Java applications and Web services
  • Using cursor variables to pass query result sets and fetching rows from them

5. Oracle Database 11g: Subprograms, Packages, and Exception Handling

  • Benefits of modularized and layered subprogram design
  • Creating and calling procedures and passing parameters
  • Handling exceptions in procedures and for dropping procedures
  • Creating and invoking functions
  • Using SQL Developer to debug PL/SQL subprograms
  • Benefits and components of a package and the steps for creating one
  • Create a package specification and package body in a given scenario and invoke the package's constructs

6. Oracle Database 11g: Packages, Dynamic SQL, and Coding Considerations

  • Overloading subprograms, using forward declarations, writing package initialization blocks, and maintaining persistent package state
  • Using the Oracle-supplied packages DBMS_OUTPUT, UTL_FILE, and UTL_MAIL
  • Using Oracle-supplied packages to generate a simple Web page and schedule PL/SQL code for execution
  • Constructing and executing SQL statements at run time using native dynamic SQL statements in PL/SQL
  • Alter a package so that it contains overloaded subprograms, use an Oracle-supplied package, and execute dynamic SQL in a given scenario
  • Designing packages so that code is easy to maintain, efficient, and readable, and so that PL/SQL applications perform better
  • Binding whole arrays of values in a single operation and retrieving information about a row affected by a SQL operation

7. Oracle Database 11g: Using Triggers and the PL/SQL Compiler

  • Creating and using database triggers
  • Enabling, disabling, testing, managing, and removing database triggers
  • Creating and using compound, DDL, and event database triggers
  • Create statement and row triggers, including a trigger for a business rule and a package with triggers that resolve a mutating table issue
  • Benefits and capabilities of the PL/SQL compiler and its parameters
  • Using the PL/SQL compiler initialization parameters, compiling a procedure, and managing compiler warnings

8. Oracle Database 11g: PL/SQL Code and Dependency Management

  • Selectively including PL/SQL source code by using conditional compilation, and for wrapping a PL/SQL unit
  • Predicting how changing a database object affects procedures and functions by tracking procedural dependencies
  • Managing remote dependencies and recompiling a PL/SQL program unit
  • Use conditional compilation, wrap PL/SQL code, a

Who Should Attend

TOP

Application developers, database designers, database administrators, forms developers, PL/SQL developers, technical consultants, system analysts, and portal developers

Course Delivery

This course is available in the following formats:

Self-Paced

On-demand content enables you to train on your own schedule.



Request this course in a different delivery format.
Enroll