You are viewing

OD-19c-STW: SQL Tuning Workshop

HRD Corp Claimable

HRD Corp SBL-Khas Claimable

Home » Oracle Education » Oracle Database » OD-19c-STW: SQL Tuning Workshop

OD-19c-STW: SQL Tuning Workshop

Fees:

RM5,000.00

Course duration

3 days

Accredited by

Array
(
    [ID] => 8145
    [id] => 8145
    [title] => oracle-training
    [filename] => oracle-training.svg
    [filesize] => 1631
    [url] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
    [link] => https://trainocate.com.my/home/oracle-training/
    [alt] => 
    [author] => 1
    [description] => 
     => 
    [name] => oracle-training
    [status] => inherit
    [uploaded_to] => 9
    [date] => 2021-08-22 18:16:25
    [modified] => 2021-08-22 18:16:25
    [menu_order] => 0
    [mime_type] => image/svg+xml
    [type] => image
    [subtype] => svg+xml
    [icon] => https://trainocate.com.my/wp-includes/images/media/default.png
    [width] => 180
    [height] => 22
    [sizes] => Array
        (
            [thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [thumbnail-width] => 150
            [thumbnail-height] => 150
            [medium] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [medium-width] => 300
            [medium-height] => 300
            [medium_large] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [medium_large-width] => 768
            [medium_large-height] => 1
            [large] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [large-width] => 1024
            [large-height] => 1024
            [1536x1536] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [1536x1536-width] => 180
            [1536x1536-height] => 22
            [2048x2048] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [2048x2048-width] => 180
            [2048x2048-height] => 22
            [blog-large] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [blog-large-width] => 180
            [blog-large-height] => 22
            [blog-medium] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [blog-medium-width] => 180
            [blog-medium-height] => 22
            [recent-posts] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [recent-posts-width] => 180
            [recent-posts-height] => 22
            [recent-works-thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [recent-works-thumbnail-width] => 66
            [recent-works-thumbnail-height] => 8
            [fusion-200] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [fusion-200-width] => 180
            [fusion-200-height] => 22
            [fusion-400] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [fusion-400-width] => 180
            [fusion-400-height] => 22
            [fusion-600] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [fusion-600-width] => 180
            [fusion-600-height] => 22
            [fusion-800] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [fusion-800-width] => 180
            [fusion-800-height] => 22
            [fusion-1200] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [fusion-1200-width] => 180
            [fusion-1200-height] => 22
            [portfolio-full] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [portfolio-full-width] => 180
            [portfolio-full-height] => 22
            [portfolio-one] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [portfolio-one-width] => 180
            [portfolio-one-height] => 22
            [portfolio-two] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [portfolio-two-width] => 180
            [portfolio-two-height] => 22
            [portfolio-three] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [portfolio-three-width] => 180
            [portfolio-three-height] => 22
            [portfolio-five] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [portfolio-five-width] => 177
            [portfolio-five-height] => 22
            [woocommerce_thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [woocommerce_thumbnail-width] => 180
            [woocommerce_thumbnail-height] => 22
            [woocommerce_single] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [woocommerce_single-width] => 180
            [woocommerce_single-height] => 22
            [woocommerce_gallery_thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [woocommerce_gallery_thumbnail-width] => 180
            [woocommerce_gallery_thumbnail-height] => 22
        )

)

Home » Oracle Education » Oracle Database » OD-19c-STW: SQL Tuning Workshop

OD-19c-STW: SQL Tuning Workshop

Course duration:

3 days

Fees:

RM5,000.00

Accredited by:

Array
(
    [ID] => 8145
    [id] => 8145
    [title] => oracle-training
    [filename] => oracle-training.svg
    [filesize] => 1631
    [url] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
    [link] => https://trainocate.com.my/home/oracle-training/
    [alt] => 
    [author] => 1
    [description] => 
     => 
    [name] => oracle-training
    [status] => inherit
    [uploaded_to] => 9
    [date] => 2021-08-22 18:16:25
    [modified] => 2021-08-22 18:16:25
    [menu_order] => 0
    [mime_type] => image/svg+xml
    [type] => image
    [subtype] => svg+xml
    [icon] => https://trainocate.com.my/wp-includes/images/media/default.png
    [width] => 180
    [height] => 22
    [sizes] => Array
        (
            [thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [thumbnail-width] => 150
            [thumbnail-height] => 150
            [medium] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [medium-width] => 300
            [medium-height] => 300
            [medium_large] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [medium_large-width] => 768
            [medium_large-height] => 1
            [large] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [large-width] => 1024
            [large-height] => 1024
            [1536x1536] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [1536x1536-width] => 180
            [1536x1536-height] => 22
            [2048x2048] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [2048x2048-width] => 180
            [2048x2048-height] => 22
            [blog-large] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [blog-large-width] => 180
            [blog-large-height] => 22
            [blog-medium] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [blog-medium-width] => 180
            [blog-medium-height] => 22
            [recent-posts] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [recent-posts-width] => 180
            [recent-posts-height] => 22
            [recent-works-thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [recent-works-thumbnail-width] => 66
            [recent-works-thumbnail-height] => 8
            [fusion-200] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [fusion-200-width] => 180
            [fusion-200-height] => 22
            [fusion-400] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [fusion-400-width] => 180
            [fusion-400-height] => 22
            [fusion-600] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [fusion-600-width] => 180
            [fusion-600-height] => 22
            [fusion-800] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [fusion-800-width] => 180
            [fusion-800-height] => 22
            [fusion-1200] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [fusion-1200-width] => 180
            [fusion-1200-height] => 22
            [portfolio-full] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [portfolio-full-width] => 180
            [portfolio-full-height] => 22
            [portfolio-one] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [portfolio-one-width] => 180
            [portfolio-one-height] => 22
            [portfolio-two] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [portfolio-two-width] => 180
            [portfolio-two-height] => 22
            [portfolio-three] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [portfolio-three-width] => 180
            [portfolio-three-height] => 22
            [portfolio-five] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [portfolio-five-width] => 177
            [portfolio-five-height] => 22
            [woocommerce_thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [woocommerce_thumbnail-width] => 180
            [woocommerce_thumbnail-height] => 22
            [woocommerce_single] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [woocommerce_single-width] => 180
            [woocommerce_single-height] => 22
            [woocommerce_gallery_thumbnail] => https://trainocate.com.my/wp-content/uploads/2021/08/oracle-training.svg
            [woocommerce_gallery_thumbnail-width] => 180
            [woocommerce_gallery_thumbnail-height] => 22
        )

)

HRD Corp Claimable

HRD Corp SBL-Khas Claimable

Overview

Oracle SOL Tuning for Developers Workshop course helps you learn how plans are tuned execution of Oracle SOL statements. You will learn how to write well-tuned SOL statements out of the box that are perfectly suited to Oracle DBMS.

Skills Covered

Upon completion of the course, students will be able to:

Interpret query execution plans and different ways of accessing data.
Decrypt. make optimization decisions. then apply settings in SOL code.
Use a variety of customization methods. Take advantage of bind variables. trace files. and use different types of indexes.
Use different access data paths for better code optimization.

Who Should Attend

This course intended for database developers, DBAs, and SQL developers.

Course Curriculum

Prerequisites

Oracle Database 19c: SOL Workshop course or equivalent knowledge

Download Syllabus

Course Modules

Expand all Collapse all

Module 1: Course Introduction

Module 2: Introduction to SOL Tuning

Module 3: Using Application Tracing Tools

Module 4: Optimizer Fundamentas

Module 5: Generating and Displaying Execution Plans

Module 6: Interpreting Execution Plans and Enhancements

Module 7: Optimizer: Table and Index Access Paths

Module 8: Optimizer: Join Operators

Module 9: Other Optimizer Operators

Module 10: Introduction to Optimizer Statistics Concepts

Module 11: Using Bind Variables

Module 12: SOL Plan Management

Module 13: Workshops

Request More Information

Training Options

Intake: Available Upon Request

Duration: 3 Days

Guaranteed: TBC

Modality: VILT

Price:

RM5,000.00Enroll Now

Exam: No associated exam

Intake: Available Upon Request

Duration: 3 Days

Guaranteed: TBC

Modality: ILT

Price:

RM5,000.00Enroll Now

Exam: No associated exam

Exam & Certification

Training & Certification Guide

Frequently Asked Questions

Company

Customer Service

Principals

2023 Top 20 IT Training and Technical Company

HRD Corp Training Provider 2

2023 Top 20 IT Training and Technical Company

HRD Corp Training Provider 2

No. 1 IT Training Center & Provider in Malaysia

Trainocate is the new and exciting development of the 25-year old establishment – Global Knowledge. The name Trainocate is inspired from the term “Training Advocate” which resonates the feeling of continuous learning, something that each member of the Trainocate team carries with them. We are in the business of empowering work forces in the Asia-Pacific region by maximizing their capabilities through training and certification. This not only helps with improving work performance but also, explores untapped potential within each individual.

Located in KL Eco City and just next to Mid Valley City, Trainocate Malaysia is a HRD Corp Registered Training Provider and Authorized Training Partner for big tech companies such as AWS, Alibaba Cloud, Cisco, Dell EMC, Fortinet, Google Cloud, IBM, Microsoft, NetApp, Nutanix, Oracle, Splunk, Red Hat, Trend Micro, and VMware. We also provide a broad range of human capital development and people skills training to individuals and organizations under American Management Association (AMA).

Years of experience in IT Training Provider Industry equates to bettering ourselves to ensure we deliver only the best training programs to our loyal clients, both in technology and people skills.

© Copyright Trainocate 2024. All rights reserved. IT Training Provider Malaysia