DURATION: 5 days (40 hours)
COURSE INTRODUCTION
The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner.
COURSE OBJECTIVE
After finish the course, student will have knowledge and skills to:
- Back up, restore, and patch DBCS database deployments
- Describe the DBaaS and on-premises Oracle Database architectures
- Manage database instances
- Manage UNDO data
- Move data between databases
- Implement basic backup and recovery procedures
- Monitor and tune database performance
- Tune SQL to improve performance
- Manage resources with Oracle Database Resource Manager
- Create pluggable databases (PDBs)
- Configure the Oracle network environment
- Administer user security and implement auditing
- Create and manage tablespaces
- Manage storage space
- Create and manage Database as a Cloud Service (DBCS) database deployments
- Register databases and manage performance with Enterprise Manager Cloud Control
AUDIENCE
- Data Warehouse Administrator
- Database Administrators
- Database Designers
- Support Engineer
- Technical Administrator
PREREQUISITES
- A working knowledge of SQL and PL/SQL packages is very helpful in the course.
RELATED COURSES
- Oracle Database 12c R2: Install and Upgrade Workshop
- Oracle Database 12c R2: Backup and Recovery Workshop Ed 3
COMPLETION CERTIFICATE
After finish the course, student will receive completion certificate issued by SmartPro.
COURSE CONTENT
.png)
