Oracle SQL Performance Tuning Masterclass (2023)
Office Productivity / Oracle

Oracle SQL Performance Tuning Masterclass (2023)

Become an Expert on Oracle SQL Tuning

0 Students enrolled
Expert
English
This course includes:
  • 25h 39m
  • 234 Lectures
  • 350 Downloadable assets
  • Full lifetime access
  • Access on Mobile and TV
  • Certificate on completion

Overview

What will students learn in your course?
  • Learn How to Solve Critical Performance Problems with Step by Step Approach!
  • Learn Advanced Indexing Techniques for Ultimate Database Performance!
  • Learn How to Use Various Performance Tuning Tools for In-Depth Assistance!
  • Maximize the Query Performance by Using Advanced Tuning Tecniques!
  • Learn Oracle Database Architecture by "Tuning" aspects.
  • Identify and Optimize the Performance of poorly performing (bad) SQLs.
  • Understand SQL Tuning Terminologies
  • Learn How to Create "Better" Queries
  • Learn How to Prioritize your SQL Tuning Efforts.
  • Learn the Details of How an SQL Code is Interpreted
  • Learn Useful Hints to improve Performance of your Queries
  • Learn & Improve How to Use Oracle Optimizer and Execution Plans Well
  • Various Tips and Tricks to make the Oracle SQL queries run faster.
  • Oracle Performance Tuning on both Oracle11g and Oracle12c Environment.
  • Learn Efficient Schema Design
  • Lifetime Support from the Authors.
  • Weekly Quizzes & Assesment Tests
  • Working materials and always up to date!
What are the requirements or prerequisites for taking your course?
  • SQL Knowledge
  • Basic PL/SQL Knowledge
Who is the course for?
  • SQL Developers
  • Data Analysts
  • Data Scientists
  • PL/SQL Developers
  • Oracle DBAs
  • Oracle BI Developers
Description

Course content

  • 14 Sections
  • 234 Lectures
  • 25h 39m Total length
Section 1
SQL & Perfomance Tuning Course Introduction

SQL & Perfomance Tuning Course Introduction

Time 11m
Lectures 3
Yocoach 101: How to Use Yocoach? +Some Useful Tips (Do not Skip)
0:03:41
Welcome Gift! + Course Document
0:03:41
Section 2
What is SQL (Performance) Tuning and Why We Need?

What is SQL (Performance) Tuning and Why We Need?

Time 15m
Lectures 2
Section 3
Oracle Database Architecture

Oracle Database Architecture

Time 1h 51m
Lectures 15
Section 4
SQL Tuning Basics

SQL Tuning Basics

Time 1h 37m
Lectures 15
Section 5
Execution Plans & Statistics

Execution Plans & Statistics

Time 1h 43m
Lectures 17
Section 6
Table & Index Access Paths

Table & Index Access Paths

Time 1h 58m
Lectures 18
Section 7
Optimizer Hints

Optimizer Hints

Time 31m
Lectures 5
Section 8
Join Operations

Join Operations

Time 2h 03m
Lectures 19
Section 9
Other Optimizer Operators

Other Optimizer Operators

Time 2h 40m
Lectures 25
Section 10
SQL Tuning Techniques

SQL Tuning Techniques

Time 6h 19m
Lectures 59
Section 11
Tuning with ADVANCED Indexing Techniques

Tuning with ADVANCED Indexing Techniques

Time 3h 15m
Lectures 29
Section 12
Advanced SQL Tuning Techniques

Advanced SQL Tuning Techniques

Time 1h 37m
Lectures 14
Section 13
Appendix: Software Installations

Appendix: Software Installations

Time 1h 25m
Lectures 12
Section 14
Bonus

Bonus

Time 09m
Lectures 1

About tutor

Brandt Jacobs
3.00 (1 Reviews)
Courses 2
Biography

Hello Students! I'm Brandt Jacobs and I belong to Austria. I served as an educational writer for several newspapers across Midwest and East Coast sparked my interest in teaching. I assist students in honing their writing talents and broadening their knowledge of Accounts, Arts, Physics, and Chemistry. concentrating on the problem areas and helping students in communicating more effectively

Ratings & reviews

0.00
0 Reviews
5
4
3
2
1

More courses from Brandt

Certificate of completion