Abu Dhabi Barcelona Dubai Istanbul
training@gkpms.com
Back
Oracle Database Administration

Oracle Database Administration

Quick Enquiry Call Me Back

Overview

Course Outline

Schedule & Fees

Overview
Why Attend

Databases represent a set of information that includes everything related to the company in full details of internal expenses, external financial transactions, transactions and tenders held during a specified period of time in addition to a full archive of all that has been achieved since the establishment of the company. 

These rules link the information and make the administrative work and analysis of the general position of the company is easy so the organization of such data must be very precise and strict. 

This course provides a training course in ORACEL database administration in the department to anyone who wants to learn advanced and modern methods of managing databases within companies or institutions. 

Course Objectives

By the end of the course, participants will be able to:

Who should attend? 

  • Managers and directors of companies. 
  • Managers of administrative departments in companies. 
  • Managers of data collection and storage departments within companies. 
  • Employees in data management departments within institutions and companies. 
  • All employees within the administrative technological work sector. 
  • All employees within the computer software business sector. 
  • Students and academics who wish to develop their capacity to create databases. 

 

How attendees will benefit? 

After completion of the Training Programme, delegates will be learned to: 

  • Advance Knowledge on Oracle Database-Administration 
  • Oracle 12C basic concepts 
  • Data guard configuration and there different type installation 
  • ASM knowledge and configuration part 
  • Backup in Oracle database 
  • Different recovery real time scenarios 
  • Performance Tuning Basics 
  • Basics of RAC and High Availability 
  • Oracle 18C database Installation and Administration 
  • New trending topics will be added soon based on demand also 
Course Outline
  • Core DBA 
    • How to open GUI in putty session 
    • Create,Delete Oracle Services using Oradim Utility 
    • How to Set Environment in Oracle Windows Server- Set ORACLE_HOME & ORACLE_SID 
    • How to start,stop database. 
    • How to change DBID in oracle 
    • How to change DB Name in Oracle 
    • How to rename datafile in Oracle 11G 

 

  • RAC (Real application cluster) 
    • How to create Non-Container Database-Oralcle 12C Administration 
    • Create Pluggable database using DBCA-Oracle 12C Administration 
    • How to create Pluggable database Manually-Oracle 12C database administration 
    • How to start/stop/Basic of Pluggable database-Oracle 12C administration 
    • How to Rename Pluggable Database-Oracle 12C Administration 
    • How to Drop Pluggable database - Oracle 12C Administration 
    • How to take backup of container-pluggable database 

 

  • Dataguard 
    • Check if Primary database is in Sync with Standby in Dataguard 
    • Snapshot Standby Database Introduction 
    • How to convert Physical standby database to Snapshot Standby Database 
    • How to convert SnapShot to Physical Standby database 
    • Swichover introduction in Oracle Dataguard 

 

  • ASM (Automatic Storage management) 
    • Oracle 12C Administration 
    • Oracle 12C download and Prerequisite 
    • Installation of Oracle 18C database on Windows Server 
    • How to connect to EM(Enterprise manager) Express with Oracle 12C database 

 

  • RMAN Backups 
  • Logical Backups 
  • Monitoring Tools  
  • Basic understanding of ITIL Process 
Schedule & Fees
2026 Schedule & Fees
USD 3,500
Per participant
  • 25 - 29 Oct, 2026
  • English
USD 3,500
Per participant
  • 25 - 29 Oct, 2026
  • Arabic
USD 3,500
Per participant
  • 29 Nov - 3 Dec, 2026
  • English
USD 3,500
Per participant
  • 29 Nov - 3 Dec, 2026
  • Arabic
2027 Schedule & Fees
USD 3,500
Per participant
  • 24 - 28 Jan, 2027
  • English
USD 3,500
Per participant
  • 24 - 28 Jan, 2027
  • Arabic
USD 3,500
Per participant
  • 28 Feb - 4 Mar, 2027
  • English
USD 3,500
Per participant
  • 28 Feb - 4 Mar, 2027
  • Arabic
USD 3,500
Per participant
  • 25 - 29 Apr, 2027
  • English
USD 3,500
Per participant
  • 25 - 29 Apr, 2027
  • Arabic
USD 3,500
Per participant
  • 30 May - 3 Jun, 2027
  • English
USD 3,500
Per participant
  • 30 May - 3 Jun, 2027
  • Arabic
USD 3,500
Per participant
  • 25 - 29 Jul, 2027
  • English
USD 3,500
Per participant
  • 25 - 29 Jul, 2027
  • Arabic
USD 3,500
Per participant
  • 29 Aug - 2 Sep, 2027
  • English
USD 3,500
Per participant
  • 29 Aug - 2 Sep, 2027
  • Arabic
USD 3,500
Per participant
  • 24 - 28 Oct, 2027
  • English
USD 3,500
Per participant
  • 24 - 28 Oct, 2027
  • Arabic
USD 3,500
Per participant
  • 28 Nov - 2 Dec, 2027
  • English
USD 3,500
Per participant
  • 28 Nov - 2 Dec, 2027
  • Arabic