|
Oracle Training on the Queen Mary with Dan Hotka!
Yes...Dan Hotka brings his classroom training program to the greater Los Angeles/Orange County/San Diego area.
Oracle SQL Tuning for Developers - March 19 - 20
Oracle Advanced PL/SQL Tips and Techniques March 21 - 23.
The SoCOUG Discounted price: $1,200 per person per class. Register before February 17 and receive another $100 off. Register for both classes and receive yet another $100 off!( If you want to register for both classes the price is $2000 if paid before Feb.17, 2012) Contact Dan Hotka for additional information and registration details.
DHotka@Earthlink.net
This is Instructor-led training, complete with hands-on computer lab exercises. There are 20 seats available in each class. Each course comes with a complete course guide that includes the lecture notes and lab guides. Related pocket references and scripts are also distributed to each attendee. Lunch is not provided, but there are lots of options on board the ship. Morning Coffee and Afternoon snacks will be provided. Classes are between 9am and 4pm daily.
Oracle SQL Tuning for Developers
This course is designed for the Oracle professional with novice or no SQL tuning skills.
The course starts out with a complete overview of the Oracle architecture so students can get an understanding how their SQL and applications can take advantage of the computing environment. This course goes in-depth on understanding and controlling the explain plan (how Oracle retrieves data and in what order). The discussions include the differences of the various Explain Plan steps such as Merge-Join and Nested-Loop, and when is it best to use each. Dan goes into considerable detail, with SQL examples, on how the optimizers (both rule-based and cost-based but mostly cost-based) make their decisions. Students will work with a variety of SQL statements, reviewing explain plans and making changes to make these SQL statements perform better. Lectures include index design, using hints and coding style to control the explain plans, and how to use useful tools such as index monitoring, SQL Trace, and the PL/SQL profiler. This course takes a close look at indexes: how Oracle selects them, why they are sometimes not used, and how to tell if indexes are being used/not being used.
The focus this course is tuning SQL via coding style. The instructor finds that tuning in this fashion maintains the performance of the SQL when migrating to other Oracle environments (upgrades to newer releases).
Lectures and topics are enhanced with live illustrations and hands-on exercises.
Topics covered includes:
Oracle Architecture from a SQL Performance point-of-view
Understanding SQL Tuning Statement Topics
Reading Explain Plans/Understanding Explain Plans
Controlling both the Cost-based and Rule-based Optimizers
A close look at Indexes how they work and how they are selected
SQL Tuning via coding style
Oracle Trace Facility collecting SQL and interpreting using TKProf
Profiling PL/SQL, PL/SQL Coding Tips
Oracle Advanced PL/SQL Tips and Techniques
The attendees have the opportunity to learn a variety of advanced PL/SQL techniques including advanced cursor management/cursor sharing, code sharing, code debugging, transaction management, and more. This course includes a variety of Oracle performance techniques and also is a good overview of Oracle10g and Oracle11g new PL/SQL features.
This course could easily be named "New Features for Developers".
Lectures and topics are enhanced with live illustrations and hands-on exercises.
Topics covered:
Oracle Architecture
Introduction to PL/SQL
Syntax and language structure review
PL/SQL Topics
Package Usage (both User Defined and Oracle Defined Packages)
Compiling options
Cursor Sharing/Cursor Variables
Collections
Dynamic SQL
Autonomous Transactions
Working with Large Objects
PL/SQL Coding Tips
Debugging PL/SQL
Profiling PL/SQL
Complete outlines are available on Dan's website:
http://home.earthlink.net/~dhotka/
|
