Learn Oracle Performance Tuning from Scratch
3.6 (24 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,626 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.6 (24 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,626 students enrolled
Created by Easy Learning
Last updated 8/2017
English
Current price: $10 Original price: $195 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
46 Lectures
03:30:52
+
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
About the Instructor
Easy Learning
3.6 Average rating
24 Reviews
1,626 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.