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.
  • 40 GB of disk space.

Training details:

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

Demo Video:

 

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

1              INTRODUCTION TO ORACLE 12C NEW FEATURES

1.1.         What’s new?

1.2.         Details

1.3.         Software Installation – 12.1.0.2

2              MULTITENANT CDB AND PDBS

2.1.         Pre-Oracle 12c

2.2.         Benefits of Multitenant Architecture

2.3.         Possible Configurations

2.4.         Multitenant CDB

2.5.         User container and Data

2.6.         Provisioning pluggable DB

2.7.         Multitenant CDB architecture

2.8.         Containers

2.9.         Users, Privileges and Roles

2.10.      Objects & Data dictionary views

3              CREATING CDB AND PDB

3.1.         When to opt CDB?

3.2.         Layout

3.3.         Create CDB using SQLplus

3.4.         Create CDB using DBCA

3.5.         Whats new?

3.6.         Post creation

3.7.         ADR – Automatic Diagnostic Repository

3.8.         Provisioning New PDBs – Methods

3.9.         Dropping a PDB

3.10.      Migrating pre-12c to 12c CDB

4              MANAGING CDB & PDB’s

4.1.         Connections

4.2.         Startup & Shutdown

4.3.         PDB settings

4.4.         Parameter Changes

4.5.         Tablespaces in PDB’s

4.6.         Permanent Tablespaces

4.7.         Default Tablespaces

4.8.         Temporary Tablespaces

4.9.         Users, Roles & Privileges

5              BACKUP, RECOVERY & FLASHBACK CDB & PDB’s

5.1.         Goals

5.2.         New RMAN clauses

5.3.         CDB backup

5.4.         PDB backup

5.5.         Recovery

5.6.         Instance failure

5.7.         NOARCHIVELOG mode

5.8.         Media failure

5.9.         Flashback CDB

6              ADO & Storage

6.1.         ILM challenges & Solution

6.2.         ADO & Heat map

6.3.         Enabling Heat map

6.4.         Compression

6.5.         Storate tiering

6.6.         Policies on segment

6.7.         Evaluation & Execution

6.8.         ADO DDL’s

6.9.         Online move Datafile/Partitions

6.10.      Compatibilities

6.11.      Partitions

7              IN-DATABASE ARCHIVING & TEMPORAL

7.1.         Define & pre 12c

7.2.         12c solutions

7.3.         In-database archiving

7.4.         Temporal validity & Temporal history

7.5.         Temporal validity

7.6.         Temporal history

8              AUDITING & PRIVILEGES

8.1.         Pre-12c Auditing

8.2.         12c Auditing

8.3.         Security

8.4.         Simplicity – Audit policy

8.5.         Create/View/Enable/Disable audit policy

8.6.         Challenges in privileges

8.7.         New Admin privileges

8.8.         New system privileges

8.9.         Pre-12c privilege listing

8.10.      12c privilege listing

9              DATA REDACTION

9.1.         Overview & Operational activities

9.2.         Types of Data redaction

9.3.         Redaction policy

9.4.         Managing/applying policies

9.5.         Examples

9.6.         Modfy redaction policy

9.7.         Data redaction & other database security solutions

9.8.         Best practices