Oracle Database: Administration Workshop
Learn To
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.
Prerequisites
Audience
- Data Warehouse Administrator
- Database Administrator
- Database Designer
- Support Engineer
- Technical Administrator
- At Course Completion
Course Objectives
Upon completion of this course, the student should 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
Click here for explanations of the new certification OCP – Oracle Certified Professional.
- 1 Section
- 22 Lessons
- 10 Weeks
- MODULES22
- 1.1Introduction
- 1.2Oracle Database Architecture
- 1.3Introduction to Oracle Database Cloud Service
- 1.4Creating DBCS Database Deployments
- 1.5Accessing an Oracle Database
- 1.6Managing DBCS Database Deployments
- 1.7Managing Database Instances
- 1.8Understanding Oracle Net Services
- 1.9Administering User Security
- 1.10Creating PDBs
- 1.11Creating Master Encryption Keys for PDBs
- 1.12Creating and Managing Tablespaces
- 1.13Managing Storage Space
- 1.14Managing Undo Data
- 1.15Moving Data
- 1.16Backup and Recovery Concepts
- 1.17Backup and Recovery Configuration
- 1.18Creating Database Backups
- 1.19Performing Database Recovery
- 1.20Monitoring and Tuning Database Performance
- 1.21SQL Tuning
- 1.22Miscellaneous
Nicosia
Dates and Times
Class A:
1. Monday 07 April 8:00 - 15:30
2. Tuesday 08 April 8:00 - 15:30
3. Wednesday 09 April 8:00 - 15:30
4. Thursday 10 April 8:00 - 15:30
5. Friday 11 April 8:00 - 15:30
Duration (Hours)
35
Location
20 Louki Akrita street, 2064 Strovolos
(behind Kykko secondary schools)
Limassol
Dates and Times
Class A:
1. Monday 23 June 8:00 - 15:30
2. Tuesday 24 June 8:00 - 15:30
3. Wednesday 25 June 8:00 - 15:30
4. Thursday 02 July 8:00 - 15:30
5. Friday 03 July 8:00 - 15:30
Duration (Hours)
35
Location
22 Griva Digeni Avenue, 3106 Agios Nikolaos
(200 m. from the roundabout, near Agios Nikolaos church)
Please call us for the pricing scheme.
Duration:
35 Hours
Certification(s):
Exam(s):
Limassol (Lemesos)
22 Griva Digeni Avenue, 1st floor 3106 Agios Nikolaos
(200 m. from the roundabout, near Agios Nikolaos church)
Nicosia (Lefkosia)
(behind Kykko secondary schools)
