Oracle DBA Database Administrator Online Beginner level by Three Spear

1. Introduction to IT & Databases
Overview of IT and Current IT
Trends What is Database?
Why Database?
Types of Databases
Major Databases and Database Vendors
Database Market Share and Trends
Factors influencing Database Choice
Getting ready to adopt and support Database
2. Roles and Responsibilities of DBA
Traditional Roles and Responsibilities of DBA
The changing role of DBA
Emergence of DBA 2.0
The Enterprise DBA
3. Oracle Database Architecture
Database, Instance
Memory Structures Database Buffer
Cache, Redo Log Buffer, Shared Pool
Process Structures DBWn ,LGWR,
CKPT, SMON, PMON, RECO, ARCn
Physical & Logical Structures
4. Installing Oracle Database Server Software
Identifying Database Releases
System Requirements for Installation
Optimal Flexible Architecture (OFA)
Setting Environment Variables
Oracle Universal Installer (OUI)
Installing Oracle Software
5. Creating Oracle Database
Planning the Database Creating
Database using DBCA
Configuring Database Listener
Exploring the seed database and Sample
6. Managing Oracle Instance
Initialization Parameters
Managing Initialization Parameters -
Static and Dynamic parameters, PFILE,
SPFILE, Managing Database Startup and
Shutdown, Automatic Diagnostic Repository
(ADR) , Alert Log and Trace Files
Understanding Data Dictionary Views
Dynamic Performance Views
7. Managing Data Files & Tablespaces
Table space and Data Files
Creating Table spaces
Altering Table spaces
Dropping Table spaces
Viewing Table space Information
8. User Administration
Database User Accounts, Predefined
Accounts, Creating Users, User
Authentication Managing Privileges,
Managing Roles and Profiles
tnsnames.ora, listener.ora, Configuring
Listener, Naming methods, Using NETCA
Oracle 11g Easy Connect Method,
Establishing Database Connectivity from
Oracle Database Clients
9. Managing Undo Data
Transactions and Undo Data
Undo Vs Redo
Managing Undo data
Configuring Undo Retention
10. Managing Temporary Tablespaces
Temporary Table space Concepts
Creating Temporary Tablespaces
Temporary Table space Groups
Managing Table space Groups
11. Managing Control Files
Understanding Control Files, Multiplexing
Control Files, Re-creating Control Files,
Backing up Control Files
12. Managing Online Redo Log & Archived Log Files
Understanding Online and Archived Redo
Log Files, Configuring Database Archive
mode, Managing Online Redo Log Files
13. Configuring Oracle Network
Oracle Net Services, sqlnet.ora,
Schemas
14. Backup and Recovery
Backup and Recovery Concepts
Instance Recovery, Media Recovery
Concepts of User Managed Backups
Backup and Recovery using RMAN
RMAN Concepts, Recovery Catalog,
Retention Policies, Full & Incremental
Backups, Image Copy and Backup Set
backups, Hot and Cold backups using
RMAN, Complete and In- complete
backups using RMAN, Performing
Recovery using RMAN, Concepts of Tape
backups, Oracle Secure Backup (OSB)
15. Oracle Database Utilities
Oracle Data Pump Utility
Concepts of Logical backups
Data Pump Exports and Imports
Taking Logical backups with Data Pump
Exports and Imports
SQL*Loader Utility
Loading external data using SQL*Loader
ADRCI Utility, Concepts of ADRCI
Using ADRCI to view Diagnostic Data
DBVERIFY Utility, Performing integrity
checks using DBVERIFY
ORAPWD Utility, Creating Password file
using ORAPWD, Using Password file
Authentication
DBNEWID Utility, Changing DBID and
DBNAME using DBNEWID
16. Database Security
Security Overview
Security Requirements
Database Security
Protecting Privileged Accounts
Security Updates and Patches

17. Database Cloning & Refresh
Cloning Concepts and Considerations
Cloning Techniques
Performing Database Cloning
Performing Database Refreshing
18. DBA+
User Managed Backups & Recovery
Transportable Tablespaces
Creating Database using Manual
Procedures, Dropping Database
19. Real Time Concepts
Database Life Cycle
Database Environments
Development, QA and Production
Environments, DBA Responsibilities
Project Execution Models - Onsite,
Offsite, Offshore , Onsite-Offshore
Models, U.S Context and India Context,
Executing a DBA Support project,
SLAs, Understanding IT Infrastructure
Library (ITIL) Concepts, Automating
routine DBA tasks and importance of
Automation in DBA Projects
Troubleshooting Performance Issues