(Click Category to List Courses)

38 - 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
IT-D 213 26 September 2022 10 Days Istanbul Registration Form Link
IT-D 213 21 November 2022 10 Days Istanbul Registration Form Link
IT-D 213 12 December 2022 10 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
  • 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