The Oracle Database 18c: Administration Workshop training course will give you a detailed overview of the architecture of an Oracle Database instance and database which will help you in the effective management of the database resources. During the training you will cover in details the topics like database storage structures, create users and administer database security, basic information on backup and recovery techniques, monitor database and manage performance etc.
Who should do Oracle Database 18c: Administration Workshop training?
1.Data Warehouse Administrator
2.Database Administrators
3.Database Designers
4.Support Engineer
5.Technical Administrator
Course Prerequisites
1.Practical knowledge of SQL & PL/SQL packages
2.Fundamental understanding of Linux OS will be helpful though not mandatory
On completion of this training, you will know:
1.Understand Oracle Database architecture
2.Understand and know Oracle Database Cloud Service (DBCS) architecture and features
3.Creating & managing DBCS database deployments
4.Configuring the database to support the applications
5.Managing database security & implement auditing
6.Implementing basic backup and recovery procedures
7.Moving data between databases and files
8.Employing basic monitoring procedures and managing performance
Module 1: Introduction
Module 2: Oracle Database Architecture
Module 3: Introdction to Oracle Database Cloud
Module 4: Creating Oracle Database Cloud Service (DBCS) Deployments
Module 5: Accessing an Oracle Database
Module 6: Managing DBCS Database Deployments
Module 7: Managing Database Instances
Module 8: Oracle Net Services
Module 9: Administering User Security
Module 10: Creating PDBs
Module 11: Creating Master Encryption Keys for PDBs
Module 12: Creating and Managing Tablespaces
Module 13: Managing Storage Space
Module 14: Managing Undo Data
Module 15: Moving Data
Module 16: Backup and Recovery Concepts
Module 17: Backup and Recovery Configuration
Module 18: Creating Database Backups
Module 19: Performing Database Recovery
Module 20: Monitoring and Tuning Database Performance
Module 21: SQL Tuning