Learn Oracle Performance Tuning from Scratch
3.8 (35 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,668 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Oracle Performance Tuning from Scratch to your Wishlist.

Add to Wishlist

Learn Oracle Performance Tuning from Scratch

Learn Performance tuning in easy way
3.8 (35 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,668 students enrolled
Created by Easy Learning
Last updated 9/2017
English
Current price: $10 Original price: $195 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Will get complete knowledge of SQL Performance Tuning
  • Learn Execution Plans in Depth
  • Advanced Indexing Techniques
  • Application Indexing Practices
View Curriculum
Requirements
  • No previous technical knowledge required
  • Access to the Internet & a Machine(PC/Laptop) to solve exercises
  • An open mind and a willingness to learn something new and interesting
Description

Oracle is one of the most popular database systems in use today. Yet many developers do not understand how Oracle works or the principles behind developing high performance Oracle applications.

This Course includes below topics: 

  1. Understanding how Oracle is processing your SQL statements through generating and interpreting execution plans, 
  2. To designing and using indexes to speed up the data access of your application.
  3. How to use Oracle dynamic performance views to view real time information about Oracle performance, including which SQL statements are the most costly to run. 
  4. The use of bind variables, 
  5. Use of connection pooling,
  6. Application best practices round out the topics
Who is the target audience?
  • Recent College Grad
  • Job Seekers
  • Startup folks
Compare to Other Courses
Curriculum For This Course
81 Lectures
05:54:47
+
Introduction
5 Lectures 21:05



Performance Tuning Principles
03:54

Sample Database
04:58
+
Oracle Architecture and Performance Basics
11 Lectures 48:19

System Scalability
03:39

Oracle Architecture Overview
04:35

Buffer Cache
02:54

Shared Pool
02:11

Program Global Area
02:23

Oracle Architecture Wrap Up
01:56

Performance Metrics
10:01

Performance Tuning and Database Size
05:54

Building Effective Performance Test Databases
03:35

Performance Tuning Database use Scenarios
09:57
+
Connections and Connection Pools
7 Lectures 28:01

Connecting With and Without Connection Pools
02:46

Using a Connection Pool in .NET
03:25

Using a Connection Pool in Java
03:39

Connection Pool Best Practices
06:13

Blocking Connections
04:33

Summary
02:33
+
Bind Variables
6 Lectures 36:34

The Shared SQL Area
08:15

Contention and Latch Waits
10:06

Matching SQL Statements
06:12

Sample Application to Compare Approaches
06:15

Evaluation of Impacts of Bind Variables
04:05
+
Statement Level Performance Tuning
10 Lectures 34:20

Getting an execution Plan
02:56

What Does an Execution Plan Contain?
02:52

Reading an Execution Plan
04:24

Analyzing an Execution Plan
02:28

Autotrace Introduction
04:09

Autotrace Example in SQL Developer
04:23

Autotrace Example in SQL Plus
03:30

Data Size and Execution Plans
04:29

Summary
00:46
+
Execution Plans in Depth
7 Lectures 42:33

Table Access Operations
07:38

Demo: Table Access Operations
05:17

Index Lookup Operations
05:41

Demo: Index Lookup Operations
05:17

Join Operations
08:32

Tuning SQL Statements
09:02
+
Indexing Essentials
10 Lectures 49:25

B-Tree Indexes
06:00

Bitmap Indexes
06:42

Index Column Order Matters
04:51

Demo: Index Column Order
03:57

Index Skip Scan Operations
03:12

Index Selectivity
07:56

Selectivity for Composite Indexes
03:01

Demo: Index Selectivity
04:41

Determining Index Column Order
02:55
+
Advanced Indexing Techniques
10 Lectures 52:42

Covering Indexes
07:54

Function Based Indexes Introduction
07:42

Demo - Function Based Indexes: Case Insensitive Search
04:01

Selective Row Indexing With Function Based Indexes
06:12

Demo - Function Based Indexes: Selective Indexing
03:10

Index Compression
13:12

Invisible Indexes
03:27

Demo: Invisible Indexes
04:02

Summary
01:30
+
Application Indexing Practices
15 Lectures 41:48

Why Should I Index?
06:52

Indexing Costs and Overhead
04:38

Demo: Indexing Overhead
04:18

Similar Indexes
01:47

Monitoring Index Usage
04:25

Why isn't Oracle Using My Index?
00:59

Missing Leading Edge of Index
01:29

Index not Selective Enough
01:28

Using a Like Clause and a Leading Wildcard
02:37

Like Clauses and Index Selectivity
03:04

Function in the Where Clause
02:48

Data Type Conversion in the Where Clause
02:25

Outdated Database Statistics
02:47

Summary
01:09
About the Instructor
Easy Learning
3.8 Average rating
34 Reviews
1,668 Students
1 Course
Engineer

We are a team of four Tutors with 10+ years of rich experience in IT Industry(Google, Microsoft). We focus on Hadoop tutorials. Offering courses for every skill level.

We are here to help you boost your career with HIVE training – Just learn and enjoy. 

Should you have any questions, you are invited to open a discussion in the course or you can simply drop us a message.