(Click Category to List Courses)

37 - IT-D Information Technology - Databases and Related Technologies


IT-D 211 - Oracle - Administration Workshop I - Release 2

Code Start Date Duration Venue Fees
IT-D 211 12 December 2020 5 Days Istanbul $ 3950 Registration Form Link
IT-D 211 09 January 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 211 06 February 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 211 06 March 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 211 03 April 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 211 01 May 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 211 26 June 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 211 24 July 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 211 21 August 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 211 18 September 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 211 16 October 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 211 13 November 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 211 11 December 2021 5 Days Istanbul $ 3950 Registration Form Link
DOWNLOAD PDF

 

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