(Click Category to List Courses)
38 - IT-D Information Technology - Databases and Related Technologies
IT-D 212 - Oracle - Administration Workshop II - Release 2
Code | Start Date | Duration | Venue | |
---|---|---|---|---|
IT-D 212 | 11 November 2024 | 5 Days | Istanbul | Registration Form Link |
IT-D 212 | 16 December 2024 | 5 Days | Istanbul | Registration Form Link |
Course Description
This course takes the database administrator beyond the basic tasks covered in the first workshop. Participants will begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery. In this course also, they will learn how to diagnose and repair data failures with Flashback technology, manage space to optimize database storage so they can respond to growing space requirements and monitor and manage major database components, including memory, performance and resources. Finally they will also learn how to secure the availability of their database through appropriate backup and recovery strategies and Automate DBA tasks with the Scheduler.
Course Objectives
- Learning how to use Oracle Secure Backup to backup and recover a database
- Learning how to use Oracle's Flashback technology to recover your database
- Detecting block corruptions and take appropriate measures to correct them
- Learning how to use the various database advisors and views to monitor
- Exploring control database resource usage with the Resource Manager
- Simplifying management tasks by using the Scheduler
- Reviewing database log files for diagnostic purposes
- Customizing language-dependent behavior for the database and individual sessions
- Administering a VLDB
- Implementing a secure database
- Transporting data across platforms
Who Should Attend?
- Database Administrators
- Sales Consultants
- Support Engineers
- Technical Consultants
- Anyone who deal directly or indirectly with database systems
Course Details/Schedule
Day 1
- Core Concepts and Tools of the Oracle Database
- Configuring for Recoverability
- Using the RMAN Recovery Catalog
- Configuring Backup Settings
- Creating Backups with RMAN
Day 2
- Restore and Recovery Task
- Using RMAN to Perform Recovery
- onitoring and Tuning RMAN
- Diagnosing the Database
- Using Flashback Technology I
Day 3
- Using Flashback Technology II
- Performing Flashback Database
- Managing Memory
- Managing Database Performance
- Managing Performance by SQL Tuning
- Managing Resources
Day 4
- Configuring for Recoverability
- Using the RMAN Recovery Catalog
- Configuring Backup Settings
- Creating Backups with RMAN
- Restore and Recovery Task
- Using RMAN to Perform Recovery
- onitoring and Tuning RMAN
- Core Concepts and Tools of the Oracle Database
Day 5
- Using Flashback Technology I
- Using Flashback Technology II
- Performing Flashback Database
- Managing Memory
- Managing Database Performance
- Managing Performance by SQL Tuning
- Managing Resources
- Diagnosing the Database