Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance of computerized databases in today’s organizations. The role also includes architecting, building and scaling databases for future data growth and capacity. They are also responsible for security, performance and availability of data to users and customers.
Length : 70 Hours
Introduction to DBA Tasks
Oracle Architectural Components
Settings Stated with the Oracle Server
Managing an Oracle Instance
Creating a Database
Using Data Dictionary and Dynamic
Performance Views
Maintaining redo Log Files
Managing Table Spaces & Data Files
Storage Structures & Relationships
Managing undo Data
Managing Tables
Managing Indexes
Managing Data Integrity
Managing Password Security & Resources
Managing Users
Managing Privileges
Managing Roles
Auditing
Loading Data into a Database
Using Globalization Support Basic Oracle Net Server Side
Configurations
Naming Method Configuration
Usage & Configuration of the Oracle Shared Server
Backup & Recovery Overview
Instance & Media Recovery Structures
Configuring the Database Archiving Mode
Oracle Recovery Manager Overviews & Configuration
User-Managed Backups
Rman Complete Recovery
Rman In-Complete Recovery
Rman Maintenance
Recovery Catalog Creating & Maintenance
Transporting Data between Databases