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

AWS

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


교육소개
본 과정은 데이터 보안 모듈, 데이터 사용 가능 모듈, 파티셔닝 데이터 모듈, 정보 수명주기 관리 모듈 및 모니터링 DB 운영 및 성능 관리 모듈로 구성됩니다.
(TDE) 및 기타 보안 영역, Recovery Manager, 온라인 운영, Oracle Data Pump, SQL Loader, 새로운 분할 방법, 자동 데이터 최적화, 메모리 내부 열 저장소,
전체 데이터베이스 입력과 같은 데이터베이스 관리 - 메모리 캐싱 및 자동 빅 테이블 캐싱에 대해 학습합니다.
교육목표
○ Manage security by using Unified Auditing
○ Manage security by using privileges and profiles
○ Manage security by using Privilege Analysis
○ Manage security by using Data Redaction
○ Manage security by using Transparent Data Encryption
○ Manage security by using Transparent Sensitive Data Encryption
○ Describe the new RMAN enhancements
○ Manage data availability by using new features of Oracle Data Pump, SQL*Loader and external tables
○ Manage data availability by performing online operations
○ Manage data partitioning
○ Manage Information Lifecycle by using ADO
○ Manage Information Lifecycle by using In-Database Archiving and Temporal features
○ Describe database operations
○ Configure and use In-Memory Column Store
○ Use In-Memory Caching
○ Use Real Application Testing enhancements
교육대상
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 Basics
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 Back
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


○ 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개월 이내 기준 산출금액)과 나머지 월의 교습비등 전액을 합산한 금액