(Click Category to List Courses)
38 - IT-D Information Technology - Databases and Related Technologies
IT-D 211 - Oracle - Administration Workshop I - Release 2
Code | Start Date | Duration | Venue | |
---|---|---|---|---|
IT-D 211 | 04 November 2024 | 5 Days | Istanbul | Registration Form Link |
IT-D 211 | 09 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 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
- Performing basic backup and recovery of a database
- Managing data concurrency
- Monitoring performance
- Describing Oracle Database Architecture
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
- Manage the ASM Instance
- Configuring the Oracle Network Environment
- 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