Do not get relaxed with Oracle 11gR2 database administration, it is very vital to upgrade your skills to Oracle 12c. Add value to your projects, clients and most importantly to your career with this Oracle 12c new features training. Be the first and quick in the market to get real time exposure and experience on the new features with this Part I course. Part I and Part II courses will concentrate on training you on both theoretical concepts and activities with our focused approach.

Get hands-on experience on new Oracle 12c Database environment now.

  • Install and Implement yourself.
  • Simple and easy to understand.
  • Meet industry standards.

System requirements:

  • Laptop/Desktop with at least 3GB RAM.
  • Minimum of Dual Core processor.
  • 60 GB of disk space.

Training details:

  • 16 Sessions.
  • Trainer: Pawan Kumar Yaddanapudi.
  • Includes supporting documents, software’s and Log files.
  • Anytime assistance.

 

Pick your mode of learning:

Video tutorials:

  • Learn at your own pace.
  • Saves 50% of your money.
  • Revise any number of times for 6 months.
  • Assured quality and content as classroom/online training.

Online training:

  • One scheduled session per day.
  • Good internet connectivity required.
  • Batch of minimum 5 students.

Click Here for Online Training Schedule

Course Content

10             ALL ABOUT RECOVERY MANAGER – RMAN

10.1.        RMAN and SQL

10.2.        RMAN Duplication Enhancements

10.3.        Duplicate active database

10.4.        Duplication in CDB

10.5.        RMAN Transportation – DB and Tablespaces

10.6.        Recovering table

11             DATABASE OPERATIONS

11.1.         Monitoring Real-Time Database Operations

11.2.         What is DB operations

11.3.         Understanding DB Operations

11.4.         Managing DB Operations

11.5.         Controlling DB Operations

11.6.         Executing and Monitoring DB Opearations

12             PERFORMANCE MONITORING TOOLS – AWR, ADDM AND ASH

12.1.        Emergency monitoring

12.2.        Real-time ADDM

12.3.        ADDM reporting

12.4.        AWR challenges & ADDM

12.5.        ASH analytics

12.6.        Automatic Diagnostic Repository& ADRCI

12.7.        Network Enhancements

13            IN-MEMORY COLUMNAR STORE

13.1.        In-Memory Column Store Overview

13.2.        Row Store vs Column Store

13.3.        Implement In-Memory Database

13.4.        Compression features

13.5.        Statistics of In-Memory Database

13.6.        Optimizer for Column Store

13.7.        Execution plans

13.8.        Querying & Performance Comparison

13.9.         What in RAC and Datapump

14             CACHING

14.1.          Overview

14.2.          Full Database Caching

14.3.          Monitoring Cache

14.4.          Parallel Querying

14.5.          Auto Big Table Caching

14.6.          Configure Big Table

14.7.          Use and Monitor Big Table

15              PERFORMANCE TUNING ENHANCEMENTS – 1

15.1.          SQL Plan Baseline

15.2.          SQL Plan Management

15.3.          Adaptive SQL Plan Management

15.4.          Adaptive Execution Plans

15.5.          Dynamic Plans

15.6.          Auto Re-Optimization

15.7.          SQL Plan Directives

15.8.         Statistics enhancements

15.9.         Histograms

16            PERFORMANCE TUNING ENHANCEMENTS – 2

16.1.        Resource Manager and Container Databases

16.2.        CDB Resource Plan Basics

16.3.        Managing PDB Resource Plans

16.4.        Run-away Queries

16.5.        Multi-Process Multi-Thread Architecture

16.6.        Temporary Undo

17              EXPORT AND IMPORT

17.1.          Transportable Export and Import

17.2.          Transporting DB over Network

17.3.          Table Compression during Import

17.4.          SQL * Loader Enhancements

18             TABLE PARTITIONING ENHANCEMENTS

18.1.          Interval Reference Partitioning

18.2.          Multi-partition Management

18.3.          Create/Add/Drop Multiple Partitions

18.4.          Split/Merge Multiple Partitions

18.5.          Partitioned Indexes

18.6.          Partial Indexes

18.7.          Explain Plan – Index specifics

18.8.         Global Index Maintenance