Mindmajix
For individuals


Recorded Video Learning

  • Access to high quality Videos
  • Self-paced learning content designed by Experts

Instructor Led Live Online Training

  • Live Interactive training
  • Certified & industry expert Trainers
  • On Demand Dedicated Cloud lab access
  • 24x7 Support & Assistance
  • Fast-track / Regular / Weekend


  • Start training at your convenient time
  • For business


    Corporate training

    • 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 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

    Minneapolis, Melbourne, Jacksonville, Davidson, Murfreesboro, Auckland, Carlsbad,  San Marcos, Tacoma, Bellevue, Garland, Raleigh-Cary, Fort Lauderdale, Miami, Toronto, Wellington, Gilbert, Tempe, Alexandria, Chandler, Scottsdale, Peoria, Honolulu, Raleigh, Nashville, Plano, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Hyderabad, Bangalore, Pune, Mumbai, Delhi, Dubai, Doha, Brisbane, Perth 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.