Oracle Database 11g for DBAs: Administration Workshop II

Sorry, JavaScript required!
Title Oracle Database 11g for DBAs: Administration Workshop II
Course code CM404.3-07-2018-C
Objective DBAs will learn the main skills required in their jobs, including monitoring, tuning and securing Oracle instances, advanced backup and recovery, high availability (HA), simple Real Application Clustering (RAC) environment set up.
  • Database Architecture and ASM
  • Configuring for Recoverability
  • Configuring for Backup specifications
  • Using RMAN to create backups
  • Using RMAN to perform recovery
  • User managed backup and recovery
  • Perform the point in time recovery
  • Using Flashback Technology
  • Memory management and tuning
  • Monitoring the database performance
  • Space Management
  • Administering the Scheduler
  • Building Standby Database by replicate the data to another host.
  • Basic Oracle Real Application Cluster (RAC) infrastructure, set up and implementation.
  • 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 Adminstrators
Prerequisite Oracle Database 11g: Administration Workshop I or equivalent. Please check the self-assessment
Class size 20
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 51 hours in 17 sessions
Schedule 19:00-22:00, Jul 5, 2018 (Thursday), and from Jul 9, 2018 to Aug 30, 2018 every Monday, Thursday.
Fee MOP2,800
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: 1801200080-0
  • Instructor will deliver assignment to student to do at home after each session, the assignment will take about 6 -8 hours to finish. Instructor will give the model answer and review the difficult parts of the assignment in the later session, to make sure all the students master the topic and get a better training result.
  • This is an Oracle WDP authorized course, according to the Oracle WDP partner agreement, this course must use Oracle original electronic textbooks,eKit, (with watermark of student's information). Please enroll this course one week before it starts for us to prepare the customized Oracle official eKit for you. Students finishing this series courses(CM404.1, CM404.2 and CM404.3) will be able to attempt the "Oracle Certified Administrator" or "Oracle Certified Professional" (OCP) exam.
Sorry, JavaScript required!