Oracle University Expert Seminar

Date: 7-8 May 2012
Location: Zagreb
Language: English

About
Oracle University
Expert Seminars:

Oracle University Expert Seminars are exclusive events delivered by top Oracle experts with years of experience in working with Oracle products.

	Save the date
	Visit our Facebook page
	Follow us on Twitter
	Join our LinkedIN Group

About the trainer:
Jonathan Lewis

Jonathan Lewis is a freelance consultant who specializes in design, troubleshooting, and advanced training in best use of the Oracle database engine. He is a frequent speaker on the international circuit and he is also contributes to various Oracle-related magazines, and regularly publishes technical articles on his blog at jonathanlewis.wordpress.com.

“Jonathan doesn’t recite from the Oracle manuals; he explains how Oracle really works. Finally I understand latching and parsing”

“Great energy and outstanding presence of Jonathan.”

Register Now!

Please mention this code at the time of booking: E1045

Writing Optimal SQL / Database Troubleshooting & Tuning with Jonathan Lewis

About this seminar:

This seminar addresses two main areas: how to design a system so as to get data in and out efficiently and how to improve the performance of a production system by attacking inefficient SQL.

We will also focus on the benefits of viewing troubleshooting as being tightly coupled with design, this way we can do a better job of addressing the problems that emerge from a system that is in production.

Register Now!

Why you should attend this seminar:

You will learn how to improve the performance of a production system by attacking inefficient SQL
You will be able to see the SQL business function & make the SQL easy to read
You will find out how to design a system so that you can get data into and out of it efficiently
You will learn Key targets, indicators and mechanisms for producing a well-tuned system on day one and strategies for dealing with badly performing systems after go-live

The following topics
will be covered in
this seminar:

Addressing the problem, not the SQL
Making the SQL readable
Structural Optimization
A strategy for designing and debugging the SQL
Sundry strategies for awkward problems
Frequently Occurring Problems that affect performance
Quick Fixes for dealing with classic performance problems

What’s next?

More SQL courses:

ORACLE DATABASE 11G: ADVANCED PL/SQL

ORACLE DATABASE 11G: PERFORMANCE TUNING DBA RELEASE 2

For a full list of Oracle Seminars near you or on line click here

To book this seminar
contact us:

Please mention this code at the time of booking: E1045

Gordana Maglic

	+385 1 6323-231
	gordana.maglic@oracle.com
	oracle.com/hr/education

Hardware and Software, Engineered to Work Together

SEV100056762