• 21-Feb-2020: NEW SESSION "ORACLE 12C DBA" AT CAVALRY GROUND LAHORE
  • 21-Feb-2020: New Session "AWS Cloud Practitioner" at Cavalry Ground Lahore (6PM)
  • 14-Mar-2020: FREE Seminar "Essential Skills for Accountant 2020" at Cavalry Ground Lahore
  • 29-Feb-2020: FREE Seminar "Essential Skils for Accountant 2020" at Islamabad Centre (4PM)
  • Create Perfect Posts for Social Media with Adobe Illustrator and Adobe Photoshop

Oracle Database 11g SQL Tuning (Oracle Certified Expert-OCE)

The Oracle Database 11g SQL Tuning certification is designed for Developer, DBAs and SQL developers who are proficient at tuning efficient SQL statements. This certification exam covers topics on core elements such as: identifying and tuning inefficient SQL statements, using automatic SQL tuning, managing optimizer statistics on database objects, implementing partitioning and analyzing queries. Up-to-date training and field experience are recommended.

Successfully completing the requirements of this certification track earns the designation of Oracle Certified Expert, Oracle Database 11g Release 2 SQL Tuning.

Course Objectives

Oracle Database 11g: SQL Tuning Workshop

  •   Identify poorly performing SQL
  •   Trace an application through its different levels of the application architecture
  •   Understand how the Query Optimizer makes decisions about how to access data
  •   Define how optimizer statistics affect the performance of SQL
  •   List the possible methods of accessing data, including different join methods
  •   Modify a SQL statement to perform at its best
  •  

Oracle Database 11g: Administer a Data Warehouse

  •   Use parallel operations to reduce response time for data-intensive operations
  •   Extract, Transform, and Load data in the data warehouse
  •   Create, use, and refresh materialized views to improve the data warehouse performance
  •   Use Query rewrite to quickly answer business queries using materialized views
  •   Use SQL Access Advisor and PL/SQL procedures to tune materialized views for fast refresh and query rewrite
  •   Use the features of compression and resumable sessions
  •   Review the basic Oracle data warehousing concepts
  •  

Parallel Processing in Oracle Database 11g Seminar

  •   Use Database Resource Manager to complement the control of parallel processing usage
  •   Define why and when to use parallel processing
  •   List the SQL statements and data loading utilities that can benefit from parallel processing
  •   Explain the basic concepts and theory associated with parallel execution
  •   Use a variety of parallel execution features with different SQL statements
  •   Read and evaluate execution plans for parallelized statements
  •   Use new Oracle 11g, Release 2 parallel processing features including Auto DOP, statement-queuing,
  •   and in-memory parallel execution
  •   Examine specific configurations such as RAC database to and Database Machine with parallel execution
  •   Troubleshoot parallel processing issues such as no parallel execution, unexpected DOP, or performance decrease
  •   Trace parallel execution to provide information to Oracle customer support
Course Content Exam(s)

  

Exame Name Exame Number Product Version Exam Cost

Oracle Database 11g Release 2: SQL Tuning

1Z0-117

SQL and PL/SQL

$ 150

 

 

1
1
 
1
1
Fly-me-a-Trainer is a one of its kind service by Oranet. As per client requirements, Oranet sends expert trainers to corporate locations. With our trainer at your venue, you just need a conference room. The participants will be provided remote access to server at our Data Center.
For any Query or Custom Plan info@oranet.com.pk Lahore: 042-36619618-9 | Islamabad: 051-2806466
Order Summary
asdfsdsdf
Course Oracle Database 11g SQL Tuning (Oracle Certified Expert-OCE)
Training Mode
Training Type
Training Location
Accomodation
Date
Total




Order Summary
asdfsdsdf
Course Oracle Database 11g SQL Tuning (Oracle Certified Expert-OCE)
Training Mode
Training Type
Training Location
Accomodation
Training Days
Date
Total