National Training Institute LLC | Course Detail

National Training Institute (NTI) is a market leader in creating workplace competency. We provide vocational training and employment solutions to corporates in the Sultanate.

National Training Institute LLC
+968 24228600
info@ntioman.com
PO Box 267, Postal Code 115
Madinat Al Sultan Qaboos
Sultanate of Oman

Course Details

Oracle Database: Administration Workshop

Course Overview

This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition, you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

Data Warehouse Administrator Database Administrator Support Engineer Technical Administrator Technical Consultant

Oracle Database: SQL Workshop

Successful candidates will receive a certificate issued by National Training Institute LLC (NTI), attested by the Ministry of Higher Education

Other Details

Oracle Database Architecture
Introduction to Oracle Database Cloud Service Creating DBCS Database Deployments Accessing an Oracle Database
Managing DBCS Database Deployments
Managing Database Instances Understanding Oracle Net Services Administering User Security Creating PDBs
Creating Master Encryption Keys for PDBs
Creating and Managing Tablespaces
Managing Storage Space
Managing Undo Data Moving Data
Backup and Recovery Concepts
Backup and Recovery Configuration
Creating Database Backups
Performing Database Recovery
Monitoring and Tuning Database Performance
SQL Tuning
Miscellaneous

By the end of the module the candidate will be able to:

Describe Oracle Database architecture
Describe Oracle Database Cloud Service (DBCS) architecture and features
Create and manage DBCS database deployments
Configure the database to support your applications
Manage database security and implement auditing
Implement basic backup and recovery procedures
Move data between databases and files
Employ basic monitoring procedures and manage performance

Instructor-led training. Classroom Training