Video: .MP4, 1280x720 30 fps | Audio: AAC, 44.1 kHz, 2ch | Duration: 05:36:43

Genre: eLearning | Language: English + Subtitles | Size: 1.47 GB

Oracle SQL Performance Tuning from Scratch

What you'll learn

Will get complete knowledge of Oracle server Performance Tuning.

learn essential tool for various types of analysis to get key insights from data and to make key decisions

learn to play with data and to extract key information using various SQL Server functions and constructs.

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 targets the .NET or Java developer who is writing an application with a backend Oracle database.

Course include:

understanding how Oracle is processing your SQL statements through generating and interpreting execution plans, to designing and using indexes to speed up the data access of your application. Also included is 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. The use of bind variables, connection pooling, and some application best practices round out the topics covered in the course.

Once you complete this course, you will recognize the database terms better and will use the most appropriate one for the performance.

In this Course you will learn below topics:

Row-based vs. Column-based Indexes

Row-based Index Concepts

Choosing the Clustering Key

Clustered Index Internals

Nonclustered Index Internals

Who this course is for:

Recent College Grad

Job Seekers

Startup Folks