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.
CONTENT AND OBJECTIVES:
The Application Environment
Utilize the data dictionary to examine the architecture and database.
Use the Oracle utilities to load a database.
Maintaining Data Integrity
Create a table for testing locking and read consistency.
There are several techniques for ending a transaction: 1- Issue a Rollback on the current transaction and review the results. 2- Examine what happens to the current transaction if a DDL statement is executed. 3- Examine what happens to the current transaction if the session is killed.
Experiment with the options available for maintaining read consistency.
Code DML for experimenting with a data lock.
PL/SQL Programming Techniques
Code a program which uses a dynamic PL/SQL reference cursor.
Recognize the pitfalls to avoid with dynamic SQL.
Oracle PL/SQL Extensions
Code the utilities which will improve performance and result in more efficient application maintenance.
Improving Query Performance
Write and execute SQL using hints to determine when they should be used and the effects of hints.
Tuning the Application
Use the Profiler API to profile run-time behavior and identify performance bottlenecks.
Oracle provides a Trace API for tracing the execution of programs on the server; trace the execution by subprogram or exception.
SQL Statement Tuning
Change the execution plan for running queries without changing the code itself; this will serve to insulate an application execution plan against any structural changes or upgrades.
Utilize Stored Outlines for storing the execution plan in Oracle tables; this will later be referred to by the optimizer for executing the queries and optimizer plan stability.
Tuning the Operating System
Adjust optimizer statistics and parameters.
Optimize the instance.
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.