Oracle SQL Performance Tuning from Scratch

Oracle是当今使用最广泛的数据库系统之一。但是，许多开发人员不了解Oracle的工作原理或开发高性能Oracle应用程序背后的原理。本课程针对使用后端Oracle数据库编写应用程序的.NET或Java开发人员。
课程包括：
通过生成和解释执行计划，设计和使用索引来加快对应用程序的数据访问，了解Oracle如何处理SQL语句。还包括如何使用Oracle动态性能视图查看有关Oracle性能的实时信息，包括运行成本最高的SQL语句。使用绑定变量，连接池和一些应用程序最佳实践完善了本课程涵盖的主题。
完成本课程后，您将更好地识别数据库术语，并将使用最合适的术语来提高性能。
Video: .MP4, 1280×720 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