Yayasan Peneraju

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
        )

)

Yayasan Peneraju Financing Scheme

Course 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.

What are the 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

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

Course Curriculum

What are the 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

2024 TOP 20 COMPANY IT & TECHNICAL TRAINING BADGE-01

HRD Corp Training Provider 2

TOP 20 COMPANY IT & TECHNICAL TRAINING BADGE 2024

HRD Corp Training Provider 2

Trainocate: A Global Leader in Technology, Business, and People Development

In a world that never stands still, we help you move forward.

With over 30 years of experience, Trainocate has been empowering individuals and businesses to build the essential skills that drive growth and success. Whether it’s professionals advancing in their careers or organizations transforming their workforce, our training programmes deliver results.

Specializing in cloud computing, data & AI, cybersecurity, and digital leadership, our training is powered by industry-leading technology partners like AWS, Alibaba Cloud, Cisco, EC-Council, Fortinet, Google Cloud, IBM, ISACA, ISC2, Microsoft, NetApp, Nutanix, Oracle, Palo Alto, Splunk, Red Hat, Rocheston, Trend Micro, and VMware.

Trainocate Group operates in 24 countries blending global expertise with localized insights to train the next generation of tech professionals and business leaders.

Trainocate Malaysia, based in KL Eco City, is proud to be an HRD Corp Registered Training Provider and a Yayasan Peneraju ALTI, driving workforce development across Malaysia.

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