Courses | SVS Online Training
Untitled Document

+91 8125490399

DBA Course Contents

Introduction of Oracle Database Administration.

  • 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

Managing The Oracle Instance

  • 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

Configuring The Oracle Network Environment

  • 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

Managing The Oracle Instance

  • 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

Storage Parameters

  • 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

User Management

  • 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

SPFile & PFile Managment

  • What is spfile?
  • Difference between spfile and pfile
  • Advantages of spfile

Redo-Log & Control File Management

  • Introduction to Redo log
  • Status of Redo logs
  • Multiplexing the Redo log files
  • Introduction/Multiplexing the Control file

Logical Backup/Restore

  • What is a logical backup
  • Why is it required
  • Export/import Utility
  • Data Pump
  • Difference between Data Pump and Traditional Export/import

Managing Oracle Database & Software

  • 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

Creating Backups With RMAN

  • RMAN backup types
  • Creating and Using the RMAN backups
  • RMAN restore and recovery process

RMAN - Duplicating A Database

  • Purpose and Methods of Cloning a Database
  • Using RMAN to Create a Duplicate Database

Performance Management

  • Performance Monitoring
  • Managing Memory Components
  • Invalid and Unusable Objects
  • Automatic Workload Repository Baselines
  • V$ Views, Statistics and Metrics

Working With Oracle Support

  • Use the Enterprise Manager Support Workbench
  • Work with Oracle Support
  • Log service requests (SR)
  • Manage patches

Moving Data / Data Migrations

  • Describe ways to move data
  • General architecture
  • Use Data Pump export and import to move data
  • Tools to data migrate

Introduction To ASM & RAC

  • Introduction of Oracle ASM.
  • Introduction to Oracle RAC

Untitled Document

Our Happy clients

Follow Us

Contact Us

Head Office


Phone:+91 8125490399,