Oracle DBA Training
Oracle Database Administrator (Oracle DBA) Training brings the best practices involved to install, configure, upgrade, administer, monitor, maintain, and secure Oracle databases in an organization.
Oracle DBA Training Curriculum
Overview 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
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
Miscellaneous
Database Best Practices & Scripts
Oracle features.