Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - Oracle: PL/SQL Programming - Advanced

Home

distance-learning center

Application of Classic Teaching Models Mobile Classrooms

Professional Distance-learning

IT Training Services



PCEC121

Oracle: PL/SQL Programming - Advanced
DURATION: 4 days

FEE: $1,980

PRIVATE GROUP FEE: $
Based upon a class size of six students.

Scheduling can be adjusted to employee work hours and incorporate client assignments.

SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.

AUDIENCE:

  • Programmer
  • Database Administrator
  • System Designer
  • System Analyst
  • IT Professional
 
   

DATES:

CONTENT AND OBJECTIVES:
    1. Dynamic SQL
      • Code and test the EXECUTE IMMEDIATE command to create and execute SQL at run-time.
    2. Collections
      • Code an associative array accessed via a string unique key to retrieve a value.
    3. DBMS_METADATA()
      • Get metadata object definition in the form of a DDL statement.
    4. Supplied Packages
      • Utilize the DBMS_UTILITY to return version data of the database.
    5. Oracle PL/SQL Compilation
      • Convert PL/SQL stored procedures to native code shared libraries which are linked into the kernel.
    6. Profiler
      • Detect a performance issue using the Oracle profiler.
    7. Debugging
      • Using SQL Developer, debug a procedure supplied by the instructor.
    8. Variable declaration
      • Store a computed value into a SQL PLUS variable as a host variable; use the host variable in a generated report.
    9. SQL Cursor
      • Declare and run a cursor using %FOUND to determine if any rows were extracted into the resultset.
      • Use the %ROWCOUNT attribute to determine how many rows have been affected after an UPDATE.
      • Create an explicit and explicit cursor using dynamic SQL..
      • Run a BULK COLLECT clause which will fetch all rows from the resultset at one time.
      • Code an update routine using a cursor with the WHERE CURRENT OF clause.
    10. Procedures
      • Code a procedure using positional, named, or mixed notation for subprogram parameters.
    11. Packages
      • Develop a package with a generalized routine; the instructor will provide the application.
    12. Manipulating large objects
      • Create a table with Internal LOBs and retrieve the data for display in a web browser.
    13. Database triggers
      • Create autonomous triggers and test the trigger with INSERTS, DELETES, and UPDATES

 
 
    Web-based Training   Blended Learning    
Synchronous
Instruction
Asynchronous
Instruction
 

 

Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.

Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.

SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.