Praxisworkshop Oracle Datenbank 19c SQL Tuning (ODBTUN19)

 

Course Overview

In diesem SQL Tuning Workshop für Entwickler lernen Sie verschiedene SQL-Tuningansätze und Techniken zur Optimierung Ihres SQL Codes innerhalb von Oracle 19c kennen.

Sie lernen SQL-Anweisungen mit geringer Performance zu identifizieren, um diese im Anschluss mit grundlegenden Tuningverfahren zu optimieren.

Dieser Kurs umfasst praktische Übungen zu den einzelnen Lektionen.

Who should attend

  • SQL-Entwickler

Prerequisites

  • Grundlagen SQL-Programmierung

Course Content

  • Überblick DB-Architektur und Tuningwerkzeuge
  • Verarbeitungsprozess von SQL-Anweisungen
  • Einflussfaktoren auf SQL-Performance
  • SQL Optimizer - Komponenten und Arbeitsweise
  • Statistiken
  • Ausführungspläne - Erstellung und Interpretation
  • Anwendungstracing
  • Physische Tabellenspeicherung, Zugriffspfade und weitere Operatoren
  • Bindvariablen
  • Planstabilität
  • Effizienter SQL-Code
  • Tuningprozess und automatisches Tuning

Prices & Delivery methods

Online Training

Duration
3 days

Price
  • 1,960.— € (excl. tax)
    2,332.40 € (incl. 19% tax)
Dates and Booking
Request a date
Classroom Training

Duration
3 days

Price
  • Germany:
    1,960.— € (excl. tax)
    2,332.40 € (incl. 19% tax)

Schedule

Guaranteed date:   We will carry out all guaranteed training regardless of the number of attendees, exempt from force majeure or other unexpected events, like e.g. accidents or illness of the trainer, which prevent the course from being conducted.
This is a FLEX course, which is delivered both virtually and in the classroom. All FLEX courses are also Instructor-led Online Trainings (ILO).

German

European Time Zones

Online Training
Classroom option: Dresden Course language: German Guaranteed date!
Online Training
Classroom option: Dresden Course language: German Guaranteed date!
Online Training
Classroom option: Dresden Course language: German
Online Training
Classroom option: Dresden Course language: German
Online Training
Classroom option: Dresden Course language: German
Guaranteed date:   We will carry out all guaranteed training regardless of the number of attendees, exempt from force majeure or other unexpected events, like e.g. accidents or illness of the trainer, which prevent the course from being conducted.
This is a FLEX course, which is delivered both virtually and in the classroom. All FLEX courses are also Instructor-led Online Trainings (ILO).

Germany

Dresden Course language: German Guaranteed date!
Dresden Course language: German Guaranteed date!
Dresden Course language: German
Dresden Course language: German
Dresden Course language: German

If you can't find a suitable date, don't forget to check our world-wide FLEX training schedule.