Oracle DBA 12C Training

 

Go Training’s offers the best Oracle DBA 12c Online Training Course is designed by IT Professionals with the IT Industry Specialists as our trainers are experienced and certified trainers. They share their experience, tips and tricks in the Oracle DBA 12c Online Training course. We are also delighted to be one of the best leading IT online training with best experienced IT professionals and skilled resources. We have been offering courses to consultants, companies so that they can meet all the challenges in their respective technologies.

Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system produced and marketed by Oracle Corporation.

 

 

 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

 

Contact for more details on Oracle DBA Online Training +91 9063320459 

 

 

Keywords:

 

Oracle DBA Training,Oracle DBA Training From India ,Oracle DBA Training From Hyderabad,Oracle DBA Online Training Institute,Oracle DBA Online Training Videos,Oracle DBA Online Training Course,Oracle DBA Course Training Material, Oracle DBA Online Training by Real time Trainers,Oracle DBA Online Training by Real Time Support, Best online training Oracle DBA site from India.