Latest Courses
The Theory of Deep Learning - Become a Data ScientistCheck course
Build a Complete Youtube Video App: Swift2.2 & 3 and XcodeCheck course
Shopify Mastery | Build a Shopify Store in Just 1 HourCheck course
Java Regular Expression FoundationCheck course
Agile Software Testing - Techniques and ToolsCheck course
Python Programming Skills Test With ExplanationCheck course
Beginners Eclipse Java IDE Training CourseCheck course
Xamarin Android - A Master Guide to App Development in C#Check course
Python for beginnersCheck course
Salesforce Integration With External SystemsCheck course
The Theory of Deep Learning - Become a Data ScientistCheck course
Build a Complete Youtube Video App: Swift2.2 & 3 and XcodeCheck course
Shopify Mastery | Build a Shopify Store in Just 1 HourCheck course
Java Regular Expression FoundationCheck course
Agile Software Testing - Techniques and ToolsCheck course
- 75% Oracle 12c SQL Tuning – the Ultimate Guide

Oracle 12c SQL Tuning – the Ultimate Guide

$169.99 $42.50Track price

Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare
9.0/10 (Our Score)
Product is rated as #13 in category SQL

Be one of the top professionals who know how to tune Oracle SQL. When you face a query that starts to be very slow with no apparent reason, you need knowledge and tools to troubleshoot the bottleneck and propose a proper solution; and that is what you will learn in this course.

The course does not only demonstrate the SQL tuning concepts, you will gain hands–on experience on implementing the those concepts as well.

The skills that you will learn in this course include the following:

Troubleshoot SQL statement performance issues

Understand internal optimizer operations

Techniques to influence the optimizer operations:

– SQL profiles,

– SQL plan baselines

– Directives

– SQL Hints

– Cursor Sharing

Use Oracle SQL performance advisory set, including:

– SQL Tuning Advisor

– SQL Access Advisor

– Optimizer Statistics Advisor

– SPM Evolve Advisor

– SQL Performance Analyzer

Use advanced techniques to improve Oracle SQL, like the following:

– histograms

– using the advanced techniques with the indexes

– using server result cache

– star transformation

Content and Overview
Information presented in this course provides the Oracle developers and DBAs the knowledge and experience to perform SQL Tuning activities on Oracle databases.

Through this extensive course, you ll learn all of SQL Tuning on Oracle SQL statements. After every concepts lecture, you will implement a hands–on practical exercise. To guide you on implementing the practices, the practice lectures are supported by video–based demonstrations and the downloadable guide documents.

Instructor Details

Ahmed Baraka has 20 years of extensive experience in the computer industry, with focus on Oracle database administration technologies used in complex and high available environments. Baraka's expertise is designing and maintaining database solutions for complex business needs using a wide selection of technologies, like Oracle RAC, ASM, Data Guard, GoldenGate, WebLogic, Database Appliance, and Enterprise Manager. He has worked with international firms in Australia and Abu Dhabi. His hobbies are soccer (football) and computer games.

Specification: Oracle 12c SQL Tuning – the Ultimate Guide

Duration 20 hours
Year 2020
Level Intermediate
Certificate Yes
Quizzes Yes

9 reviews for Oracle 12c SQL Tuning – the Ultimate Guide

5.0 out of 5
9
0
0
0
0
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Avatar

    A A

    Another good course from oracle expert. Topics are quite extensive and I need to do the course again to grasp all the topics

    Helpful(0) Unhelpful(0)You have already voted this
  2. Avatar

    Peter Odhiambo Abwoga

    Instructor is clear and detail. Enjoying this course

    Helpful(0) Unhelpful(0)You have already voted this
  3. Avatar

    Ebenezer Olubunmi Ogunlolu

    Ahmed never disappoints. Always detailed and on point. Thank you!

    Helpful(0) Unhelpful(0)You have already voted this
  4. Avatar

    Antonio Martone

    Ottimo in tutto

    Helpful(0) Unhelpful(0)You have already voted this
  5. Avatar

    Francis Ifon

    An absolutely exceptional course!

    Helpful(0) Unhelpful(0)You have already voted this
  6. Avatar

    Minesh Pandya

    Very good explanation of the topics with details. Thank you!

    Helpful(0) Unhelpful(0)You have already voted this
  7. Avatar

    Andrea Fornasier

    very very good. thanks a lot

    Helpful(0) Unhelpful(0)You have already voted this
  8. Avatar

    Ayman Haboubi

    So much content, so many things, so many exercises. Very much worth it. Nothing like it anywhere. I’ve been Oracle DBA for 6 years now. Thanks Ahmed

    Helpful(0) Unhelpful(0)You have already voted this
  9. Avatar

    Waheed

    Awesome Explanation by Ahmed.

    Helpful(0) Unhelpful(0)You have already voted this

    Add a review

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Oracle 12c SQL Tuning – the Ultimate Guide
    Oracle 12c SQL Tuning – the Ultimate Guide

    $169.99 $42.50

    Price tracking

    Register New Account
    Reset Password
    Compare items
    • Total (0)
    Compare