Oracle Database 11g for DB operators & junior DBAs: Administration I

Sorry, JavaScript required!
Title Oracle Database 11g for DB operators & junior DBAs: Administration I
Course code CM404.2-05-2018-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. Because more than 87% of production Oracle servers run Linux, the course will also teach Oracle in Linux.
  • Introduction to Oracle Database Architecture
  • Setting up the Oracle Database environment on Fedora Linux
  • Creation of multiple instances on a server
  • Managing the Oracle instance (Storage and User)
  • Configuring the Oracle Network Environment.
  • Administering the Security
  • Managing Undo Data
  • Transport Data between Databases
  • Back up and Recovery concepts
  • Backup database in Image copy, backup set and compressed backup set with the Enterprise Manager GUI.
  • Recovery database with the Enterprise Manager GUI.
  • 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 Can use basic SQL. Having managed an operating system. 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 May 7, 2018 to Jun 28, 2018 every Monday, Thursday, plus Jul 2, 2018(Monday), excluding May 17, 2018(Thursday), Jun 18, 2018(Monday).
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: 1710120336-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, using 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!