Oracle Performance Tuning for Developers

This course introduces developers to the fundamental principles of performance tuning when using Oracle as their backend database.
Course info
Rating
(215)
Level
Intermediate
Updated
June 24, 2014
Duration
7h 1m
Table of contents
Description
Course info
Rating
(215)
Level
Intermediate
Updated
June 24, 2014
Duration
7h 1m
Description

Oracle is one of the most popular database systems in use today. Yet many developers do not understand how Oracle works or the principles behind developing high performance Oracle applications. This course targets the .NET or Java developer who is writing an application with a backend Oracle database. Topics include: understanding how Oracle is processing your SQL statements through generating and interpreting execution plans, to designing and using indexes to speed up the data access of your application. Also included is how to use Oracle dynamic performance views to view real time information about Oracle performance, including which SQL statements are the most costly to run. The use of bind variables, connection pooling, and some application best practices round out the topics covered in the course.

About the author
About the author

David Berry is a software engineer with over 15 years of experience developing applications in languages such as Java and C#. Throughout his career, he has worked extensively with enterprise database systems including Oracle and SQL Server.

More from the author
More courses by David Berry