Udemyallpt

Sql Tuning - Melhore a Performance em seu código !

Master SQL tuning! Optimize database performance with practical techniques. Improve query speed and efficiency. Learn to write faster SQL.

4.4(181)
839students
9h 48m
Certificate
Pedro F Carvalho
Pedro F CarvalhoAnalista de Sistemas / DBA / Desenvolvedor

Course Content

Sql Tuning - Melhore a Performance em seu código ! is an all-levels Udemy course taught by Pedro F Carvalho. It runs 9h 48m, is taught in Portuguese, and includes a certificate of completion. Learners rate it 4.4 out of 5 from 181 reviews, with 839 students enrolled. It is a paid course, last updated October 2020.

Maximize Oracle Database Performance with SQL Tuning

Is your Oracle database struggling with slow performance? Did you know that a staggering 70% of performance issues can be resolved through SQL code adjustments? As an Oracle Database Administrator (DBA), optimizing SQL is crucial for:

  • Reducing Data Retrieval Time: Minimize response and recovery times.
  • Minimizing Data Access Conflicts: Reduce contention for data.
  • Optimizing Data Transfer Rates: Improve data throughput.
  • Enhancing Database Load Capacity: Increase the database's ability to handle workload.

Poor SQL is the leading cause of low performance in Oracle systems.

This comprehensive guide provides the concepts and techniques to dramatically improve your Oracle database's speed and efficiency. We'll cover a wide range of SQL tuning strategies, including:

I. SQL Execution Analysis & Tuning Fundamentals

  • Understanding Execution Plans: Learn to analyze execution plans to identify bottlenecks.
  • The SELECT Statement Process: A deep dive into how Oracle executes SELECT statements.
  • Addressing Outdated Statistics: The importance of keeping database statistics up-to-date for optimal query performance.
  • Leveraging SQL Advisor: Utilize SQL Advisor to receive automated recommendations for query optimization.

II. Optimizing INSERT Statements

  • Insert Tuning Techniques: Strategies for optimizing different INSERT scenarios.
    • Insert with Append
    • Insert with CHAR and VARCHAR2
    • Insert with Constraints
    • Insert with Logging
    • Insert with Parallelism
    • Insert with Sequences
    • Insert with Tablespaces and Blocks
    • Insert with Tablespaces and Blocks & Indexes
    • Analyzing Wait Events during Insert
    • Bulk Collect for Efficient Inserts
    • Disabling Indexes for Insert Performance
    • Multiple Single Inserts
    • Loader for Large Data Imports

III. Optimizing UPDATE and DELETE Statements

  • Update and Delete Tuning Strategies: Techniques to improve the performance of data modification operations.
    • Update with Index Disabling
    • Update with Constraints
    • Update with Logging
    • Update with ROWID
    • Update with Parallelism
    • Update with PL/SQL
    • Delete and Truncate Optimization
  • Important Delete Recommendations

IV. Optimizing SELECT Statements

  • Comprehensive SELECT Tuning: A detailed guide to optimizing various SELECT statement patterns.
    • SELECT with CHAR and VARCHAR2
    • SELECT with LIKE
    • SELECT with Tablespaces and Blocks & Indexes
    • SELECT Selecting All Columns
    • SELECT with UNION and UNION ALL
    • SELECT with IN and NOT IN
    • Analyzing SQL Instructions
    • SELECT with Functions
    • SELECT with Functions & Indexes
    • SELECT with DBMS_Package_Rewrite
    • SELECT with DBMS_Package_Rewrite and Hints
    • SELECT with DBMS_Package_Rewrite Modifying
    • SELECT with CTAS (Create Table As Select)
    • SELECT with DB_FILE_MULTIBLOCK_READ_COUNT
    • Avoiding Implicit Conversions
    • SELECT with CASE Statements
    • SELECT – Avoid HAVING, Use WHERE
    • SELECT with SUBSTR and LIKE Functions
    • SELECT with TRUNC Functions
    • SELECT with Different WHERE Clauses
    • SELECT with Concatenation
    • SELECT with DISTINCT
    • SELECT Resources
    • SELECT with TRUNC_+1
    • SELECT – Avoid HAVING Use EXISTS
    • SELECT with Parallelism
    • SELECT with Parallelism for DDL
    • SELECT with ORDER BY
    • SELECT – Avoid Different Signs
    • SELECT – Avoid DISTINCT Use EXISTS
    • SELECT with ORDER BY for `
$ whoami — the devs behind tutorialsearch.io

Hire the developers behind TutorialSearch.io

We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.

5.0(7)
3h 2m
beginner

Azure SQL Database

by Landry Duailibe

5.0(7)
4h 16m
all

Criando Banco de Dados com MYSQL

by Caio Vinícius Malheiros Duarte

5.0(15)
3h 1m
beginner

Introdução ao SQL

by Luiz Fernando Estivalet

5.0(10)
4h 26m
beginner

MYSQL HANDS ON - TEC-IT

by Marcus Andrade

5.0(10)
2h 31m
beginner

Do Zero ao Mysql

by Guilherme Rosa de Moraes

5.0(11)
6h 33m
intermediate