Database administrators will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database, allocate resources with the Resource Manager and Schedule jobs.
The delegate will practise:
Who will the Course Benefit?
This Oracle Database 12c Administration course is for anyone who needs to administer, monitor and support an Oracle 12c database.
This Oracle Database 12c Administration course is designed to give database administrators the knowledge and skills needed to maintain successful and efficient day-to-day operations of an Oracle 12c database. The Oracle Database 12c administrator will gain practical experience in administering and monitoring an Oracle 12c database.
Together with the Oracle Database 12c Installation and Upgrade course, the Oracle Database 12c Administration course is suitable for delegates intending to sit the #1Z0-062 - Oracle Database 12c: Installation and Administration examination.
Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.
Exams are not included as part of the course.
Delegates who wish to attend the Oracle Database 12c Administration course should have an understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. Knowledge of the usage of PL/SQL packages is highly recommended.
NOTE: Course technical content is subject to change without notice.
Course Contents - DAY 1
Session 1: INTRODUCTION TO ORACLE DATABASE 12c
Session 2: ORACLE DATABASE 12c ARCHITECTURE
Session 3: ADMINISTER A DATABASE INSTANCE
Session 4: CONFIGURE THE ORACLE NETWORK ENVIRONMENT
Session 5: STORAGE STRUCTURES
Course Contents - DAY 2
Session 6: MANAGE USERS
Session 7: MANAGE PROFILES AND RESOURCES
Session 8: MANAGE PRIVILEGES
Session 9: DATABASE AUDITING
Course Contents - DAY 3
Session 10: DATA CONCURRENCY AND LOCK CONFLICTS
Session 11: UNDO MANAGEMENT
Session 12: PROACTIVE DATABASE MAINTENANCE
Session 13: PERFORMANCE MANAGEMENT
Course Contents - DAY 4
Session 14: SQL TUNING
Session 15: MOVING DATA
Session 16: AUTOMATE TASKS WITH THE SCHEDULER
Course Contents - DAY 5
Session 17: MANAGING RESOURCES WITH RESOURCE MANAGER
Session 18: MANAGE SPACE
Session 19: BACKUP AND RECOVERY CONFIGURATION
Session 20: ORACLE SUPPORT
|Course Duration||5 Days|