Oracle DBA Online Training

MKtrainings provides best Oracle DBA training with IT industry specialists. Our trainers are experienced certified trainers will share their experience, tips and tricks in the Oracle DBA training from india. This  Online course describes your responsibilities as a database administrator (DBA) who administers the Oracle database server. Oracle DBA training is offered to consultants, companies so that they can meet all the challenges in their respective technologies.

Highlights of Oracle DBA training:-

* Very in depth course material with Real Time Scenarios for each topic with its Solutions for Oracle DBA Online Trainings.

* We provide Case studies for Oracle DBA training.

* Sessions are scheduled based upon your comfort by our Highly Qualified Trainers and Real time Experts.

* We provide you with your recorded session for further Reference.

* Normal Track, Fast Track and Weekend Batches are also provided for Oracle DBA Training.

* We also provide Cost Effective and Flexible Payment Schemes

 

Oracle DBA Training Course Content

 

INTRODUCTION to Basic SQL and UNIX

Exploring the Oracle Database Architecture

  • List the major architectural components of Oracle Database
  • Explain the memory structures
  • Describe the background processes
  • Correlate the logical and physical storage structures
  • Describe ASM storage components

Installing Oracle Database Software

  • Describe database administrator (DBA) role, explain typical tasks and tools
  • Plan an Oracle software installation
  • Install Oracle database software

Creating an Oracle Database

  • Plan database creation
  • Create database & generate creation scripts using DBCA
  • Create database using SQL Plus
  • Understand database users & sample schemas

Managing the Database Instance

  • Managing database using Oracle Enterprise Manager & SQL*Plus
  • Commonly used Intialization Parameters
  • Manage database initialization parameters – SPFile & Pfile
  • Describe the stages of database startup
  • Start and stop the Oracle database and components
  • Viewing Alert log & manage Trace files
  • Understand Data Dictionary Views
  • Access dynamic performance views

Managing Database Storage Structures

  • Storage Structures
  • Segments, Extents & Oracle block
  • Describe the storage of table row data in blocks
  • Create and manage Tablespaces
  • Tablespaces and Datafiles
  • Oracle Managed Files (OMF)
  • Managing Temporary Tablespace

Administering User Security

  • Create and manage database user accounts:

– Authenticate users

– Assign default storage areas (tablespaces)

  • Grant and revoke privileges
  • Create and manage roles
  • Create and manage profiles

Managing Data Concurrency

  • Describe locking mechanism and how Oracle manages data concurrency
  • Monitor and resolve locking conflicts

Managing Undo Data

  • Explain DML and undo data generation
  • Monitor and administer undo data
  • Difference between undo data and redo data
  • Configure undo retention
  • Guarantee undo retention
  • Use the Undo Advisor

Configuring the Oracle Network Environment

  • Oracle Net Services
  • Configure Listener & Create Oracle Net Service aliases
  • Configure connect-time failover
  • Control the Oracle Net Listener
  • Use tnsping to test Oracle Net connectivity
  • Identify when to use shared servers and when to use dedicated servers
  • Configuring Communication between Databases
  • Connecting to another Database using DB Links

Backup and Recovery Concepts

  • Identify the types of failure that can occur in an Oracle database
  • Importance of checkpoints, redolog files, control files & archive log files
  • Understanding what is COLD & HOT backup
  • Configure ARCHIVELOG mode & Fast Recovery Area
  • Invoke and configure Recovery Manager (RMAN)
  • Specify Retention policy

Use of RMAN Recovery Catalog & Configuring Backup Settings

  • Usage of a Recovery Catalog over control file for the RMAN repository
  • Create and configure a recovery catalog
  • Register Database & Synchronize with recovery catalog
  • Use RMAN stored scripts
  • Enable control file autobackup
  • Configure backup destinations
  • Allocate channels for Disk & Tape destinations
  • Configure backup optimization
  • Create compressed & encrypted backups

Performing Database Backups with RMAN

  • Create consistent database backups (offline / cold)
  • Back up your database without shutting down (online / hot)
  • Create image file backups
  • Create a whole database backup
  • Create a full database backup
  • Enable fast incremental backup
  • Create duplex backup sets
  • Back up a backup set
  • Create RMAN multi-section backup
  • Create an archival backup for long-term retention
  • Monitor Backup jobs, Manage backups and view backup reports
  • Monitor the fast recovery area

Performing Database Recovery

  • Determine the need for performing recovery
  • Describe the causes of file loss and determine the appropriate action
  • Describe major recovery operations
  • Perform recovery:

– Control file

– Redo log file

– Data file

  • Perform complete recovery when a critical or noncritical data file is lost
  • Recover using incrementally updated backups
  • Switch to image copies for fast recovery
  • Recover using a backup control file

Moving Data

  • Describe ways to move data
  • Create and use directory objects
  • Use SQL*Loader to load data from a non-Oracle database (or user files)
  • Use external tables to move data via platform-independent files
  • Explain the general architecture of Oracle Data Pump
  • Use Data Pump Export and Import to move data between Oracle databases

Using Flashback Technology I

  • Describe Flashback technology
  • Perform Flashback Query
  • Use Flashback Version Query
  • Perform Flashback Table operations
  • Use Flashback Transaction Query

Using Flashback Technology II

  • Describe and use Oracle Total Recall

– Creating and Managing Flashback Data Archive (FDA)

  • Describe and use flashback recycle bins
  • Configure Flashback Database
  • Perform Flashback Database operations
  • Monitor Flashback Database

Implementing Oracle Database Auditing

  • Describe DBA responsibilities for security and auditing
  • Enable standard database auditing
  • Specify audit options
  • Review audit information
  • Maintain the audit trail

Database Maintenance

  • Optimizer overview
  • Manage optimizer statistics
  • Manage the Automatic Workload Repository (AWR)
  • Use the Automatic Database Diagnostic Monitor (ADDM)
  • Describe and use the advisory framework
  • Accessing & analyzing Active Session History data

Performance Management

  • Use performance-related dynamic view & EM to monitor performance
  • Managing Memory:

– Describe the memory components in the SGA

– Implement Automatic Memory Management

– Manually configure SGA parameters

– Configure automatic PGA memory management

  • Maintaining different types of Indexes
  • Managing Partition Tables

Managing Performance by SQL Tuning

  • SQL Tuning
  • Row chaining & migration
  • SQL trace, Tkprof, Explain plan
  • Use the SQL Tuning Advisor to:

– Identify SQL statements that are using the most resources

– Tune SQL statements that are using the most resources

  • Use the SQL Access Advisor to tune a workload

Diagnosing the Database

  • Detect and repair database corruption
  • Handle block corruption
  • Set up Automatic Diagnostic Repository (ADR) & Run health checks

Managing Space

  • Describe how the Oracle database server automatically manages space
  • Save space by using compression
  • Proactively monitor and manage tablespace space usage
  • Describe segment creation in the Oracle database
  • Control deferred segment creation
  • Use the Segment Advisor
  • Reclaim wasted space from tables and indexes by using segment shrink
  • Manage resumable space allocation

Managing Space for the Database

  • Use transportable tablespaces
  • Describe the concepts of transportable databases

Managing the ASM Instance

  • Describe the benefits of using ASM
  • Manage the ASM instance
  • Create and drop ASM disk groups
  • Extend ASM disk groups
  • Retrieve ASM metadata by using various utilities

Duplicating a Database / Cloning Database

  • List the purposes of creating a duplicate database
  • Choose a technique for duplicating a database
  • Duplicate a database with RMAN

Data Guard

  • Dataguard Architecture & background processes
  • Configuring & Managing Dataguard
  • Configuring Dataguard failover
  • Managing switchover

Database Patches & Database Upgrades

Introduction to Real Application Clusters

 

Keywords: 

Oracle DBA Online Training, Oracle DBA Training in India, Oracle DBA Training in Hyderabad, Oracle DBA Online Training Institute, Oracle DBA Online Training Videos, Oracle DBA Training Course, Oracle DBA Course Training Material, Oracle DBA Course Syllabus, Oracle DBA Interview Questions.

India|Philippines|New Zealand|US|UK|Canada|Australia|Germany|Switzerland

Hyderabad|Mumbai|Bangalore|Kolkata|New Delhi|Chennai|Kerala|Pune|Lucknow