Oracle DBA 12c Training Course

Oracle DBA 12c Training Course

Click on the buttons inside the tabbed menu:

Course Description

The Pl-SQL program is designed to help the participant to understand the installation of database in a RDBMS environment and to successfully work in this domain.

There are multiple courses available to fit the requirement of students and working Professionals.

1. Oracle DBA Administration 12c.

2. Oracle DBA Administration 11g

;
What skills will the student gain?
After the completion of this course, the student will be able to:

  • Understand the installation of Oracle Database.
  • ·   Creation of database instances
  • ·   Maintenance of databases
  • ·   Making backups and restore of databases
  • ·   Understand different types of delivered features by Oracle
  • ·   Use Pl-SQL programs to insert, update and delete multiple records through a single program.

Mode of Training

The Pl-SQL training is delivered in the following modes - Regular Classroom, Fast-track, Self-Study and Online live trainer

Locations:

The training is offered in locations like Chennai, Bangalore, Kolkata, Mumbai and NCR.

To know more about the schedules in those cities click here -->

Schedule for Kolkata

Outside the country it is delivered in Dhaka, Thimpu, Singapore, Kuala Lumpur, Middle East, Africa and Australia.

The course outline delivered during the class is as follows -

    Exploring Oracle Database Architecture

    •Introducing Oracle Database

    •Relation Database Models

    •Oracle SQL and PL/SQL

    •Oracle Database Server Architecture

    •Connecting to Oracle Databases

    •Oracle Database Tools

    •Oracle-Supplied User Accounts

    •Querying the Oracle Data Dictionary

    Managing Database Instances

    •Initialization Parameter Files

    •Starting Up Oracle Databases

    •Shutting Down Oracle Databases

    •Opening and Closing PDBs

    •Working with the Automatic Diagnostic Repository (ADR)

    •Querying Dynamic Performance Views

    Creating PDBs

    •Methods and Tools to Create PDBs

    •Creating PDBs from Seed with SQL*Plus

    •Cloning PDBs with SQL*Plus

    •Unplugging and Pluggin In PDBs with SQL*Plus

    •Dropping PDBs with SQL*Plus

    Configuring the Oracle Network Environment

    •Oracle Net Services

    •How Listeners Work

    •Configuring Listeners for Dynamic Service Registration

    •Configuring Listeners for Static Service Registration

    •Configuring Local Naming for Connections

    •Testing Oracle Net Connectivity with tnsping

    •Configuring Communication Between Databases

    •Dedicated Versus Shared Server Configurations

    Administering User Security

    •Creating Users

    •Granting Privileges

    •Creating and Granting Roles

    •Revoking Privileges and Roles

    •Creating and Assigning Profiles

    •Authenticating Users

    •Applying the Principal of Least Privilege

    Creating and Managing Tablespaces

    •How Table Data is Stored

    •Creating Tablespaces in SQL*Plus

    •Altering and Dropping Tablespaces in SQL*Plus

    •Viewing Tablespace Information in SQL*Plus

    •Implementing Oracle Managed Files

    •Moving and Renaming Online Data Files in SQL*Plus

    Managing Storage Space

    •Oracle Database Space Management Features

    •Block Space Management

    •Row Chaining and Migration

    •Free Space Management Within Segments

    •Types of Segments

    •Allocating Extents

    •Understanding Deferred Segment Creation

    •Space-Saving Features

    Managing UNDO Data

    •Undo Data: Overview

    •Transactions and Undo Data

    •Storing Undo Information

    •Comparing Undo Data and Redo Data

    •Managing Undo

    •Local Undo Mode Versus Shared Undo Mode

    •Configuring Undo Retension

    •Categories of Undo

    Moving Data

    •Moving Data: General Architecture

    •Oracle Data Pump: Overview & Benefits

    •Data Pump Export and Import Clients

    •Data Pump Utility: Interfaces and Modes

    •Data Pump Import: Transformations

    •SQL*Loader Overview

    •Loading Methods

    Backup and Recovery Concepts

    •DBA Responsibilities

    •Categories of Failure

    •Understanding Instance Recovery

    •Understanding Types of Backups

    •Comparing Complete and Incomplete Recovery

    •Oracle Data Protection Solutions

    •Flashback Technology

    Monitoring and Tuning Database Performance

    •Managing Performance Activities

    •Performance Planning Considerations

    •Database Maintenance

    •Automatic Workload Repository (AWR)

    •Automatic Database Diagnostic Monitor

    •Performance Monitoring

    •Performance Tuning Methodology

    •Database Server Statistics and Metrics

    SQL Tuning

    •SQL Tuning Process

    •Oracle Optimizer

    •Optimizer Statistics

    •SQL Plan Directives

    •Adaptive Execution Plans

    •SQL Tuning Advisor

    •SQL Access Advisor

    •SQL Performance Analyzer

    Oracle Database Resource Manager

    •Oracle Database Resource Manager: Overview

    •Resource Manager Elements

    •Using Resource Manager to Allocate Resources

    •Creating a Simple & Complex Resource Plan

    •Using the Active Session Pool Feature

    •Limiting CPU Utilization at the Database Level

    •Limiting CPU Utilization at the Server Level

    Enterprise Manager Cloud Control

    •Controlling the Enterprise Manager Cloud Control Framework

    •Starting & Stopping the Enterprise Manager Cloud Control Framework

    Introduction to Oracle Database Cloud Service

    •Oracle Cloud: Overview

    •Database Cloud Service Offerings

    •DBCS Architecture

    •Features and Tooling

    •Additional Database Configuration Options

    Creating DBCS Database Deployments

    •Automated Database Provisioning

    •Creating a Database Deployment

    •How SSH Key Pairs are Used

    •Creating an SSH Key Pair

    •Storage Used for Database Files Managing DBCS Database Deployments •Cloud Tooling

    •Accessing Tools and Features from the DBCS Console

    •Managing the Compute Node Associated With a Database Deployment

    •Managing Network Access to DBCS

    •Enabling Access to a Compute Node Port

    •Scaling a Database Deployment

    Backing Up and Restoring DBCS Database

    Deployments

    •Backing Up and Recovering Databases on DBCS

    •Backup Destination Choices

    •Backup Configuration

    •Creating an On-Demand Backup

    •Customizing the Backup Configuration

    •Performing Recovery by Using the Console

    •Performing Recovery by Using the dbaascli Utility

    Patching DBCS Database Deployments

    •Patching DBCS

    •Using the DBCS Console to Manage Patches

    •Using the dbaascli Utility to Manage Patches

    Creating Master Encryption Keys for PDBs

    •CDB and PDB Master Encryption Keys

    •Determining Whether You Need to Create and Activate and Encryption Key for a PDB

    •Creating and Activating an Encryption Key

    Tablespace Encryption by Default

    •Tablespace Encryption by Default in DBCS

    •Transparent Data Encryption (TDE) Overview

    •Components of TDE

    •Using TDE

    •Defining the Keystore Location

    •Controlling Tablespace Encryption by Default

    •Managing the Software Keystore and Master Encryption Key

    •Managing the Keystore in CDBs and PDBs

Schedule

If you are located outside Kolkata or would like to attend our session during your visit to Kolkata then please feel free to write us at palium.skills@gmail.com for any queries related to program,
upcoming schedule and fee. Call: +91-9051092035 or WhatsApp: +91-9051092035

Schedule for DBA Training in 2018 is as follows:
Month Dates No of Hours
January Completed
February Completed
March Completed
April Completed
May Completed
June Completed
July Completed
August 26th Aug (Fast-track) 30
September 4th - weekday, 23rd - fast-track 30
October TBA 30
November 4th - fast-track,6th - weekday 30
December 2nd - fast-track, 4th - weekday 30

Study Mode & Fees

Course/Certification Name Delivery Mode Fees Special Offers
Oracle DBA Administration 12c Classroom Rs. 10,000+ 18% GST best offers for 2+ enrollments
Oracle DBA Administration 12c Online Exam Rs. 11,000 + 18% GST Payable directly to Oracle, discounts available from time to time
Oracle DBA Administration 12c Fast-track Classroom training talk to us best offers available
Oracle DBA Administration 12c Online live trainer Rs. 10,000+ 18% GST best offers available for multiple enrollments

FAQs

The commonly asked questions pertaining to Oracle Pl-SQL training are -

Q: What are the pre-requisites for taking the DBA course?

A: Good knowledge of SQL Fundamentals is a must. Besides, if one were to get Oracle certified then the first exam is the SQL exam.

Q: Which version of Oracle Database will be covered?

A: The latest version of Oracle database is 12c which will be covered in the course. If 11g is required then the same can be arranged on request.

Q: Will this be theoretical or hands-on?

A: This is a complete hands-on training where the trainer will demonstrate each feature and participants will follow and do the same on the system.

Q: Will I get access to the database?

A: Yes, trainer will demonstrate how to access the instance.

Q: Will I incur any charges for accessing the application?

A: The standard features are available for free. There are some premium services for which charges maybe imposed by service provider.

Q: What if I have doubts after completing the class?

A: You can gather your doubts and come by prior appointment to get your doubts cleared.

Q: What help will I get for clearing the Certification Exam?

A: Our trainer is a Certified person and will provide guidance and tips for clearing the exam. Besides, you will get access to question bank for preparing for the exam

Q: Will I receive a certificate for the course?

A: Yes, participants receive a certificate after completing the course provided they have attended 90% of the class.

Get help now
CONTACT US +91-9051092035 (24×7)
WhatsApp +91-9051092035 (24×7)
Enquire Now

A Few Things You’ll Love!

  • Experienced Training Partner
  • Certified & Industry Experts Trainers
  • Multiple Training Delivery Models
  • Customized Course
  • 24/7 e-Learning Access
  • Assessments and Mock Tests
  • Placement Assistance

Palium Skills