logo-mooc
search-iconsearch-icon
menu-whitemenu-blue
GRATIS
Inicio / Buscador / Ciencia de Datos / Análisis de Datos
EDUCBA vía Coursera
GRATIS

Oracle SQL Performance Tuning

  • money

    Cursos gratis (Auditar)

    question-mark
  • earth

    Inglés

  • folder

    NaN

  • certificate

    Guía de Registro en Coursera

    arrow
VER CURSO arrow
Acerca de este curso

  • Understanding Necessity of SQL Tuning
    • In this module, you will identify the demography of the tables. Different data types will be explored. Also, select statement execution will be elaborated.
  • Query Optimization Techniques
    • In this module, you will understand the different techniques offered by Oracle to know how any select statement gets executed internally. This module also describes the compilation process of any select statement.
  • Indexing Strategies
    • In this module, you will interpret how indexes contribute to enhancing the performance of a query, and the hazards of a full table scan are covered.
  • Performance Tuning Tools and Techniques
    • In this module, you will understand how hints can be useful to uplift the query execution process. A querying technique known as Inline view is covered. An Oracle object temporary table’s usage for solving real-life problems is depicted.