Instructor-led training at your desk!
Yes, the future is here today. I’ve
had the opportunity to do training remotely for a large company this summer and
the training sessions have gone extremely well.
I provide the same class-room lecture over the web.
You see the presentations; you receive my annotated course guide with all
the slides/notes/and lab exercises; and assistance to setup a lab environment at
your site. I can do any
of my training opportunities over the web for your company.
I am offering my most popular classes: Oracle SQL Tuning and Advanced
PL/SQL on a regular basis. I am also
offering Intro to SQL and Intro to PL/SQL. Let me
know your training needs and we can see if it is better for me to travel to your
site or to provide the training in this ‘no travel/no expense’ web
environment.
Attendees Receive:
- Study guide with presentations and relevant white
papers
- Zip file full of course example SQL and SQL*Plus
scripts
- Opportunity to ask the tough Oracle questions
- No Travel!
Course fees differ slightly per course...ask Dan for current
pricing.
Lectures are 3 to 4 hours each, Monday thru
Friday mornings (central USA time zone). Watch for offerings in the
London time zone.
You get the same quality lectures packed full of current
Oracle information and the ability to ask relevant questions.
The lectures will be in the mornings Monday thru Friday.
Watch for or ask for lectures in the London time zone as well. Morning
lectures allow the attendees to attend this valuable training as well as perform
their daily job tasks. The lecture
slides and voice will be via the web. A
dial-in phone number will be provided for those who need it.
The course is completely interactive.
Students can ask questions at any time.
Labs are generally at the end of the lecture and the instructor will be
available for Q & A and lab assistance after the lecture.
Lab solutions will always be reviewed.
The course guide will be provided electronically and students can print a
copy if they desire a hard copy. The
course guide contains all the lecture slides and instructor notes, the labs, lab
solutions, and relevant white papers.
All of Dan’s course offerings include hands-on lab exercises.
These web classes depend on you to have your own lab environment.
Dan provides:
Course
guides and the above lab environment assistance will be delivered prior to the
class via email. The course guides contain all the presentation slides,
instructors notes, and lab exercises with lab answers.
Please click here and
reserve a seat today.
Please click here
to review copyright/cancellation/refund policy.
These courses are available on a regular basis...see the
Main web page for the current schedule. Dan can do any of his course
offerings over the web. See Onsite
Training for all of Dan's course offerings.
Oracle SQL Performance Tuning Tips and
Techniques
The focus of this tuning course is to illustrate
coding techniques that insure a consistent response time between instances and
releases of the Oracle database. This
course works closely with performance tuning of actual SQL statements as well as
covering a variety of Oracle Server tuning topics.
There
are 2 options for this course:
This course is designed for the Oracle
professional with novice or no SQL tuning skills.
The focus of this tuning course is to cover
advanced SQL performance tuning topics for those Oracle professionals that
already have a SQL tuning background. This
course is perfect for DBA’s that need the additional background to solve the
more difficult problems.
These
courses can be combined for a 5-day web-based class.
Oracle SQL Performance Tuning
for Developers
This course is designed for the Oracle professional with
novice or no SQL tuning skills.
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/SQL Coding tips
- Oracle
Trace Facility - collecting SQL and interpreting using TKProf
- Profiling
PL/SQL
- PL/SQL
Coding Tips
Download
a course description
Advanced Oracle SQL Performance Tuning
Topics
The focus of this tuning course is to cover advanced SQL
performance tuning topics for those Oracle professionals that already have a SQL
tuning background. This course is
perfect for DBA’s that need the additional background to solve the more
difficult problems.
Topics covered includes:
- Oracle
Architecture from a SQL Performance point-of-view
- Review
of Reading Explain Plans/Understanding Explain Plans
- Review
of CBO Hints
- A
close look at Indexes – how they work and how they are selected and
advanced topics such as clustering factor and other reasons indexes may NOT
be selected
- Oracle
Trace Facility/Stats Pack/Wait Events
-
Tracing wait events back to the problem SQL
- Oracle
AWR and new tools such as SQL T are covered
- Profiling
PL/SQL and PL/SQL Coding Tips
- Oracle10g
Tablespace options that affect indexes
- Oracle
Data Block internals and fragmentation review
- Finding
various problems using the V$ Dictionary Tables with scripts
- SGA
Topics include:
o
Buffer Cache options
and sizing
o
Library Cache utilization/internals including cursor-sharing
topics
o
Oracle11g Result Cache
Download
a course description
