(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 09 October 2023 5 Days Istanbul Registration Form Link
IT-D 211 04 December 2023 5 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
  • 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