Oracle Database 11g: SQL Tuning Workshop Release 2 Training Course (1Z0-117)
  • Email info@koenig-solutions.com
  • WhatsApp +91 81307 98752
  • Phone +1 877 226 2244

Oracle Database 11g: SQL Tuning Workshop Release 2

  • Overview

    Koenig offers a course on Oracle Database 11g: SQL Tuning Workshop Release 2. This course is useful for database developers, DBAs, and SQL developers in identifying and tuning inefficient SQL statement. This course covers investigative methods to reveal varying levels of detail about how the Oracle database executes the SQL statement.

    Course Objectives

    • Explore the Oracle Database Architecture
    • Comprehend Oracle Database Server Architecture: Overview
    • Connect to the Database Instance
    • Comprehend SQL Statement Parsing: Overview
    • Comprehend WSQL Access Advisor Session: Initial Options
    • Comprehend SQL Access Advisor: Workload Source
    • Comprehend SQL Access Advisor: Recommendation Options
    • Comprehend SQL Access Advisor: Schedule and Review
    • Configure Automatic SQL Tuning
    • Comprehend Automatic SQL Tuning: Result Summary
    • Comprehend Automatic SQL Tuning: Result Details
    • Comprehend Automatic SQL Tuning Result Details: Drilldown
    • Comprehend Automatic SQL Tuning Considerations
    • Maintain SQL Performance and SQL Plan Management: Overview
    • Comprehend SQL Plan Baseline: Architecture
    • Comprehend Important Baseline SQL Plan Attributes
    • Comprehend SQL Performance Analyzer and SQL Plan Baseline Scenario
    • Load a SQL Plan Baseline Automatically and Purging SQL Management Base Policy
    • Comprehend Enterprise Manager and SQL Plan Baselines

    Course Content / Exam(s)

    Schedule for Oracle Database 11g: SQL Tuning Workshop Release 2 Training Boot Camp Training
    Course Contents Exam# Regular Track (days)
    Oracle Database 11g: SQL Tuning Workshop Release 2 1Z0-117 3
    Total 3
    Prerequisites
    • Oracle Database: Introduction to SQL
    Recommended Courses and Certification:
  • Students Reviews
    Victoria Nyambo Koenig IT Training Student

    I came to Koenig Delhi for training on Oracle 11g DBA OCA & OCP . I benefited a lot from this training. My instructor was great and knowledgeable about the course. She always strived for student...

    Read MoreVictoria NyamboMalawi
    Nagarajan  Koenig IT Training Student

    I came to Koenig Delhi for training on Oracle 11g database Release 2 workshop 1 . It was my very first visit to New Delhi. Before landing here I was little bit worried about the place and...

    Read MoreNagarajan India
    Americo Antunes Koenig IT Training Student

    I came to Koenig Goa for training on Oracle Database 10g : Workshop Administration I. My first time in this institution was in May, 2014. I studied Oracle database Administration, Oracle forms,...

    Read MoreAmerico AntunesAngola
    Elijah Chirwa Koenig IT Training Student

    I came to Koenig Delhi for training on Oracle Database 11g: New Features for Oracle 9i DBA. My experience had been memorable and the training environment was ideal. The institution has well...

    Read MoreElijah ChirwaMalawi
    Comfort  Koenig IT Training Student

    My name is Comfort. I came at Koenig Solutions Delhi for the course of Oracle BI Discoverer Plus 11g: Analyze Relational and OLAP Data. About the Training: It was a great experience with well...

    Read MoreComfort Tanzania
    View All Testimonials
  • Schedule & Prices
    1
    2
    3


    4
     

    5
    Price includes Official Curriculum and Exam(s).
    For any Query or Custom Plan info@koenig-solutions.com +1 877 226 2244
  • Enquire Now
    * Required Fields