NTUC LearningHub Course Code: NICF010
SSG Skillsconnect Code: CRS-Q-0027856-IT
This official Oracle Database 12c Administrator Certified Associate course was designed cover Oracle Database 12c: Install and Upgrade Workshop and the Oracle Database 12c: Administration Workshop contents over seven days. This course will teach students about the Oracle Database architecture and how to install Oracle Database 12c software, create a container database, provision pluggable databases, manage an Oracle Database instance, configure the Oracle Network Environment and perform database maintenance.
Oracle Database 12c introduces a new multitenant architecture that makes it easy to consolidate many databases quickly and manage them as a cloud service. Oracle Database 12c also includes in-memory data processing capabilities delivering breakthrough analytical performance. Becoming an Oracle Certified Database Expert can expand students’ database knowledge and give students an edge in a competitive IT marketplace. Oracle Database 12c Associate and Professional Certifications help DBAs develop the full skill set needed to perform day to day administration; get certified to design and implement backup and recovery strategies, while consolidating operations with pluggable and multitenant container databases.
After completing this course, students will be able to:
It is required that students have completed the Oracle Database: Introduction to SQL course or possess the following:
7 Days / 49 Hours
Oracle Database 12c Overview
Installing Oracle Grid Infrastructure for a Standalone Server
Installing Oracle Database Software
Creating an Oracle Database by Using DBCA
Oracle Restart Overview
Introduction to Upgrading to Oracle Database 12c
Preparing to Upgrade to Oracle Database 12c
Upgrading to Oracle Database 12c
Performing Post-Upgrade Tasks
Migrating Data by Using Oracle Data Pump
Exploring the Oracle Database Architecture
Managing the Database Instance
Configuring the Oracle Network Environment
Managing Database Storage Structures
Administering User Security
Managing Data Concurrency
Managing Undo Data
Implementing Oracle Database Auditing
Performing Database Maintenance
Managing Performance: SQL Tuning
Backup and Recovery Configuration
Managing Resources by Using Database Resource Manager
Automating Tasks by Using Oracle Scheduler
Backup and Recovery Concepts
Working with Oracle Support
Instructor-led Classroom Training with Hands-on Labs Practice.
Students will be required to complete a paper-based NICF assessment during class.
Awarded NICF Statement of Attainments (SOAs)
Upon completion of the course, students will also be awarded with these NICF SOAs:
1) IT-DM-303S-1 Identify and resolve common database performance problems
2) IT-DM-409S-1 Install and optimise system software
Terms and conditions apply. NTUC LearningHub reserve the right to make changes or improvements to any of the products described in this document without prior notice.
Prices are subject to other LHUB miscellaneous fees
This course is aligned to the National Infocomm Competency Framework (NICF) and accredited by SSG with Cat-B Funding (PME Level).
NTUC Union Members can enjoy up to 50% funding (capped at $250 per year) with Union Training Assistance Programme (UTAP). For more details on UTAP, click here