Szkolenia Oracle

Cel szkolenia szkolenie zdalne - dlearning

kod: OD-ELS-OD-SQL-TD | wersja: 12c

In this application development-centric course, students learn about Oracle SQL statement tuning and how to write well-tuned SQL statements appropriate for the Oracle database. Students learn to interpret execution plans and the different ways in which data can be accessed. Students are shown how to decipher, decide and then apply tuning to their SQL code. Various tuning techniques are demonstrated. For example, taking advantage of bind variables, trace files, and using the different types of indexes.

 Learn To: 

  • Use Oracle tools to identify inefficient SQL statements.
  • Use Automatic SQL Tuning.
  • Use Real Time SQL monitoring.
  • Write more efficient SQL statements.
  • Monitor and trace high load SQL statements.
  • Manage optimizer statistics on database objects.
  • Understand the optimizer process steps and operators.
  • Interpret execution plans.
  • Perform application tracing.

Benefits To You:

Benefit from gaining a deeper understanding of Oracle SQL statement tuning and how to write well-tuned SQL statements appropriate for the Oracle database in this application development-centric course. You will learn how to decipher, decide and then apply tuning to your SQL code. Various tuning techniques are demonstrated.

Objectives

  • Modifying a SQL statement to perform at its best
  • Identifying poorly performing SQL
  • Tracing an application through its different levels of the application architecture
  • Understanding how the Query Optimizer makes decisions about how to access data
  • Defining how optimizer statistics affect the performance of SQL
  • Listing the possible methods of accessing data, including different join methods

 

Plan szkolenia Rozwiń listę

    1. Introduction
    2. Course Objectives, Course Agenda and Appendixes Used in this Course
    3. Audience and Prerequisites
    4. Sample Schemas Used in the Course
    5. Class Account Information
    6. SQL Environments Available in the Course
    7. Workshops, Demo Scripts, and Code Example Scripts
    8. Appendices in the Course
    9. Introduction to SQL Tuning
    10. SQL Tuning Session
    11. SQL Tuning Strategies
    12. Development Environments: Overview
    13. SQLTXPLAIN (SQLT) Diagnostic Tool
    14. Using Application Tracing Tools
    15. Using the SQL Trace Facility: Overview
    16. Steps Needed Before Tracing
    17. Available Tracing Tools: Overview
    18. The trcsess Utility
    19. Formatting SQL Trace Files: Overview
    20. Understanding Basic Tuning Techniques
    21. Developing Efficient SQL statement
    22. Scripts Used in This Lesson
    23. Table Design
    24. Index Usage
    25. Transformed Index
    26. Data Type Mismatch
    27. NULL usage
    28. Tune the ORDER BY Clause
    29. Optimizer Fundamentals
    30. SQL Statement Representation
    31. SQL Statement Processing
    32. Why Do You Need an Optimizer?
    33. Components of the Optimizer
    34. Query Transformer
    35. Cost-Based Optimizer
    36. Adaptive Query Optimization
    37. Optimizer Features and Oracle Database Releases
    38. Generating and Displaying Execution Plans
    39. Execution Plan?
    40. The EXPLAIN PLAN Command
    41. Plan Table
    42. AUTOTRACE
    43. V$SQL_PLAN View
    44. Automatic Workload Repository
    45. SQL Monitoring
    46. DBML_SQL_MONITOR
    47. Interpreting Execution Plans and Enhancements
    48. Interpreting a Serial Execution Plan
    49. Adaptive Optimizations
    50. Optimizer: Table and Index Access Paths
    51. Row Source Operations
    52. Main Structures and Access Paths
    53. Full Table Scan
    54. Indexes
    55. Common Observations
    56. Optimizer Join Operations
    57. Join Methods
    58. Join Types
    59. Other Optimizer Operators
    60. SQL operators
    61. Other N-Array Operations
    62. Result Cache operators
    63. Introduction to Optimizer Statistics Concepts
    64. Optimizer Statistics
    65. Types of Optimizer Statistics
    66. Gather and Manage Optimizer Statistics: Overview
    67. Using Bind Variables
    68. Cursor Sharing and Different Literal Values
    69. Cursor Sharing and Bind Variables
    70. SQL Plan Management
    71. Maintaining SQL Performance
    72. SQL Plan Management
    73. Workshops
    74. Workshop 1
    75. Workshop 2
    76. Workshop 3
    77. Workshop 4
    78. Workshop 5
    79. Workshop 6 & 7
    80. Workshop 8
    81. Workshop 9

 

Pobierz konspekt szkolenia w formacie PDF

Dodatkowe informacje

Wymagania wstępne

Required Prerequisite Courses:

  • Oracle Database: Introduction to SQL Required Prerequisite Skills:
  • Familiarity with database architecture • Knowledge of SQL and PL/SQL
Poziom trudności
Czas trwania 3 dni
Certyfikat

Uczestnicy szkoleń otrzymają zaświadczenia o ukończeniu kursu sygnowane przez firmę Oracle.

Prowadzący

Autoryzowany wykładowca Oracle.

Pozostałe szkolenia Oracle | Oracle Database

Szkolenia powiązane tematycznie

Bazy danych

Formularz kontaktowy

Prosimy o wypełnienie poniższego formularza, jeśli chcą Państwo uzyskać więcej informacji o powyższym szkoleniu.






* pola oznaczone (*) są wymagane

Informacje o przetwarzaniu danych przez Compendium – Centrum Edukacyjne Spółka z o.o.

CENA SZKOLENIA OD 5400 PLN NETTO

Najbliższe szkolenia Oracle

Harmonogram szkoleń Oracle