Oracle SQL Performance Tuning Masterclass
4.0 /5- Offered byUDEMY
Oracle SQL Performance Tuning Masterclass at UDEMY Overview
Duration | 21 hours |
Total fee | ₹599 |
Mode of learning | Online |
Official Website | Go to Website  |
Credential | Certificate |
Oracle SQL Performance Tuning Masterclass at UDEMY Highlights
- Earn a Certificate of completion from Udemy
- Get a 30 days money back guarantee on the course
- Learn from 85 articles and 8 downloadable resources
- Get access to 2 practice tests and assignments
Oracle SQL Performance Tuning Masterclass at UDEMY Course details
- For SQL developers, data analysts and data scientists
- 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
- This course will teach participants how to tune their SQL statements and database step by step for a perfect performance
- They will learn how to write fast, reliable, and secure queries
- Besides, learn the database architecture and will be able to optimize the database workloads
- In this course, students will recognize the database terms better and will use the most appropriate one for the performance
Oracle SQL Performance Tuning Masterclass at UDEMY Curriculum
SQL and performance Tuning course Introduction
UDEMY 101: How to Use Udemy? +Some Useful Tips (Do not Skip)
Welcome! +Course Document
Why to know the Oracle Database Architecture and how much to know?
Oracle Database Architecture Overview (Part 2)
Database Data Blocks in Detail
What is Shared Pool?
What is Buffer Cache?
What is a Bad SQL?
Effective Schema Design
Table Partitioning
How an SQL Statement is Processed?
Why do we need the Optimizer?
Optimizer Overview
Execution Plan and Explain Plan in Details
Generating Statistics (Part 1)
Generating Statistics (Part 2)
Generating Statistics (Part 3)
Generating Statistics (Code Samples)
Generating Execution Plan
Generating Execution Plan (Code Samples)
Types of Table and Index Access Paths
Table Access Full
Table Access Full (Code Samples)
Table Access by ROWID
Table Access by ROWID (Code Samples)
Index Unique Scan
Index Range Scan
Oracle SQL Performance Tuning Masterclass at UDEMY Entry Requirements
- Prerequisites : Basic PL/SQL knowledge
- Not mentioned
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?