Practical Oracle Database Administration Training Course
1Summary
Every decision a company makes eventually depends on data it can trust — internal expenses, external transactions, tenders, and the full archive of everything the company has ever done. When that data lives in a database no one manages properly, the company is one bad afternoon away from losing all of it.
That is why organizing and protecting this information has to be precise and disciplined, not left to chance.
The Arab British Fellowship Training Academy built this practical Oracle database administration course for anyone who needs to install, secure, back up, and keep an Oracle database running reliably inside a company or institution.
2Objectives and target group
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 able to:
- Build advanced knowledge of Oracle database administration and its core concepts (Oracle 12C).
- Configure Data Guard and install it across its different deployment types.
- Apply ASM (Automatic Storage Management) knowledge and configuration.
- Run backups in an Oracle database and handle different real-time recovery scenarios.
- Apply the basics of performance tuning, RAC, and high availability.
- Install and administer Oracle 18C databases, with new topics added as demand evolves.
3Course Content
The training course covers the following topics:
- Module 1: Foundations of Oracle Database Installation and Setup
- Oracle 12C/18C download, prerequisites, and installation on Windows Server
- Connecting to Enterprise Manager (EM) Express
- Oracle 12C administration basics
- Module 2: Core Day-to-Day DBA Operations
- Opening the GUI in a Putty session, and setting ORACLE_HOME and ORACLE_SID
- Creating and deleting Oracle services with the Oradim utility
- Starting and stopping the database, and renaming datafiles in Oracle 11G
- Changing the DBID and the database name
- Module 3: Working with Pluggable (Multitenant) Databases
- Creating non-container and pluggable databases, via DBCA and manually
- Starting, stopping, renaming, and dropping pluggable databases
- Backing up container and pluggable databases
- Module 4: Data Guard for High Availability
- Checking primary/standby synchronization in Data Guard
- Snapshot standby databases: introduction and conversion in both directions
- Switchover operations in Oracle Data Guard
- Module 5: Backup Strategies and Operational Monitoring
- RMAN backups and logical backups
- Monitoring tools for database health
- Basic understanding of ITIL processes in DBA work