- acquire set of skills that are required to protect database against various failures and recovery of database as an expert DBA through hands-on labs.
- acquire set of skills that are required for working as an expert DBA through hands-on labs.
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.
- Database Administrators.
- Database Designers.
- Data Warehouse Administrators .
- Support Engineers.
- 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.
