(Click Category to List Courses)

37 - 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 Fees
IT-D 213 28 November 2020 10 Days Istanbul $ 7900 Registration Form Link
IT-D 213 26 December 2020 10 Days Istanbul $ 7900 Registration Form Link
IT-D 213 23 January 2021 10 Days Istanbul $ 7900 Registration Form Link
IT-D 213 20 February 2021 10 Days Istanbul $ 7900 Registration Form Link
IT-D 213 20 March 2021 10 Days Istanbul $ 7900 Registration Form Link
IT-D 213 17 April 2021 10 Days Istanbul $ 7900 Registration Form Link
IT-D 213 12 June 2021 10 Days Istanbul $ 7900 Registration Form Link
IT-D 213 10 July 2021 10 Days Istanbul $ 7900 Registration Form Link
IT-D 213 07 August 2021 10 Days Istanbul $ 7900 Registration Form Link
IT-D 213 04 September 2021 10 Days Istanbul $ 7900 Registration Form Link
IT-D 213 02 October 2021 10 Days Istanbul $ 7900 Registration Form Link
IT-D 213 27 November 2021 10 Days Istanbul $ 7900 Registration Form Link
IT-D 213 25 December 2021 10 Days Istanbul $ 7900 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
  • 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