Oracle9i: Program with PL/SQL training seminars presented by Netcom Learning register now on FindaSeminar.com

findaseminar logo balls FindaSeminar.com
event search registration and marketing services since 2002
Advanced Search
 
 

Oracle9i: Program with PL/SQL  

 Email information about this seminar Oracle9i: Program with PL/SQL by Netcom Learning to yourself your manager or associates Email this event... View and register for other training seminars like Oracle9i: Program with PL/SQL by Netcom Learning on FindaSeminar.com Find similar training.. Find and register for other training seminars by Netcom Learning on FindaSeminar.com Other seminars from Netcom Learning

By:

Netcom Learning   

For:

This course is intended for Designer/Developers, System Analyst, Database Administrators, Application Developers, and anyone who is interested in working in the database administration field.

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

This course will introduce students to PL/SQL and help them to understand the benefits of this powerful programming language. (see full course description)

 

 Seminar / Training class dates & locations

 

No seminar dates for this event are currently scheduled.  Please use the seminars search box above or choose one of the following additional training search options to find similar training.

oracle91+database+pl%2Fsql+isql training seminars workshops conferences online training

Providers course catalog

Find seminars by state

Find seminars by city

Request on site training

Use Advanced Search

NEW  Don't miss training you want to attend

Receive a personal Training Alert when training you want to attend comes to your area. Create a personal Training Alert now  it's Free and only takes a minute!


 

 

 

share this page 

print the agenda print agenda for the Oracle9i: Program with PL/SQL seminar

 

 

Training Course Syllabus:


Description
This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create procedures, functions, packages, and database triggers. Students use iSQL*Plus to develop these program units. Students also learn to manage PL/SQL program units and database triggers, to manage dependencies, to manipulate large objects, and to use some of the Oracle-supplied packages.

Objectives
·  Describe the features and syntax of PL/SQL
·  Manage program constructs
·  Handle runtime errors
·  Describe Oracle-supplied packages
·  Create, execute, and maintain procedures, functions, packages, and triggers
·  Conditionally control code flow (loops, control structures, and explicit cursors)
·  Manipulate large objects
·  Manage dependencies

Required Prerequisites
 ·  Introduction to Oracle9i: SQL, PL/SQL, and SQL*Plus

Exams
 ·  1Z0-147 : Oracle9i: Program with PL/SQL

Next Steps
 ·  Oracle9i Forms Developer: Build Internet Applications

Outline
    1. Introduction
      1. Describing PL/SQL
      2. Describing the Use of PL/SQL for the Developer and the Database Administrator
      3. Explaining the Benefits of PL/SQL
      4. PL/SQL program constructs
      5. PL/SQL anonymous block structure
      6. Subprogram block structure
      7. Course objectives and overview
    2. Declaring Variables
      1. Recognizing the Basic PL/SQL Block and Its Sections
      2. Describing the Significance of Variables in PL/SQL
      3. Distinguishing Between PL/SQL and Non-PL/SQL Variables
      4. Declaring Variables and Constants
      5. Executing a PL/SQL Block
    3. Writing Executable Statements
      1. Recognizing the Significance of the Executable Section
      2. Writing Statements Within the Executable Section
      3. Describing the Rules of Nested Blocks
      4. Executing and Testing a PL/SQL Block
      5. Using Coding Conventions
    4. Interacting with the Oracle Server
      1. Writing a Successful SELECT Statement in PL/SQL
      2. Declaring the Data type and Size of a PL/SQL Variable Dynamically
      3. Writing Data Manipulation Language (DML) Statements in PL/SQL
      4. Controlling Transactions in PL/SQL
      5. Determining the Outcome of SQL DML Statements
    5. Writing Control Structures
      1. Identifying the Uses and Types of Control Structures
      2. Constructing an IF Statement
      3. Constructing and Identifying Different Loop Statements
      4. Controlling Block Flow Using Nested Loops and Labels
      5. Using Logic Tables
    6. Working with Composite Data types
      1. Creating User-Defined PL/SQL Records
      2. Creating a PL/SQL Table
      3. Creating a PL/SQL Table of Records
      4. Differentiating Among Records, Tables, and Tables of Records
    7. Writing Explicit Cursors
      1. Using a PL/SQL Record Variable
      2. Distinguishing Between the Implicit and Explicit Cursor
      3. Writing a Cursor FOR Loop
    8. Advanced Explicit Cursor Concepts
      1. Writing a Cursor that Uses Parameters
      2. Determining When a FOR UPDATE Clause in a Cursor Is Required
      3. Using a PL/SQL Table Variable
      4. Using a PL/SQL Table of Records
    9. Handling Exceptions
      1. Defining PL/SQL Exceptions
      2. Recognizing Unhandled Exceptions
      3. Listing and Using Different Types of PL/SQL Exception Handlers
      4. Trapping Unanticipated Errors
      5. Describing the Effect of Exception Propagation in Nested Blocks
      6. Customizing PL/SQL Exception Messages
    10. Creating Procedures
      1. Describe the uses of procedures
      2. Create procedures
      3. Create procedures with arguments
      4. Invoke a procedure
      5. Remove a procedure
    11. Creating Functions
      1. Describe the uses of functions
      2. Create a function
      3. Invoke a function
      4. Remove a function
      5. Differentiate between a procedure and a function
    12. Managing Subprograms
      1. Describe system privilege requirements
      2. Describe object privilege requirements
      3. Query the relevant data dictionary views
      4. Debug subprograms
    13. Creating Packages
      1. Describe packages and list their possible components
      2. Create packages that include public and private subprograms, as well as global and local variables
      3. Invoke objects in a package
      4. Remove packages
    14. More Package Concepts
      1. Write packages that use the overloading feature of PL/SQL
      2. Avoid errors with mutually referential subprograms
      3. Initialize variables with a one-time-only procedure
      4. Specify the purity level of packaged functions
      5. Describe the persistent state of packaged variables, cursors, tables, and records
      6. Query the relevant data dictionary views
    15. Using Oracle-Supplied Packages
      1. Overview of Oracle-supplied packages
      2. View examples of some supplied packages
      3. Write dynamic SQL
    16. Creating Database Triggers
      1. Describe different types of triggers
      2. Describe database triggers and their use
      3. Create database triggers
      4. Describe database trigger firing rules
      5. Drop database triggers
    17. More Trigger Concepts
      1. Create triggers that fire when certain database actions occur
      2. List some of the limitations of database triggers
      3. Determine when to use database triggers or Oracle Server features
      4. Create triggers by using alternative events (notINSERT/UPDATE/DELETE)
      5. Create triggers by using alternative levels (not STATEMENT/ROW)
      6. Query the relevant data dictionary views
    18. Managing Dependencies
      1. Overview of object dependencies
      2. Manage PL/SQL objects for recompilation
    19. Manipulating Large Objects
      1. Compare and contrast LONG/RAW/LONG RAW with large objects (LOBs)
      2. Understand LOBs
      3. Manage binary large file objects (BFILEs)
      4. Use PL/SQL with an LOB
      5. Create a table with LOB columns
      6. Manipulate LOBs
      7. Use DBMS_LOB Oracle-supplied packages
      8. Create a temporary LOB

    Seminar Summary:

    This course will introduce students to PL/SQL and help them to understand the benefits of this powerful programming language. (see full course description)

    print this agenda print agenda for the Oracle9i: Program with PL/SQL training seminar

     view dates and locations for this seminar

     

     

     

    Custom Search