• India Flag
    Call Us:

    +91 769-409-5404

  • USA Flag
    Call Us:

    +1 786-629-6893

About Course:

In this new course, students will learn about the new and enhanced features and options of Oracle Database 12c. Expert instructors will teach you how these features and options increase security, manageability, and performance. In this course, you will be introduced to the Oracle Database Cloud Service. It will train DBA’s how Oracle12c Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.


Duration : 30 hours

Fee: 319


Job Trends


Who Should Learn?

• Database Administrator worked on 9i/10g or 11g • Systems Administrator • Oracle Certified Associates or Oracle Certified Professionals (OCA or OCP)

Prerequisite

Basic knowledge of database.

Delivery Methodology

We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course.

Class Delivery

Live Interactive classes with expert

Training Calender

Date Time Type Attend
No Schedule Available
Contact Us

+91 769-409-5404

Includes
  • 24 hours on-demand video
  • Articles
  • Coding Exercises
  • Full lifetime access
  • Certificate of Completion

Curriculum

Oracle 12c DBA

Oracle 12c DBA (Database Administration)  Admin Part

What you learn:

  • Understanding Multitenant Architecture
  • Configuring Containers and Pluggable Databases
  • Managing Storage Structure
  • Using New Oracle 12c RMAN features
  • Backups of CDBs and PDBs
  • Manage the Oracle multitenant container databases and pluggable databases.
  • Configure the Heat Map and use Automatic Data Optimization.
  • Online Datafile Movement
  • Understand the new Temporal capabilities as well as In-Database Archiving with Row-archival.
  • Enforce security with the Unified Auditing, the new administrative privileges, Privilege Analysis, and Data Redaction.
  • Database In-Memory option, and Full Database In-Memory Caching and the Automatic Big Table Caching features.
  • Benefit from optimizer enhancements such as Adaptive Execution Plans and SQL Plan Directives, Real-Time ADDM and Compare Period ADDM.
  • Use enhanced features of Resource Manager in multitenant container databases and pluggable databases.
  • Understand how and when to use enhancements in Data Pump, partitioning, and SQL.
  • Gain an understanding of the Oracle Database Cloud Service.

Prerequisite:

SQL knowledge

Architecture Overview

  • Overview of Oracle Database 12c
  • Oracle Database Instance Configurations
  • Connecting to the Oracle Database Instance
  • Oracle Database Memory Structures and Process Architecture
  • Database Storage Architecture
  • Basics and Advantages of Multitenant Architecture
  • Pluggable databases and container databases
  • Difference between 11g and 12c
  • Dictionary Views 12c (CDB_XXX, DBA_XXX, ALL_XXX etc.)

Installation and Database Creation

  • 12c Installation
  • Database Creation using DBCA (CDB and PDB)
  • Configuration and creation of CDB
  • Create a PDB from a non-CDB
  • Create a new PDB from PDB$SEED
  • Cloning of PDB
  • PDB Snapshot Clone
  • View the Alert Log File

Startup and Shutdown of Database

  • Start up a CDB
  • Describe the stages of database startup
  • Open / Close a PDB (SQL*Plus)
  • Shut down a CDB
  • Change PDB state
  • Shutdown Types
  • Alert Log Files and Trace files

Configuring the Oracle Network Environment

  • Use Enterprise Manager to create and configure the Listener
  • Use testing to test Oracle Net connectivity
  • Identify when to use shared servers and when to use dedicated servers

Managing Data Concurrency

  • Data ConcurrencyEnqueue Mechanism
  • Resolving Lock Conflicts
  • Deadlocks

Managing Tablespaces, Common and Local Users, Privileges, and Roles

  • Create permanent tablespaces in the root and PDBs
  • Roles and Privileges (dba_sys_privs and dba_tab_privs)
  • Manage common and local schemas and users in the root and PDBs
  • Manage system and object privileges to common and local grantees granted
  • Manage common and local roles granted commonly or locally

Backup & Recovery in Multitenant Databases

  • Backups
  • Recovery
  • Handling redo log failures
  • Control File recovery
  • Recovery use cases
  • Point In Time Recovery
  • Using the RMAN Recovery Catalog
  • Tracking and Storing Backup Information
  • Setting up a Recovery Catalog
  • Backup and Recovery Reporting
  • Restoring from Autobackup: Server Parameter File and Control File

Moving Data

  • Describe ways to move data
  • Create and use directory objects
  • The general architecture of Oracle Data Pump
  • Use Data Pump export and import to move data

Using Flashback Technology

  • Flashback Technology: Overview and Setup
  • Using Flashback Technology to Query Data
  • Flashback Table
  • Flashback Transaction Query
  • Flashback Drop and the Recycle Bin
  • Configuring Flashback Database
  • Performing Flashback Database Operations

Performance Tuning

  • Tuning Basics
  • Wait for Events, Class, and Statistics
  • System Statistics Dictionary Views
  • Invalid and Unusable Objects
  • Index Scans and Type of Index Scans
  • Parallelism and parallel_degree_policy
  • Statistics and Histograms
  • Cursor Sharing and Bing Peeking
  • AWR and ADDM reports

 

Use Case

Use Case 1

Certificate

Certificate
Benefits of Certificate

Certification demonstrates your dedication, motivation and technical knowledge on a specific platform. Having a certification shows that you not only possess comprehensive knowledge of that technology but you also care enough about your own career to spend the time and money to get the certification.

We are welcoming our Students or professionals to participate in our professional online courses. We are offering great variety of online training programs and professional courses that you can always find as desired. After the completion of training program they will receive a certificate from BISP. As a Certified professional you can apply that knowledge in your future profession and enjoy with better salaries & career prospects.

Signup for free newsletter and
business tips

Any Questions?
Talk to our Course Co-ordinator

+91 769-409-5404
Want to see a live demo? We'll be in touch within 24 hours?