• India Flag
    Call Us:

    +91 769-409-5404

  • USA Flag
    Call Us:

    +1 678-701-4914

About Course:

Oracle-12c-DBA

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: 438


Job Trends

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

Module of Training

LIVE ONLINE TRAINING


Live presentation of theory, demonstration of tool, features & tasks

We are connecting Online via Goto Meeting

Get practice environment for practical & hands-on Training curriculum has been designed by real-time industry professionals & real-time scenarios training pattern

CORPORATE TRAINING


Learn as per day-wise & customized schedule with discussions & lab exercises included

One to one or Batch-wise interactive demonstration of a tool, features and 100% practical classes

World-class learning material & case studies for the course

Completely customizable course content & schedule as per convenience

Certification guidance provided if necessary

Curriculum

Oracle 12c DBA Download  

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

 

Who should Learn Oracle 12c DBA?

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

Prerequisite to learn Oracle 12c DBA

Basic knowledge of database.

Delivery Methodology used to deliver the Oracle 12c DBA

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

Oracle 12c DBA FAQ

Question: Can I attend the Demo session before enrollment?

Answer: Yes, you may attend the Demo class before enrollment for training Quality Evaluation. You can also Interact with a trainer as one to one session for a specific requirement or discussion

Question: Can you schedule the training based upon my availability?

Answer: Yes, we need to discuss it with a trainer, accordingly, we can schedule training at a convenient time.

Question: How I can pay for the course?

Answer: You can pay the fee or enroll yourself via payment gateway through the course page, make an online payment using various options.

Question: What if I missed any class?

Answer: BISP has a missing class policy. If you missed any session, we will be sharing a recorded session. However, you may retake whole training multiple times within 6 month period but the trainer is the same.

Question: Is there any live project training along with regular training?

Answer: Our training curriculum includes real-time scenarios and lives project working module & the trainer explains every topic with examples. If you have any issue or you are stuck in any scenario the trainer will explain end-to-end.

Question: What about certification preparation and guidance?

Answer: BISP technical faculty assist & guide you completely for certification and preparation. We ensure you will get certified easily after our training.

Question: Who is the trainer & about his experience?

Answer: All our trainers are working professionals and industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo We also ensure that only those trainers with a high alumni rating continue to train for us.

Question: Do you provide Job support?

Answer: Yes, we provide Job support services, but the cost structure is different and fixed. For more details: Just give us a call at: +91 769-409-5404 & +1 678-701-4914 You can also write to us: support@bisptrainings.com

Question: What if I have more queries and doubts?

Answer: Just give us call at : +91 769-409-5404 & +1 678-701-4914 You can also write to us: support@bisptrainings.com

Question: How Fee Refund Policy works?

Answer: Please refer the link for refund policy: https://www.bisptrainings.com/Refund-Policy

Case Study and Learning Pdf's

Certificate

Certificate123
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?