|
Main Menu
Tools: Dan Hotka:
|
Author/Instructor/Expert
Dan Hotka is a Training Specialist who has over 32 years in the computer industry and over 26 years of experience with Oracle products. He is an Oracle Ace Director Dan’s latest book is the Oracle SQL Tuning: A Close Look at Explain Plans by Amazon. He is also the author of the TOAD Handbook by Pearson, SQL Developer Handbook by Oracle Press, Oracle9i Development By Example and Oracle8i from Scratch by Que and has co-authored 7 other popular books including the Database Oracle10g Linux Administration by Oracle Press. He is frequently published in Oracle trade journals, and regularly speaks at Oracle conferences and user groups around the world. Check out these classes! SQL Performance Tuning for Developers: My ever-popular
class 2-days on-site/public or 4 half-day web sessions aimed squarely at developers. The focus on this class is problem SQL. I concentrates on how Oracle assembles explain plans and how
to control the explain plan thru hints and coding style. The material goes into great detail on how indexes work and
how Oracle selects them and skips them.
I cover the important tools needed to capture and tune problem
SQL. Advanced PL/SQL Programming Tips and Techniques: Another popular class that runs all week in a half-day format over the web or 3 days in an on-site/public setting. This class could easily be called 'New Features for Developers'. I cover the new compiler features, trigger features, cursor management, and collection features. This course covers many of the performance issues associated with both SQL and PL/SQL. I share my years of tuning experience using PL/SQL to solve some of the more difficult issues I have faced. Click here for web course outlines See course outlines for the on-site/public offerings Email Dan at < Dan -at- DanHotka -dot- com > for pricing and registration
last updated 1/10/2012 |
||||
| . |
and an
internationally recognized Oracle expert with Oracle experience dating
back to the Oracle V4.0 days.