About Course - Oracle DBA
This course provides an exhaustive coverage of SQL, Database Administration and Database Backup & Recovery. Oracle DBA Certification course is valuable for Database Administrators, database designers, data warehouse administrators and support engineers.
Curriculum
- New Features in 11g
- New manageability features
- Use of Database Replay and Recovery Advisor
- RMAN Enhancements
- Use of Flashback and LogMiner
- Database Replay and Recovery Advisor
- Oracle SecureFiles
- SQL Performance Analyzer
- SQL Plan Management
- Automatic SQL Tuning
- Retrieval of Data using SQL Select Statement
- Restricting, Manipulating and Sorting Data
- Use of Single-Row Functions to Customize Output
- Conversion functions and Conditional Expressions
- DDL Statements to create and manage tables
- Creation of Schema Objects
- Aggregated Data using Group Functions
- Multiple Tables
- Exploring Oracle Database Architecture
- Preparing the Database Environment
- Creation of Oracle Database
- Management of Oracle Instance, Performance Management and Database Storage Structures
- Configuration of Oracle Network Environment
- Managing Data and Concurrency
- Administering User Security
- Database Maintenance
- Performance Management
- Database Backups and Recovery
- Intelligent Infrastructure Enhancements
- Moving Data
- Database Architecture and ASM
- Configuration for Recoverability and Backup Specifications
- Use of RMAN to Create Backups
- User-Managed Backup and Recovery
- RMAN to Perform Recovery
- Flashback Technology and Operations
- Management of Resources and Database Performance
- Space Management
- Automation of Tasks with the Scheduler