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:
Dynamic SQL
Code and test the EXECUTE IMMEDIATE command to create and execute SQL at run-time.
Collections
Code an associative array accessed with a string unique key to retrieve a value.
DBMS_METADATA()
Get metadata object definition in the form of a DDL statement.
Supplied Packages
Utilize the DBMS_UTILITY to return version data of the database.
Oracle PL/SQL Compilation
Convert PL/SQL stored procedures to native code shared libraries which are linked into the kernel.
Profiler
Detect a performance issue using the Oracle profiler.
Debugging
Using SQL Developer, debug a procedure supplied by the instructor.
Variable Declaration
Store a computed value into a SQL PLUS variable as a host variable; use the host variable in a generated report.
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.
Procedures
Code a procedure using positional, named, or mixed notation for subprogram parameters.
Packages
Develop a package with a generalized routine; the instructor will provide the application.
Manipulating Large Objects
Create a table with Internal LOBs and retrieve the data for display in a web browser.
Database Triggers
Create autonomous triggers and test the trigger with INSERTS, DELETES, and UPDATES.
Virtual Classroom
Blended Learning
↓
Synchronous Instruction
Asynchronous Instruction
Effective February 27, 2012, the course dates listed on the CETi 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. CETi makes no representation regarding ownership in any of the software products that we train on.
CETi 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 CETi course and that the employer has a licensed version of the software.
Certain courses only should be taught by the source software company training company and open source purveyor.
