Oracle Database 12c: Administration

Sorry, JavaScript required!
Title Oracle Database 12c: Administration
Course code CM556.2-10-2019-C
Objective DB operators and junior DBAs will learn all the basic skills required in their jobs, including installing an Oracle server and creating, backing up and recovering Oracle databases. This course will teach Oracle in Linux.
  • Introduction Oracle Database Administration and 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
  • Managing Performance: SQL Tuning
  • Managing Resources by Using Database Resource Manager
  • Automating Tasks by Using Oracle Scheduler
  • Managing Space
  • Backup and Recovery Concepts
  • Moving Data
  • Working with Oracle Support
  • Oracle Database Cloud Service: Overview
  • The average mark for all the written tests is at least 60.
  • The average mark for all the lab assignments (or lab tests) is at least 60.
Target audience
  • Database operators
  • Junior database administrators
Prerequisite Familiar with Oracle SQL or completed course Oracle Database: Introduction to SQL
Familiar with Linux basic operation
Could read Engligh materials
Please check the self-assessment
Class size 18
Instructor Microsoft certified Trainer(MCT), Oracle Certifited Professional (OCP), a result-driven IT professional experienced in hardware & network troubleshooting. Certified in MCITP,CCNA, Oracle OCP and ITIL v3 qualification. Has been teaching for CPTTM since 2004.
Instruction language Cantonese (supplemented with English)
Handout language English
  • LECTURE: 42 hours in 14 sessions
  • LAST SESSION: 3 hours in 1 sessions
  • Total: 45 hours in 15 sessions
  • LECTURE: 19:00-22:00, from Oct 29, 2019 to Dec 13, 2019 every Tuesday, Friday.
  • LAST SESSION: 19:00-22:00, Dec 17, 2019 (Tuesday).
Fee MOP2,500
Other fees Electronic Training Materials: MOP1,300.
Venue Cyber-Lab (Rua Comandante Mata Oliveira, Ed. Associacao Industrial, 3-andar Macau)
Certificate Certificate of Completion/Merit issued by CPTTM (with at least 80% attendance and passed the assessment).
PDAC code Approved Course under the SAR Government "Continuing Education Development Program", Code: 1904320459-0
Sorry, JavaScript required!