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

Oracle

교육개요
교육 커리큘럼과 강사는 사정에 의해 변경될 수 있습니다.
교육명,를 포함한 교육과정 표
교육명 중급 Oracle Database 12c R2: New Features for 12c R1 Administrators (12c R1-> R2 새로운 기능) 2차
교육기간 2018-06-18 ~ 2018-06-22
교육시간 35시간
교육장 영우글로벌러닝  지도보기
강사 오라클공인강사
정원 20명
교육비 1,805,000원


교육소개
The Oracle Database 12c R2: New Features for 12c R1 Administrators course is designed for existing 12c Release 1 DBAs. In addition to covering the New Features of R2, this course also introduces students to the Oracle
Database Cloud Service.

Learn To:
Create and manage application containers and applications in multitenant container databases.
Manage resources in a multitenant container database and pluggable databases with Resource Manager performance profiles and new memory directives.
Perform pluggable database flashback.
Upgrade the multitenant container databases and pluggable databases.
Manage security by using enhancements in unified auditing, system privileges, Privilege Analysis, Data Redaction, Transparent Sensitive Data Protection and Transparent Data Encryption.
Manage data availability by using Recovery Manager, Oracle Data Pump features and SQL*Loader enhancements, and by performing enhanced online operations.
Increase the SQL performance by using the In-Memory Column-Store enhancements at deployment and SQL performance.
Tune the SQL performance by using the Optimizer Statistics Advisor and SQL join processing.
Monitor your databases by using DB operations enhancements.
Benefit from enhancements in partitioning methods.
Benefit from ADR automatic space file management.
Use the Trace File Analyzer collector to diagnose issues.
Use the new SQL*Plus history commands and SQL enhancements such as long identifiers.
Use the new SQLcl utility to benefit from commands and features missing from SQL*Plus itself.
Describe the Oracle Public Cloud services related to databases management.

Benefits To You

In the lessons, you learn the new and enhanced features of Oracle Database 12c Release 2 (12.2.0.1) amongst different areas such as Multitenant, security, availability, performance, diagnosability, manageability,
partitioning and SQL.

You also learn how to easily deploy databases with Oracle Database Cloud Services, check automated backups and monitor your Cloud deployment with new Cloud tools.
교육목표
- Perform recovery and flashback operation on pluggable databases
- Monitor multitenant container database and pluggable databases by using ADDM / AWR enhancements at PDB level
- Manage resources in a multitenant container database and pluggable databases with Resource Manager performance profiles
- Tune the SQL performance by using the Optimizer Statistics Advisor and SQL join processing
- Benefit from enhancements in partitioning methods
- Use the ADR automatic file space management
- Use the SQLcl new utility as the new SQL command line interface
- Create pluggable databases with new methods and local UNDO mode
- Create and manage application containers and applications in multitenant container databases
- Manage security in application containers
- Manage data optimization in pluggable databases with heat map statistics and ADO policy eviction
- Upgrade pluggable databases and multitenant container databases
- Manage security by using enhancements in unified auditing, system privileges, Privilege Analysis, Data Redaction, Transparent Sensitive Data Protection & Data Encryption
- Manage data availability by using Recovery Manager, Oracle Data Pump features and SQL*Loader enhancements and by performing online operations
- Monitor your databases by using DB operations
- Increase the SQL performance by using In-Memory Column-Store enhancements for deployment and SQL performance
교육내용

 

Introduction

    Application Containers and Applications

      Security in PDBs

        PDBs Creation Using New Methods

          PDBs Recovery and Flashback

            Performance in PDBs

              Upgrade and Other Operations in PDBs

                Privileges and User Profiles

                  Unified Auditing

                    Data Redaction

                      Data Encryption

                        Transparent Sensitive Data Protection

                          Availability Enhancements

                            Oracle Data Pump, SQL*Loader and External Tables

                              In-Memory Column Store

                                SQL Tuning

                                  Resource Manager and Other Performance Enhancements

                                    Partitioning

                                      Manageability

                                        Diagnosability

                                          Oracle Database Cloud Services

                                            SQL Enhancements

                                             

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

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