Oracle Database 11g: SQL Tuning Workshop
- Level
Oracle Database 11g: SQL Tuning Workshop
Starting dates and places
Focus on Training offers this product as a default in the following regions: N/A
Description
Audience:
- Support Engineer
- Developer
- Technical Consultant
- Data Warehouse Developer
- Application Developers
Learn to:
- Identify Poorly Performing SQL
- Understand the Query Optimizer
- Trace applications
- Monitor SQL execution in real time
- Interpret execution plans
Course Objectives:
- Identify problem SQL statements
- Modify a SQL statement to perform at its best
- Trace an application
- Understand how the Query Optimizer makes decisions about how to access data
- Interpret execution plans
- Use optimizer hints effectively
- Generate a load test
The SQL Tuning Workshop class covers investigative methods that reveal varying levels of detail about how the Oracle database executes a SQL statement. Students le…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
Audience:
- Support Engineer
- Developer
- Technical Consultant
- Data Warehouse Developer
- Application Developers
Learn to:
- Identify Poorly Performing SQL
- Understand the Query Optimizer
- Trace applications
- Monitor SQL execution in real time
- Interpret execution plans
Course Objectives:
- Identify problem SQL statements
- Modify a SQL statement to perform at its best
- Trace an application
- Understand how the Query Optimizer makes decisions about how to access data
- Interpret execution plans
- Use optimizer hints effectively
- Generate a load test
The SQL Tuning Workshop class covers investigative methods that reveal varying levels of detail about how the Oracle database executes a SQL statement. Students learn the different ways in which data can be accessed, which ones are most efficient under specific circumstances, and how to ensure that the best method is used. Topics on taking advantage of hints, bind variables, and different types of indexes are also covered.
This course counts towards the Hands-on course requirement for the Oracle Database 11g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet the Hands-on Requirement.
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.