(Click Category to List Courses)
38 - IT-D Information Technology - Databases and Related Technologies
IT-D 213 - Oracle - Administration Workshop I & II - Release 2 (10 Days)
| Code | Start Date | Duration | Venue | |
|---|---|---|---|---|
| IT-D 213 | 22 April 2024 | 10 Days | Istanbul | Registration Form Link |
| IT-D 213 | 27 May 2024 | 10 Days | Istanbul | Registration Form Link |
| IT-D 213 | 01 July 2024 | 10 Days | Istanbul | Registration Form Link |
| IT-D 213 | 05 August 2024 | 10 Days | Istanbul | Registration Form Link |
| IT-D 213 | 09 September 2024 | 10 Days | Istanbul | Registration Form Link |
| IT-D 213 | 14 October 2024 | 10 Days | Istanbul | Registration Form Link |
| IT-D 213 | 18 November 2024 | 10 Days | Istanbul | Registration Form Link |
| IT-D 213 | 23 December 2024 | 10 Days | Istanbul | Registration Form Link |
Please contact us for fees
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 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 learn how to secure the availability of database through appropriate backup and recovery strategies.
Course Objectives
- Installing Oracle Grid Infrastructure
- Installing and configuring Oracle Database
- Configuring Oracle Net services
- Monitoring and administering undo data
- Managing the database storage structures
- Creating and administer user accounts
- Describing Oracle Database Architecture
- 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
Who Should Attend?
- Database Administrators
- Technical Administrator
- Support Engineer
- Technical Consultant
- Java Developer
- Anyone who deal directly or indirectly with database systems
Course Details/Schedule
Day 1
- Installing your Oracle Software
- Creating an Oracle Database
- Managing the Oracle Database Instance
Day 2
- Configuring the Oracle Network Environment
- Manage the ASM Instance
- Managing Database Storage Structures
- Administering User Security
Day 3
- Managing Data Concurrency
- Managing Undo Data
- Implementing Oracle Database Auditing
Day 4
- Database Maintenance
- Performance Management
- Backup and Recovery Concepts
- Performing Database Backups
Day 5
- Performing Database Recovery
- Moving Data
- Exploring the Oracle Database Architecture
Day 6
- Core Concepts and Tools of the Oracle Database
- Configuring for Recoverability
- Using the RMAN Recovery Catalog
- Configuring Backup Settings
- Creating Backups with RMAN
Day 7
- Restore and Recovery Task
- Using RMAN to Perform Recovery
- onitoring and Tuning RMAN
- Diagnosing the Database
- Using Flashback Technology I
Day 8
- Using Flashback Technology II
- Performing Flashback Database
- Managing Memory
- Managing Database Performance
- Managing Performance by SQL Tuning
- Managing Resources
Day 9
- Configuring for Recoverability
- Using the RMAN Recovery Catalog
- Configuring Backup Settings
- Creating Backups with RMAN
- Restore and Recovery Task
- Using RMAN to Perform Recovery
- Monitoring and Tuning RMAN
- Core Concepts and Tools of the Oracle Database
Day 10
- 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
- Back the category
