|
Oracle DBA Workshop
Duration: 30 hrs
Introduction
Introduction to SQL
DBA scripting
Architecture
Installing and configuring Oracle Software
Create and configure Oracle Database
Understand Oracle Architecture - Physical and Logical
Database Creation
Management
Managing INIT parameters
Managing INITSID.ora and SPFILESID.ora
Managing control files
Managing redo log files
Managing Tablespaces and data files
Managing Undo
Security
Create/Drop/Alter Users
Create/Drop/Alter Roles
Create/Drop/Alter Profiles
Backup and Recovery
Understanding RMAN
Backup and Recovery using 10g Database Control
Backup recovery using RMAN
EXPDP, IMPDP - data transportation
Performance Tuning
Understanding Oracle Tuning
ASMM, AWR, ADDM
Using 10g database control for Tuning
EXPLAN PLAN Query
Advance DBA concepts
ASM
Data guard
RAC
Grid Control
Exclusive
Introduction to UNIX for Oracle DBA
Introduction to 11g New Features
Introduction to TOAD for managing databases
Interview Questions
Sample Resumes
|
