Font size:

Description:

This is a bundled training package. It contains training for each of the bundled items below:

Course Price
Oracle Database 11g: Getting Started With PL/SQL $74.95
Oracle Database 11g: Using DML, DDL, Cursors, Loops, and Control Structures $74.95
Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors $74.95
Oracle Database 11g: Using Exceptions, Subprograms, JDeveloper, and REF Cursors $74.95
Oracle Database 11g: Subprograms, Packages, and Exception Handling $74.95
Oracle Database 11g: Packages, Dynamic SQL, and Coding Considerations $74.95
Oracle Database 11g: Using Triggers and the PL/SQL Compiler $74.95
Oracle Database 11g: PL/SQL Code and Dependency Management $74.95

Bundle Price: $289.00
Total Savings: $310.60


Oracle Database 11g: Getting Started With PL/SQL

To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.
  • Using PL/SQL Development Environments - recognize the features and capabilities of SQL Developer, SQL*Plus, and JDeveloper.
  • Introducing PL/SQL - identify the features and benefits of PL/SQL and identify the steps for building basic PL/SQL blocks.
  • Introducing PL/SQL Variables - identify the steps for declaring and initializing PL/SQL variables.
  • Introducing PL/SQL Data Types and Attributes - identify the uses of different PL/SQL data types, the %TYPE attribute, and BIND variables.
  • Writing Executable Statements - identify the steps for constructing executable statements using various PL/SQL block elements.
  • Working with Executable Statements - evaluate a block of PL/SQL code with respect to scoping and nesting rules, and write and test PL/SQL blocks.

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

To identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures.
  • Manipulating Data and Controlling Transactions - recognize the steps for performing basic data manipulation and transaction control in PL/SQL, and for determining the outcome of SQL statements.
  • Writing Control Structures - identify the steps for writing control structures, such as IF statements and CASE expressions, in a PL/SQL block.
  • Working with Loops - recognize the steps for writing and identifying loop statements.
  • Using Control Structures and Loops - create PL/SQL blocks that incorporate loops and conditional control structures.

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

To recognize ways to create user-defined PL/SQL records and INDEX BY tables, and identify the steps for declaring and controlling explicit cursors and cursors with parameters.
  • Working with Composite Data Types - recognize the steps for creating user-defined PL/SQL records and records with the %ROWTYPE attribute.
  • Using INDEX BY, Nested Tables, and VARRAYs - recognize the steps for creating an INDEX BY table and table of records, and identify the uses of nested tables and VARRAYs.
  • Working with INDEX BY Tables and PL/SQL Records - define, create, and use INDEX BY tables and a PL/SQL record in a given scenario.
  • Using Explicit Cursors and Cursor Attributes - identify the steps for declaring and controlling explicit cursors, and for writing FOR loops to fetch data from them.
  • Using Cursors with Parameters - recognize the steps for declaring and using cursors with parameters, locking rows, and referencing the current row in an explicit cursor.

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

To recognize ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables.
  • Handling Exceptions - identify the steps for trapping non-predefined exceptions in PL/SQL.
  • Working with User-Defined Exceptions - recognize the steps for trapping user-defined exceptions.
  • Working with Exceptions - create an exception handler in a given scenario.
  • Creating Stored Procedures and Functions - identify the steps for creating and invoking simple stored procedures and functions.
  • Using JDeveloper - recognize the scope and capabilities of JDeveloper for developing and deploying Java applications and Web services.
  • Using Cursor Variables - recognize the steps for using cursor variables to pass query result sets, and for fetching rows from them.

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

To identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptions.
  • Designing Subprograms - identify the benefits of modularized and layered subprogram design.
  • Using Procedures - recognize the steps for creating and calling procedures and passing parameters.
  • Handling Exceptions - identify the steps for handling exceptions in procedures and for dropping procedures.
  • Creating Functions - recognize the steps for creating and invoking functions.
  • Debugging Subprograms - recognize the steps for using SQL Developer to debug PL/SQL subprograms.
  • Creating Packages - identify the benefits and components of a package, and recognize the steps for creating one.
  • Working with Packages - create a package specification and package body in a given scenario, and invoke the package's constructs.

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

To recognize the steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code.
  • Working with Packages - recognize the steps for overloading subprograms, using forward declarations, writing package initialization blocks, and maintaining persistent package state.
  • Using Oracle-Supplied Packages - identify the steps for using the Oracle-supplied packages DBMS_OUTPUT, UTL_FILE, and UTL_MAIL.
  • Using the DBMS_SCHEDULER and HTP Packages - recognize the steps for using Oracle-supplied packages to generate a simple Web page and schedule PL/SQL code for execution.
  • Using Dynamic SQL - identify the steps for constructing and executing SQL statements at run time, using native dynamic SQL statements in PL/SQL.
  • Using Packages 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.
  • Design Considerations for PL/SQL Code - identify the steps for designing packages so that code is easy to maintain, efficient, and readable, and so that PL/SQL applications perform better.
  • Using Bulk Binding and the RETURNING Clause - Identify the steps for binding whole arrays of values in a single operation, and for retrieving information about a row affected by a SQL operation.

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

To identify the steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings.
  • Creating Triggers - identify the steps for creating and using database triggers.
  • Managing Triggers - recognize the steps for enabling, disabling, testing, managing, and removing database triggers.
  • Using Compound, DDL, and Event Database Triggers - identify the steps for creating and using compound, DDL, and event database triggers.
  • Working with Triggers - create statement and row triggers, including a trigger for a business rule and a package with triggers that resolve a mutating table issue.
  • Using the PL/SQL Compiler - recognize the benefits and capabilities of the PL/SQL compiler and its parameters.
  • Using PL/SQL Compiler Parameters and Warnings - recognize the steps for using the PL/SQL compiler initialization parameters, compiling a procedure, and managing compiler warnings.

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

To identify the steps for performing conditional compilation to selectively use PL/SQL code, wrapping code, and tracking dependencies.
  • Managing PL/SQL Code - identify the steps for selectively including PL/SQL source code by using conditional compilation, and for wrapping a PL/SQL unit.
  • Tracking Dependencies - recognize the steps for predicting how changing a database object affects procedures and functions by tracking procedural dependencies.
  • Exploring Dependencies - recognize the steps for managing remote dependencies and recompiling a PL/SQL program unit.
  • Using Packages, Compilation, and Dependencies - use conditional compilation, wrap PL/SQL code, and manage dependencies in a given scenario.
Register Now
Oracle Database 11g: Program with PL/SQL e-learning bundle
  • Course ID:
    271470
  • Duration:
    n/a
  • Price:
    $289