Mindmajix
For individuals


Self-Paced Learning

  • Learn at your own convenience
  • Access to high quality Videos
  • Self-paced learning content designed by Experts

Live Online Training

  • Interactive training
  • Certified & industry expert Trainers
  • Industry ready curriculum
  • Fast-track / Regular / Weekend


For business


Corporate training solutions

  • Blended learning delivery model ( self-paced e-learning and/or instructor-led options)
  • Course, category, and all-access pricing
  • Enterprise-class learning management system (LMS)
  • Enhanced reporting for individuals and teams
  • 24x7 teaching assistance and support

Course Details

Oracle DBA Training Overview

Our Oracle DBA training provides detailed coverage of core database concepts, the role and capabilities of the administrator and walks you through database configuration, administration, programming, performance tuning, backup and recovery, and high availability.

What you’ll learn

Oracle Database 12c core architectural foundations

How much overhead is reasonable

How to recognize when you’re doing too much work

How to predict bottlenecks and why they will happen ?

How to minimise contention and locking

Why concurrency can slow things down significantly

 

Oracle DBA 12c Training Curriculum

O

Relational Databases (RDBMS): Introduction

What is SQL?, Roles & Responsibilities of DBA

Oracle Architecture Process Architecture

Physical and Logical structures of Database

Types of files (Control file, Redo log file and Data file)

Different types of Data files Instance, SGA (System Global Area) and Background Process

Database Creation

Using Oracle Universal Installer

Installation Prerequisites

Setting Environment Variables

Installing the Oracle Database Software: Steps

Using the Database Configuration Assistant (DBCA)

Different Startup Modes

Different Shutdown Modes

Types of Database Creation

Introduction to Table space

Types of Table space

 

Tools for Configuring and Managing the Oracle Network

Using the Listener Control Utility

Connecting to an Oracle Database

Oracle Net: Naming Methods

Using Oracle Net Manager to Configure Local Naming

Tnsnames.ora

Network default location

Introduction to Database Links

Oracle Instance Management

Oracle Processes

Oracle Memory Structures

Starting the Instance and Opening the Database

Shutting Down an Oracle Database Instance

Viewing and Modifying Initialization Parameters

Managing Memory Components

Viewing the Alert Log

Oracle Database Structures

Exploring the Storage Structure of the Oracle Database

What are segments?

What are extents?

What is Blocks?

Dictionary Managed Table space

Locally Managed Table space

Storage Parameters (Initial, Next, Min Extents, Pct increase)

Managing Undo Data

Who are Database Users?

Why to create a User?

Creation of Users

Assigning Privileges

Creating and granting Roles

Assigning default table space for the Users

Setting Profiles for the Users

Levels of Authentication

What is spfile?

Difference between spfile and pfile

Advantages of spfile

Introduction to Redo log

Status of Redo logs

Multiplexing the Redo log files

Introduction/Multiplexing the Control file

What is a logical backup

Why is it required

Export/import Utility

Data Pump

Difference between Data Pump and Traditional Export/import

Managing the Oracle database –proactive checks

Understanding Software Management and Patch Releases

Patching Oracle Database Software

Using the Database Upgrade Assistant to Upgrade the Database

RMAN backup types

Creating and Using the RMAN backups

RMAN restore and recovery process

Purpose and Methods of Cloning a Database

Using RMAN to Create a Duplicate Database

Performance Monitoring

Managing Memory Components

Invalid and Unusable Objects

Automatic Workload Repository Baselines

V$ Views, Statistics and Metrics

Use the Enterprise Manager Support Workbench

Work with Oracle Support

Log service requests (SR)

Manage patches

Describe ways to move data

General architecture

Use Data Pump export and import to move data

Tools to data migrate

Introduction of Oracle ASM.

Introduction to Oracle RAC

Database Best Practices & Scripts

Oracle features

Faqs

Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Mindmajix verifies their technical background and expertise.

We record each LIVE class session you undergo through and we will share the recordings of each session/class.

Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and Oracle DBA 12c training by providing all the utilities required for the in-depth understanding of the course.

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

The Training itself is Real-time Project Oriented.

Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

There are some Group discounts available if the participants are more than 2.

As we are one of the leading providers of Online training, We have customers from USA, UK, Canada, Australia, UAE, Qatar, NZ, Singapore, Malaysia, India and other parts of the world. We are located in USA. Offering Online Training in Cities like

New York, New jersey, Dallas, Seattle, Baltimore, Houston, Minneapolis, Los Angeles, San Francisco, San Jose, San Diego, St. Louis, Jacksonville, Towson, Salt Lake City, Davidson, Murfreesboro, Alexandria, Sunnyvale, Santa clara, Carlsbad, San Marcos, Franklin,Tacoma, Bellevue, Austin, Garland, Raleigh-Cary, Boston, Orlando, Fort Lauderdale, Miami, Gilbert, Tempe, Chandler, Scottsdale, Peoria, Honolulu, Columbus, Raleigh, Nashville, Plano, Toronto, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Hyderabad, Bangalore, Pune, Mumbai, Delhi, Dubbai, Doha, Melbourne, Brisbane, Perth, Wellington, Auckland etc…

SEND A QUERY

Learning Resources

                                Oracle Database Administration Overview

The Oracle Database is the software to maintain the data coming from all sources in a clean, secured and efficient manner.

Oracle database is an object relational database management system (RDBMS). Database Administrator plays key role in efficiently administrating the databases. Database administrators (DBAs) use specialized software to store and organize data. Each database requires at least one database administrator (DBA) to administer it. Because an Oracle database system can be large and can have many users, often this is not a one person job. In such cases, there is a group of DBAs who share responsibility.

The Major responsibilities of Oracle DBA is to perform the capacity planning, installation, configuration, design of database, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery for creating and maintaining all databases. DBA also uses the SQL commands to invoke the capabilities and also to retrieve the information.

Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance of computerized databases in today’s organizations. The role also includes architecting, building and scaling databases for future data growth and capacity. They are also responsible for security, performance and availability of data to users and customers.

Course Reviews

4.5

1531 ratings
  • 51072
  • 4230
  • 3153
  • 261
  • 115

Drop Us A Query


Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.