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

AWS

교육개요
교육 커리큘럼과 강사는 사정에 의해 변경될 수 있습니다.
교육명,를 포함한 교육과정 표
교육명 중급 Oracle Database 12c: New Features for Administrators Part1 (DBA에 꼭 필요한 오라클 12c 새로운 기능) 3차
교육기간 2019-10-14 ~ 2019-10-18
교육시간 09:30~17:00(1일 6시간, 총 30시간)
교육장 영우글로벌러닝  지도보기
강사
정원 20명
교육비 1,895,250원(VAT별도)


교육소개
본 과정은 세가지 모듈로 구성됩니다. SQL 신기능 및 도구 사용, DB 아키텍처 이해 및 데이터베이스 문제 진단과 관련하여 학습하게 됩니다.
수강생들은 주로 On-Premise Multitenant 데이터베이스의 다양한 데이터베이스 관리 영역에서 Oracle Database 12c Release 2의 새롭고 향상된 기능에 대해
잘 알 수 있습니다.
교육목표
○ Create and manage pluggable databases
○ Describe the challenges and benefits of a sharded database
○ Handle the ADR automatic file space
○ Diagnose database issues by using the Trace File Analyzer collector
○ Use the new SQL*Plus history commands and SQL enhancements such as long identifiers
○ Use the SQLcl new utility as the new SQL command line interface
○ Create and manage a multitenant container database
교육대상
End Users / Database Administrators / System Administrator
교육내용

□ Course Topics 


○ Introduction

- Understanding DB architectures

- Diagnosing database problems

- Global objectives of the course
- Schedule of the week

- Using SQL new features and tools

- Lessons grouped by modules

 


○ Using SQL New Features and SQLcl 

- Use SQL row-limiting clause
- Use new 128 bytes identifier length for database objects

- Describe the support for invisible and hidden columns

- Increase length limits of data types

- Use the new VALIDATE_CONVERSION function

- Recall SQL*Plus commands in the same session from history

- Describe the new SQLcl utility

 

○ Understanding CDB Basicsl 

- Challenges
- Configurations

- CDB root and pluggable database containers

- SYSTEM objects in the USER container

- New Multitenant Architecture: Benefits

- Non-CDB Architecture vs Oracle Multitenant Container Database

- A pristine installation

- Provisioning a pluggable database

 

 ○ Creating CDB and Regular PDBs

- Tools
- Create a CDB using new clauses

- What's new in CDB after CDB creation

- ADR

- Data dictionary views

- Provisioning new PDBs: overview

- What to do in CDB after CDB creation

 

 ○ Creating Application PDBs and Installing Applications

- PDBs and applications
- Application common objects

- Create and manage an application container

- Types of containers

- Patch and upgrade applications

- Regular PDBs vs application PDBs

- Application containers

- Install applications

 

○ Creating PDBs 

- Cloning regular and application containers PDBs
- Converting regular PDBs to application root or PDBs

- Cross-Platform transportable PDB

- Plugging unplugged regular and application PDBs into CDB

- Plugging unplugged PDBs with encrypted data

- Perform hot cloning and relocation

- Configure and use locla UNDO mode

- Plugging or cloning a non-CDB into a CDB

 

○ Managing CDB and PDBs

- Creating and renaming Services
- Switching Connection

- Opening CDBs and PDBs

- Managing CDB and PDBs

- Mounting a CDB

- Evaluating the impact of parameter value changes

- Changing the different modes and settings of PDBs

- Starting Up a CDB Instance

 

○ Managing Storage

- Creating Permanent Tablespaces in a CDB

- Objects in Tablespaces

- UNDO Tablespaces

- Tablespaces Created During PDB Creation

- Temporary Tablespaces

- Defining Default Permanent Tablespaces

 

○ Managing Security

- Enabling Common Users to Access Data in PDBs

- Encrypting data in PDBs

- Creating common users, roles and profiles in CDB and PDBs

- Protecting data with Database Vault policies in CDB and PDBs

- Common objects in Application PDBs and operations on Data-Linked objects

- Granting privileges commonly in CDB and PDBs

- Auditing users in CDB and PDBs

- Managing PDB lockdown profiles

 

○ Backing up, Recoverying and Flashing  

- Instance failure and instance recovery

- CDB and PDB backups

- PDB point-in-time recovery

- New syntax and clauses in RMAN

- PDB tempfile, essential and non-SYSTEM tablespaces recovery

- CDB and PDB flashback

- Duplicating PDBs

- Using RMAN backup to plug an unplugged PDB

 

○ Back Managing Performance

- Monitoring PDB memory usage

- AWR report

- Managing SGA and PGA for PDBs

- Controlling the Degree of Parallelism of Queries

- PDB-Level snapshot views

- AWR and ADDM behaviour at CDB and PDB levels

- Sizing the CDB

- Tuning a CDB

 

○ Managing Resources Allocation

- Controlling PDB IO rate limit

- Managing resources within a PDB

- CDB Resource plan basics: Limits + cpu_count init parm per PDB

- Creating and setting PDB performance profiles

- Allocating resources in the CDB and PDBs

- Managing resources between PDBs

 

○ Moving and Migrating Data

- Transporting a database over the network

- Exporting non-CDB data and importing non-CDB data into PDB

- Using SQL*Loader with PDBs

- Exporting and importing between PDBs

- Exporting from PDB and importing into a non-CDB

- Full Transportable export/import

- Using Oracle Data Pump with PDBs

 

○ Performing Miscellaneous Operations

- Using catcon.pl utility to install/remove options from CDB/PDB

- Jobs coordinator and resources

- Creating a standby of a CDB

- Using Xstreams with a CDB and PDB

- Mining statements of a PDB using LogMiner

- Scheduling operations in a PDB

 

○ Understanding Database Sharding

- Benefits of Sharding

- Advantages of Oracle Sharding over NoSQL

- Creating Sharded Tables

- Sharded Table Family

- What Is Database Sharding?

- Application Considerations for Sharding

- Components of Database Sharding

- Complete Deployment of a System-Managed SDB

 

Diagnosing Database Problems

- TFA Collector utility

- Tracing Data Pump

- New ADRCI Command

- Automatic Diagnostic Repository

- MVs refreshed statistics history

- Trace File Analyzer (TFA) Collector process and repository

- ADR Retention

- Network Performance


 

 

 

 


 

 

 

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

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