TRAINING CATEGORIES
(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 22 April 2024 5 Days Istanbul Registration Form Link
IT-D 211 13 May 2024 5 Days Istanbul Registration Form Link
IT-D 211 10 June 2024 5 Days Istanbul Registration Form Link
IT-D 211 22 July 2024 5 Days Istanbul Registration Form Link
IT-D 211 26 August 2024 5 Days Istanbul Registration Form Link
IT-D 211 30 September 2024 5 Days Istanbul Registration Form Link
IT-D 211 04 November 2024 5 Days Istanbul Registration Form Link
IT-D 211 09 December 2024 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