Oracle Database 11g: PL/SQL Fundamentals (Self-Study Course)


Who should attend

  • Database administrators
  • Database designers
  • Forms developers
  • PL/SQL developers
  • Technical consultants

Course Objectives

  • Identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools
  • Identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures
  • 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
  • Recognize ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables

Product Description

  • Oracle Database 11g: PL/SQL Variables, Attributes, and Executable Statements
    • Getting Started with PL/SQL Elements
    • Using Executable Statements
  • Oracle Database 11g: Using DML, DDL, Cursors, Control Structures, and Loops
    • Using DML, DDL, and SQL Cursors in PL/SQL
    • Using Control Structures and Loops in PL/SQL
  • Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors in PL/SQL
    • Using Data Types, INDEX BY, and PL/SQL Records
    • Using Explicit Cursors and Attributes in PL/SQL
  • Oracle Database 11g: Working with Exceptions, Subprograms, JDeveloper, and REF Cursors
    • Handling Exceptions in PL/SQL
    • Using JDeveloper and Cursor Variables
Price (excl. tax)

638.- €