Oracle Database 19c: SQL Workshop - D108644

Beschreibung

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.
 

expand_more chevron_right Zielgruppe

Dieses Seminar richtet sich an:
  • Data Warehouse-Administratoren
  • Entwickler
  • PL/SQL-Entwickler
  • Formsentwickler
  • Systemanalytiker
  • Businessanalytiker

    expand_more chevron_right Vorkenntnisse

    Für dieses Seminar werden folgende Kenntnisse empfohlen:
    • Datenverarbeitung
    • Vertrautheit mit Konzepten und Techniken der Datenverarbeitung

    expand_more chevron_right Detail-Inhalte

    • Introduction
    • Retrieving Data Using the SQL SELECT Statement
    • Restricting and Sorting Data
    • Using Single-Row Functions to Customize Output
    • Using Conversion Functions and Conditional Expressions
    • Reporting Aggregated Data Using the Group Functions
    • Displaying Data from Multiple Tables Using Joins
    • Using Subqueries to Solve Queries
    • Using Set Operators
    • Managing Tables Using DML Statements in Oracle
    • Introduction to Data Definition Language in Oracle
    • Introduction to Data Dictionary Views
    • Creating Sequences, Synonyms, and Indexes
    • Creating Views
    • Managing Schema Objects
    • Retrieving Data by Using Subqueries
    • Manipulating Data by Using Subqueries
    • Controlling User Access
    • Manipulating Data Using Advanced Queries
    • Managing Data in Different Time Zones
     
     
    • expand_more chevron_right event_available 19.04.-23.04.2021 19.04.2021 verified_user Termingarantie Seminarzeitentimer5 Tage5 T roomETC-Wien
      • expand_more chevron_right ETC Classroom - im Seminarzentrum 3.490,00
        • Ihr ILT Seminar (Instructor Led Training)
        • Seminarunterlagen, Teamwork, Labs
        • Verpflegung vorort in einem der  ETC Seminarzentren
        • Seminar-Services
    • expand_more chevron_right event_available 06.09.-10.09.2021 06.09.2021 Seminarzeitentimer5 Tage5 T roomETC-Wien
      • expand_more chevron_right ETC Classroom - im Seminarzentrum 3.490,00
        • Ihr ILT Seminar (Instructor Led Training)
        • Seminarunterlagen, Teamwork, Labs
        • Verpflegung vorort in einem der  ETC Seminarzentren
        • Seminar-Services
    • expand_more chevron_right event_available 15.11.-19.11.2021 15.11.2021 Seminarzeitentimer5 Tage5 T roomETC-Wien
      • expand_more chevron_right ETC Classroom - im Seminarzentrum 3.490,00
        • Ihr ILT Seminar (Instructor Led Training)
        • Seminarunterlagen, Teamwork, Labs
        • Verpflegung vorort in einem der  ETC Seminarzentren
        • Seminar-Services