Faites confiance à votre formation en TI |

Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

Oracle Database 11g: SQL Tuning Workshop

Catégorie: Formation

Bases de données et grilles

Format: Formation en classe avec formateur

Autres formats:

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.

Learn to:

Identify Poorly Performing SQL
Understand the Query Optimizer
Trace applications
Monitor SQL execution in real time
Interpret execution plans

Oracle Certified Training Course

Oracle Training Savings

Compétences acquises

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

Qui peut en profiter

Application Developers
Data Warehouse Developer
Developer

Support Engineer
Technical Consultant

Ce cours est donnÃ© par des formateurs certifiÃ©s Oracle.

Oracle University a nommÃ© ExitCertified Partenaire de lâ€™annÃ©e 2011

Il y a une diffÃ©rence....dÃ©couvrez-la.

Code:	11g-TUNING-WRK
Format:	Formation en classe avec formateur

Durée:	3
Certifié par:	Oracle

Frais d’inscription (CAD): 2,475$

Oracle University Awards ExitCertified the North American Partner of the Year Award for 2011

Formation de Oracle (3027 cours)

Formation de Bases de données et grilles (209 cours)

Formation de 11g (118 cours)

Trier l'horaire par:

Toronto, ON		Sep.5 - Sep.7.2012

Toronto, ON		Oct.29 - Oct.31.2012

Toronto, ON		Dec.17 - Dec.19.2012

3 Dates Offered

Oracle Database 11g: SQL Tuning Workshop Contenu détaillé

Exploring the Oracle Database Architecture

Oracle Database Server Architecture: Overview
Oracle Database Memory Structures: Overview
Background Process Roles
Automatic Shared Memory Management
Automated SQL Execution Memory Management
Automatic Memory Management
Database Storage Architecture
Logical and Physical Database Structures

Introduction to SQL Tuning

Reasons for Inefficient SQL Performance
Performance Monitoring Solutions
Monitoring and Tuning Tools: Overview
EM Performance Pages for Reactive Tuning
CPU and Wait Time Tuning Dimensions
Scalability with Application Design, Implementation, and Configuration
Common Mistakes on Customer Systems
Proactive Tuning Methodology

Introduction to the Optimizer

Structured Query Language
SQL Statement Representation, Implementation Processing: Overview
SQL Statement Parsing: Overview
Why Do You Need an Optimizer?
Optimization During Hard Parse Operation
Cost-Based Optimizer
Controlling the Behavior of the Optimizer
Optimizer Features and Oracle Database Releases

Optimizer Operators

Row Source Operations
Main Structures and Access Paths
Full Table Scan
Indexes: Overview
Using Indexes: Considering Nullable Columns
Bitmap Indexes, Composite Indexes Invisible Index
Guidelines for Managing Indexes
Clusters

Interpreting Execution Plans

Execution Plan
Links Between Important Dynamic Performance Views
Automatic Workload Repository (AWR)
Generating SQL Reports from AWR Data
SQL Monitoring: Overview
Reading More Complex Execution Plans
Reviewing the Execution Plan
Looking Beyond Execution Plans

Case Study: Star Transformation

The Star Snowflake Schema Model
Execution Plan Without Star Transformation
Retrieving Fact Rows from One Dimension All Dimensions
Joining the Intermediate Result Set with Dimensions
Using Bitmap Join Indexes
Star Transformation
Bitmap Join Indexes

Optimizer Statistics

Optimizer Statistics Types of Optimizer Statistics
Multicolumn Statistics: Overview
Expression Statistics: Overview
Gathering System Statistics
Statistic Preferences: Overview
Optimizer Dynamic Sampling: Overview
Locking Statistics

Using Bind Variables

Cursor Sharing and Different Literal Values
Cursor Sharing and Bind Variables
Bind Variables in SQL*Plus Enterprise Manager
Cursor Sharing Enhancements
Adaptive Cursor Sharing: Overview
Interacting with Adaptive Cursor Sharing

Using Optimizer Hints

Optimizer Hints: Overview
Types of Hints
Specifying Hints
Rules for Hints
Hint Recommendations
Hint Categories
Optimization Goals and Approaches
Additional Hints

Application Tracing

End-to-End Application Tracing Challenge
Location for Diagnostic Traces
What Is a Service?
Use Services with Client Applications
Trace Your Own Session
SQL Trace File Contents
Formatting SQL Trace Files: Overview
Invoking the tkprof Utility

Automating SQL Tuning

Tuning SQL Statements Automatically
Application Tuning Challenges
SQL Tuning Advisor: Overview
Stale or Missing Object Statistics
SQL Statement Profiling
Plan Tuning Flow and SQL Profile Creation
Database Control and SQL Tuning Advisor
Implementing Recommendations

Your Name:

Your Email:

Sign up for newsletter:

Send Email To:

Course Link:

http://exitcertified.ca/oracle-training/11g-TUNING-WRK.html

Message:

Next


	Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source. Il y a une différence. Apprenez directement de la source.



Canada	United States
Formation à Montréal :: 514.876.1666 Formation à Ville de Québec :: 514.876.1666 Formation à Ottawa :: 613.232.3948 Formation à Toronto :: 416.487.3948 Formation à Vancouver :: 604.633.3948 Formation à Victoria :: 1.866.328.3948 Formation à Calgary :: 403.291.2855 Formation à Edmonton :: 780.441.3948 Formation à Regina :: 1.866.328.3948	Formation à Sacramento :: 916.669.3970 Formation à San Francisco :: 415.975.3948 Formation à San Jose :: 408.288.3948 Formation à Las Vegas :: 1.800.803.3948 Formation à Phoenix :: 602.889.9350
À travers le monde - 613.232.3948	Des questions? Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.

(c) 2012 ExitCertified Corp. Tous droits réservés.

Conditions d’utilisation et exclusions | Politique de confidentialité | Index des cours | Communiquez avec nous

ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :

Formation Sun	Formation Oracle	Formation Symantec	Formation IBM	Formation Red Hat :: Linux
Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris	Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle	Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec	DB2, OS/400, Formation zSeries, s/390, iSeries, AIX	SUSE, Formation RedHat

Formation MySQL	Formation Apple	Formation en gestion de projet
Base de données MySQL	Cours Apple, Formation Leopard	Formation du PMI