Pular para o conteúdo

[email protected]ftsell.com.br
Contato

Curitiba 41 3204.1999 | Brasil 4007.2186
Tel

Whatsapp 41 98754.3534
Whatsapp
SoftSell
MENUMENU
  • HOME
  • TREINAMENTOS E CERTIFICAÇÕES
    • CALENDÁRIO DE TREINAMENTOS
    • Certificações em TI
    • Check Point
      • CCSA – Check Point Certified Security Administrator
      • CCSE – Check Point Security Engineering
      • Check Point CCSA+CCSE – Bundle R.80
    • Cisco
      • Cisco Digital Network Architecture Implementation Essentials (DNAIE) v2.0
      • Cisco SD-WAN Operation and Deployment (ENSDW) v1.0
      • Designing Cisco Enterprise Networks (ENSLD) v1.0
      • Implementing and Administering Cisco Solutions (CCNA) v1.0
      • Implementing and Configuring Cisco Identity Services Engine (SISE) v3.0
      • Implementing and Operating Cisco Enterprise Network Core Technologies (ENCOR) v1.0
      • Implementing and Operating Cisco Security Core Technologies (SCOR) v1.0
      • Implementing Cisco Application Centric Infrastructure (DCACI) v1.0
      • Implementing Cisco Catalyst 9000 Switches (ENC9K) v1.0
      • Implementing Cisco Enterprise Advanced Routing and Services (ENARSI) v1.0
      • Implementando Cisco Enterprise Wireless Networks (ENWLSI) v1.1
      • Implementing Secure Solutions with Virtual Private Networks (SVPN) v1.0
      • Securing Email with Cisco Email Security Appliance (SESA) v3.1
      • Securing the Web with Cisco Web Security Appliance (SWSA) v3.0
      • Understanding Cisco Wireless Foundations (WLFNDU) v1.0
    • CompTIA
      • Linux+ CompTIA
      • Security+ CompTIA
      • Webinar – Cibersegurança e o Mercado de Trabalho
    • EC-Council
      • CASE JAVA Training & Certification
      • CEH v11
      • CHFI
      • CND v2
      • CSA - Certified SOC Analyst
      • CSCU Certified Secure Computer User
      • ECIH
      • Webinar CEH – Certified Ethical Hacker v10
    • Extreme Networking
      • Campus EXOS Switching and Routing
    • F5
      • Configuring F5 Advanced WAF (previously licensed as ASM)
      • F5 ADM BIG IP – Administering BIG-IP
      • F5 BIG-IP DNS (Antigo GTM)
      • F5 Configuring BIG-IP (AFM): Advanced Firewall Manager
      • F5 Configuring BIG-IP (APM): Access Policy Manager
      • F5 LTM – Configuring BIG-IP Local Traffic Manager
      • F5 Troubleshooting BIG-IP
    • Fortinet
      • FortiGate (I) Security v6
      • FortiGate (II) Infrastructure v6
      • NSE 5 – FortiAnalyzer
      • NSE 5 – FortiManager
      • NSE 7 - Enterprise Firewall
    • Furukawa
      • Data Cabling System & MCT Fluke Networks
      • FCP Fibras Ópticas
      • FCP Fibras Ópticas | Módulo Emendas Ópticas
      • FCP Fibras Ópticas | Módulo Medição em Redes Ópticas
      • FCP Fibras Ópticas | Módulo Redes Externas
      • FCP Master
      • FCP Update
      • FCP Professional
      • FTTx Conceitos e Projetos
      • FTTx Equipamentos | Módulo 1 Networking
      • Webinar
    • Infoblox
      • CDAT – Core DDI Advanced Troubleshooting 8.x
    • Java
      • Java Performance Tuning
      • Java SE 8 Fundamentals
      • Java SE 8 New Features
      • Java SE 8 Programming
      • OO Analysis & Design Using UML
    • Microsoft
      • 10990CC Analyzing Data With SQL Server Reporting Services
      • 20483 Programação em C#
      • 207031BC Administering System Center Configuration Manager
      • 20740CC Installation, Storage and Compute with Windows Server 2016
      • 20741BC Networking with Windows Server 2016
      • 20742BC Identity with Windows Server 2016
      • 20761 Querying Data with Transact-SQL
      • 20762C Developing SQL Databases
      • 20764 Administering a SQL Database Infrastructure
    • MySQL
      • MySQL Cluster
      • MySQL for Developers
      • MySQL for Administrators
      • MySQL for Beginners
      • MySQL Fundamentals
      • MySQL Performance Tuning
    • Oracle
      • Database 12c ASM Administration
      • Database 12c Clusterware Administration
      • Database 12c Data Guard Administration
      • Database 12c Novos Recursos Para Administradores
      • Database 12c Performance Management and Tuning
      • Database 12c RAC Administration
      • Database 12c R2 Administration Workshop
      • Database 12c R2 Backup & Recovery
      • Database 12c R2 Install and Upgrade Workshop
      • Database 12c R2 New Features for Adm 2
      • Database 18c Managing Multitenant Architecture
      • Database Coud for Oracle DBAs
      • Database Program with PL/SQL Ed 2
      • Database SQL and PL/SQL New Features Ed 1
      • Database SQL & PL/SQL Fundamentals
      • Database SQL Workshop II
      • Data Integrator 12c Integration and Administration Ed 3 NEW
      • Exadata Database Machine 12c Administration Workshop
      • Introduction to SQL
      • SQL Tuning for Developers
      • WebLogic Server 12c Adm 1
      • WebLogic Server 12c Adm 2
      • WebLogic Server 12c JMS Adm
      • WebLogic Server 12c Performance Tuning
      • WebLogic Server 12c Troubleshooting
    • Palo Alto Networks
      • PAN 210 – Firewall 9.1 Essentials: Configuration and Management
      • PAN 214 – Firewall 8.1: Optimizing Firewall Threat Prevention
      • PAN 220 – Palo Alto Panorama: Managing Firewalls at Scale v9
      • PAN 318 – Prisma Access Sase Security: Design and Operation
      • PAN 330 – Firewall: Troubleshooting v9
    • Salesforce
      • Salesforce ADX 201
      • Salesforce ADX 251
      • Salesforce ADX 261
      • Salesforce DEX 450
      • Salesforce EEB101 + JB101
    • SoftSell
      • Gerenciamento Win Server 2012
      • Gestão de Projetos
      • Gestão de Projetos na era da Indústria 4.0
      • Linux Essentials
      • Pentest for Red Teams - Buffer Overflow Windows e Linux
      • Pentest for Red Teams – Web Application
      • Redes e Novas Tecnologias
    • SonicWall
      • SonicWall Network Security Administrator (SNSA)
      • SonicWall Network Security Professional (SNSP)
    • Veeam
      • Veeam Certified Engineer V9
    • VMWare
      • VMware vSphere: Install, Configure, Manage v6.7 – VMware
  • SOLUÇÕES DE TI
    • Fábrica de Softwares e BI
    • Produtos e Equipamentos de TI
    • Serviços de TI
      • Computação em Nuvem
      • Gerenciamento de TI
      • IBM Cloud
      • Suporte Infraestrutura
  • INSTITUCIONAL
    • Sobre a SoftSell
  • BLOG
Oracle SQL Tuning for Developers Workshop
Publicada em 11 de abril de 2018 na categoria
Slider
logo_oracle

SQL Tuning for Developers Workshop

Sobre este Treinamento

Choose an appropriate SQL tuning approach Gather and interpret session statistics using the SQL trace facility Identify the SQL statements that perform poorly Use tuning techniques to tune inefficient SQL statements Interpret Execution Plans Describe the Oracle optimizer fundamentals Manage SQL performance through changes.

What you will learn

This Oracle SQL Tuning for Developers Workshop will help you explore Oracle SQL statement tuning. Learn how to write well-tuned SQL statements appropriate for the Oracle database.

Learn To:

  • Interpret execution plans and the different ways in which data can be accessed
  • Decipher, decide and then apply tuning to SQL code. Use various tuning techniques
  • Take advantage of bind variables, trace files and use the different types of indexes
  • Use different access paths for better optimization

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Understand Basic Tuning Techniques

Expert instructors will also teach you how to rewrite queries for better performance. Furthermore, you’ll learn how to utilize SQL Tuning Advisor using SQL Developer 3.0.

Carga Horária: 3 dias

GARANTIR MINHA VAGA!

Pré-requisito

Required Prerequisites
Oracle Database: Introduction to SQL

Suggested Prerequisites
Oracle Database: Conceptos Fundamentales de PL/SQL
Oracle Database: Fundamentos de PL/SQL

Data Warehouse Developer
Database Designers
Developer
PL/SQL Developer

Público-alvo

Conteúdo

Introduction to SQL Tuning
Find a workaround to enhance performance
Analyze a poorly written SQL statement
Create a function based index
Redesign a simple table
Rewrite the SQL statement

Using SQL Trace Facility and TKPROF
Explore a trace file to understand the optimizer’s decisions

Understand Basic Tuning Techniques
Rewrite queries for better performance
Rewrite applications for better performance
Utilize SQL Tuning Advisor using SQL Developer 3.0

Optimizer Fundamentals
Explore a trace file to understand the optimizer’s decisions

Understanding Serial Execution Plans
Use different techniques to extract execution plans
Use SQL monitoring

Optimizer: Table and Index Access Paths
Learn about using different access paths for better optimization

Optimizer: Join Operations
Use different access paths for better optimization
Examine and use the result cache

Other Optimizer Methods
Use different access paths for better optimization
Examine and use the result cache

Optimizer Statistics
Analyze and use system statistics
Use automatic statistics gathering

Using Bind Variables
Use adaptive cursor sharing and bind peeking
Use the CURSOR_SHARING initialization parameter

SQL Plan Management
Use SQL Plan Management

Acesse o Calendário de Treinamentos

Atendimento Personalizado

Para saber mais sobre os treinamentos, certificações e soluções de TI da SoftSell, entre em contato com a gente.
É só escolher o seu canal preferido e aguardar breve resposta em horário comercial:

Curitiba: 41 3204.1999
Demais localidades: 4007.2186
WhatsApp : 41 98754.3534
Email: [email protected]
 

ENDEREÇO
Rua Emiliano Perneta, 680 – 9º Andar
Centro – Curitiba – Paraná – 80420-080

    Relacionado

    TREINAMENTOS E CERTIFICAÇÕES

    • Treinamentos e Certificações
    • Certificações em TI
    • Inscrições

    INFRAESTRUTURA DE TI

    • Software e BI
    • Serviços
    • Produtos e Equipamentos

    SOFTSELL

    • Sobre a SoftSell
    • Trabalhe Conosco

    ATENDIMENTO

    Telefone SoftSell Curitiba 41 3204.1999

    Telefone SoftSell Demais localidades 4007.2186

    Whatssap SoftSell WhatsApp 41 98754.3534

    Contato SoftSell [email protected]

     


    Rua Emiliano Perneta, 680 – 9º Andar – Centro – Curitiba – Paraná – 80420-080

    Siga-nos

    • Ver perfil de softsell no Facebook
    • Ver perfil de softsell.treinamentos no Instagram
    • LinkedIn

    SoftSell – Todos os Direitos Reservados | Desenvolvido por Pontodesign

    Pontodesign
    © 2021 SoftSell • Distribuído por GeneratePress
    Voltar ao topo