Oracle SQL Tuning for Developers Workshop Eğitimi

Ön Kayıt ve Fiyat Bilgi Formu




Tarih ve lokasyonlar


Bu eğitimi özel sınıf olarak kendi kurumunuzda talep edebilirsiniz.
Lütfen bizimle iletişime geçin:


info@bilginc.com

+90 212 282 7700

Talep Formu

This Oracle SQL Tuning for Developers Workshop will help you explore Oracle SQL statement tuning. Learn how to write well-tuned SQL statements appropriate for the Oracle database.Learn To:Interpret execution plans and the different ways in which data can be accessed.Decipher, decide and then apply tuning to SQL code. Use various tuning techniques.Take advantage of bind variables, trace files and use the different types of indexes.Use different access paths for better optimization.Benefits to YouEnsure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.Understand Basic Tuning TechniquesExpert instructors will also teach you how to rewrite queries for better performance. Furthermore, you'll learn how to utilize SQL Tuning Advisor using SQL Developer 3.0.

Audiences

Data Warehouse Developer
Database Designers
Developer
PL/SQL Developer



Objectives

Choose an appropriate SQL tuning approach
Gather and interpret session statistics using the SQL trace facility
Identify the SQL statements that perform poorly
Use tuning techniques to tune inefficient SQL statements
Interpret Execution Plans
Describe the Oracle optimizer fundamentals
Manage SQL performance through changes



Topics

Introduction

Introduction to SQL Tuning

Using SQL Trace Facility and TKPROF

Understand Basic Tuning Techniques

Optomizer Fundamentals

Understanding Serial Execution Plans

Optimizer: Table and Index Access Paths

Optimizer: Join Operations

Other Optimizer Methods

Optimizer Statistics

Using Bind Variables

SQL Plan Management



Eğitim içeriğini PDF olarak indir

Diğer Oracle, Database Management & Development Eğitimleri