Oracle Database 12c: Administration

{{col1}}
{{col0}}
Sorry, JavaScript required!
Title Oracle Database 12c: Administration
Course code CM556.2-11-2020-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.
Content
  • 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
Assessment
  • 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
Duration 45 hours in 15 sessions
Schedule 19:00-22:00, from Nov 16, 2020 to Jan 14, 2021 every Monday, Thursday, excluding Dec 21, 2020(Monday), Dec 24, 2020(Thursday), Dec 31, 2020(Thursday).
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 ---
Remark
{{col0}}
{{col1}}
Sorry, JavaScript required!