바로가기 메뉴
본문 바로가기
주메뉴 바로가기

AWS

교육개요
교육 커리큘럼과 강사는 사정에 의해 변경될 수 있습니다.
교육명,를 포함한 교육과정 표
교육명 고급 Oracle Database SQL Tuning for Developers 1차
교육기간 2018-04-21 ~ 2018-04-22
교육시간 09:00 ~ 18:00 (8시간)
교육장 영우글로벌러닝  지도보기
강사 오라클 공인강사
정원 20명
교육비 1,083,000


교육소개
In the Oracle Database: SQL Tuning for Developers course, you learn about Oracle SQL tuning and how to
apply tuning techniques to your SQL code. Learn the different ways in which data can be accessed
efficiently. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.

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 Understand the optimizer process steps and operators.
Interpret execution plans.
Perform application tracing.
Gain an understanding of the Oracle Database Exadata Express Cloud Service.
교육목표
ㅇ Modify a SQL statement to perform at its best
ㅇ Identify poorly performing SQL
ㅇ Trace an application through its different levels of the application architecture
ㅇ Understand how the Query Optimizer makes decisions about how to access data
ㅇ Define how optimizer statistics affect the performance of SQL
ㅇ List the possible methods of accessing data, including different join methods
ㅇ Gain an understanding of the Oracle Database Exadata Express Cloud Service
교육대상
Application Developers, Data Warehouse Developer, Developer, PL/SQL Developer, Support Engineer

Benefit from gaining a deeper understanding of Oracle SQL statement tuning and how 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.
교육내용

Introduction

Course Objectives, Course Agenda and Appendixes Used in this Course
Audience and Prerequisites
Sample Schemas Used in the Course
Class Account Information
SQL Environments Available in the Course
Workshops, Demo Scripts, and Code Example Scripts
Appendices in the Course

Introduction to SQL Tuning
SQL Tuning Session
SQL Tuning Strategies
Development Environments: Overview
SQLTXPLAIN (SQLT) Diagnostic Tool

Using Application Tracing Tools
Using the SQL Trace Facility: Overview
Steps Needed Before Tracing
Available Tracing Tools: Overview
The trcsess Utility
Formatting SQL Trace Files: Overview

Understanding Basic Tuning Techniques
Developing Efficient SQL statement
Scripts Used in This Lesson
Table Design
Index Usage
Transformed Index
Data Type Mismatch
NULL usage
Tune the ORDER BY Clause

Optimizer Fundamentals
SQL Statement Representation
SQL Statement Processing
Why Do You Need an Optimizer?
Components of the Optimizer
Query Transformer
Cost-Based Optimizer
Adaptive Query Optimization
Optimizer Features and Oracle Database Releases

Generating and Displaying Execution Plans
Execution Plan?
The EXPLAIN PLAN Command
Plan Table
AUTOTRACE
V$SQL_PLAN View
Automatic Workload Repository
SQL Monitoring

Interpreting Execution Plans and Enhancements
Interpreting a Serial Execution Plan
Adaptive Optimizations

Optimizer: Table and Index Access Paths
Row Source Operations
Main Structures and Access Paths
Full Table Scan
Indexes
Common Observations

Optimizer Join Operations
Join Methods
Join Types

Other Optimizer Operators
SQL operators
Other N-Array Operations
Result Cache operators

Introduction to Optimizer Statistics Concepts
Optimizer Statistics
Types of Optimizer Statistics
Gather and Manage Optimizer Statistics: Overview

Using Bind Variables
Cursor Sharing and Different Literal Values
Cursor Sharing and Bind Variables

SQL Plan Management
Maintaining SQL Performance
SQL Plan Management

Workshops
Workshop 1
Workshop 2
Workshop 3
Workshop 4
Workshop 5
Workshop 6 & 7
Workshop 8
Workshop 9

Oracle Cloud Overview
Introduction to Oracle Cloud & Oracle Cloud Services
Cloud Deployment Models
Evolving from On-premises to Exadata Express
What is in Exadata Express?
Exadata Express for Users & Developers
Oracle Exadata Express Cloud Service
Getting Started with Exadata Express
Service Console & Web Access through Service Console


 

* Related Training

Required Prerequisites
Familiarity with database architecture
Knowledge of SQL and PL/SQL
Oracle Database 12c: Introduction to SQL Ed 1.1

Suggested Prerequisites
Oracle Database: SQL Workshop I
Oracle Database: SQL Workshop I Ed 2 NEW

 


 

 

 

 

 

 

 

학원의 설립ㆍ운영 및 과외교습에 관한 법률 시행령에 따라 다음과 같이 수강료를 환불해드립니다.

  1. 반환기한 : 반환사유가 발생한 경우 반환기준에 따라 반환사유 발생일로부터 5일 이내에 교습비등을 환불해 드리겠습니다.
  2. 반환기준
    • 1) 교습을 할 수 없거나 교습장소를 제공할 수 없게 된 날을 기준으로 이미 납부한 교습비등을 일할 계산한 금액을 환불해 드리겠습니다.
    • 2) 교습기간이 1개월 이내인 경우, 다음과 같이 환불해 드리겠습니다.
      - 교습시작 전 : 이미 납부한 교습비등의 전액
      - 총 교습시간 1/3 경과 전 : 이미 납부한 교습비등의 2/3에 해당하는 금액
      - 총 교습시간 1/2 경과 전 : 이미 납부한 교습비등의 1/2에 해당하는 금액
      - 총 교습시간 1/2 경과 후 : 반환하지 않음
    • 3) 교습기간이 1개월을 초과하는 경우, 다음과 같이 환불해 드리겠습니다.
      - 교습시작 전 : 이미 납부한 교습비등의 전액
      - 교습시작 후 : 반환사유가 발생한 해당월의 반환 대상 교습비등(교습기간 1개월 이내 기준 산출금액)과 나머지 월의 교습비등 전액을 합산한 금액