The continuous need of the industry to have efficient and effective database solutions encouraged Montreal College to collaborate with the largest provider of database Management technologies. With its official curriculum developed by and for Oracle University, our Oracle database administration students get the best technical training to not only qualify for the certification exam but also gain practical know-how to operate these complex systems with ease.
This course will help you gain expertise in administering and managing an Oracle database. You will follow a skill-building trajectory that starts with the introduction to relational database query language i.e. SQL, followed by an introduction to the fundamentals of Oracle database administration, backup and recovery management and finally conclude with advanced skills like memory management, performance evaluation, and tuning tasks.
Class Schedule: Tuesday and Thursday (6:00pm - 9:00pm EST)
ORACLE DATABASE ADMINISTRATOR
Introduction to SQL
Installing Oracle Grid Infrastructure
Creating and managing users
Installing and configuring an Oracle Database
Administering the Oracle database
Understanding the Oracle database architecture and how its components work and interact with one another
Performing backup and recovery
Diagnosing and repairing data failures with Flashback technology
Managing space to optimize database storage
Monitoring and managing major database components, including memory, performance and resources
Backup and recovery strategies
Automating DBA tasks with the Scheduler
Certificate of participation in ‘Oracle Database Administration’ course.
Follow through Certification
The professionals taking this path can pursue the following certification:
Oracle Database 11g Administrator Certified Professional