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

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.

Delivery Format Options

  • Self-Paced

    Self-Paced

    Recordings, hands-on labs and expert instructors empower you to train on your own schedule.

    From

    $2025 CAD

  • Private Group Training

    Private Group Training

    Train your entire team in a private, coordinated professional development session at the location of your choice.

    Receive private training for teams online and in-person.

Request a date or location for this course.

What You'll Learn

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

Who Needs To Attend

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