Oracle DBA

  • ID: 58
  • 40 Hrs

Who Should attend

From first timers in IT to Professionals in IT, anyone interested in learning database administration.

Course Description

A database administrator (DBA) directs or performs all activities related to maintaining a successful database environment. Responsibilities include designing, implementing, and maintaining the database system; establishing policies and procedures pertaining to the management, security, maintenance, and use of the database management system; and training employees in database management and use. A DBA is expected to stay abreast of emerging technologies and new design approaches.

Course Content

  • Architecture
    • Defining an Oracle Server
    • Database
    • Instance
    • Understanding Physical Structure
    • Memory Structure
    • Process Structure
    • Logical Structure
    • Execution of SQL Stataments
  • Creating a New Database
    • Identifying the application and the no. of applications the Database will support
    • Understanding TS
    • Changing Initialization parameters
    • Processes
    • TS Naming Conventions
    • Block Sizes
    • Types of DataBase
    • Dropping a Database
    • ASM Database
    • Sysaux
    • Tablespace
    • Default Tablespace
  • Managing an Oracle Database
    • Creating and Managing Initialization files
    • Identifying the varios states/options of Instance Startup/Shutdown
    • DB Mount/Open stages
    • Monitoring Alert and Trace Files for DB Troubleshooting Result Cache
    • Configuring System Global Area (SGA)
    • Understanding Background Processes
  • Managing Tablespace and Datafiles
    • Creating and Altering Tablespaces
    • Adding
    • Resizing
    • Renaming a Datafile
    • Renaming a Tablespace
    • Tablespace
    • Creating and Managing a Tablespace when using OMF
    • Advantages of OMF feature
    • Extent Management
    • Big File Tablespace
    • Temporary Tablespace Group
  • Storage Management
    • Creating
    • Maintaining tables using appropriate storage settings
    • Obtaining Tablespace Information
    • Listing different tyes of Indexes and their uses
    • Creating B-Tree and Bitmap Indexes
    • Maintaining Indexes
    • Identifying unused Indexes
    • Obtaining Index Information
  • User Management
    • Creating user’s
    • Managing resources with profiles
    • User Authentication
    • Managing user privileges
    • Schema management
    • Security
    • Creating and Managing Role
  • Managing Export’s & Import’s
    • Main Tasks of Exports and Imports
    • Incremental, Cumulative and Complete Export and Import
    • Points to remember before doing export and import
  • Oracle Data Pump
    • Introduction
    • Benefits of Data Pump Emport and Import
    • Data Pump Export and Import modes
    • Transport of Tablespace across different platform’s
    • TTS for a single Partition
  • Managing Undo Segments
    • Understanding Oracle Undo Segments
    • Retention Policy
    • Retention Guarantee/Noguarantee
    • Switching Undo Tablespaces
  • Maintaining the Control File,Redo Log File and Archive Log Files
    • Importance
    • Role
    • Sizing
    • Contents
    • Multiplexing and Backing up of the Control File
    • Controlling log switches and checkpoints
    • Multiplexing and Archiving online redo log files
  • Backup and Recovery
    • Defining Backup and Recovery Strategies
    • Describing the basics of DB Backup
    • Restore and Recovery
    • Listing the types of Failures that may occur in Oracle Environment
    • Instance and Media Recovery Structures
    • Memory Structures and Files related to Recovery
    • Identifying the Importance of Checkpoints
    • Redo Log Files
    • Archieved Lof Files
    • User Managed Backups and Recoveries
    • Closed and Open DB Backups
    • Complete Recovery
    • Identirying the situations which require Incomplete Recovery from loss of Online Redo Logs
    • Creating Clone DBs
    • Oracle Recovery Manager (RMAN)
    • Repository
    • Channel Allocation
    • Configuring RMAN Environment
    • Complete and Incomplete Recovery and Full/Incremental Compressed backups
    • Incremental backups with block change tracking
    • RMAN compressed backup

Career Path

Oracle DBA is a leading and demanding skill-sets in IT as well highly paid jobs since the role needs to be handling the backbone of organization’s vital data management at large scale.

Schedules

Id Date Session Time Location
* Above schedule may change due to unavoidable reasons