Oracle Database 11g Administrator

Oracle Database 11g continues to be innovative by storing and securing information while compressing data and consolidating application databases so that they are fast and reliable. In addition to understanding how to install and maintain Oracle Database 11g, this course aims to provide students with a foundation in the administration of Oracle Database 11g. They will gain a conceptual understanding of the Oracle Database architecture and how its components work and interact. Through participation in this course students will learn to create an operational database and properly manage its various structures in an effective and efficient manner. This includes performance monitoring, database security, user management and back up /recovery techniques used to minimize data loss. Areas of concentration include a focus on the concepts and architecture that support backup and recovery. Students will gain an understanding of the fundamentals and concepts of SQL language, and know how to extract, add and change data in a database. Topics are reinforced through hands on practice using the newest technologies as used by businesses today.

Course Outline

Oracle Database 11g SQL Fundamentals
Oracle Database 11g Administration I
Oracle Database 11g Administration II

Course Outcomes:

Upon successful completion of this course student will be able to:

Plan data-flows for new or revised databases and test new systems
Plan data-flows for new or revised databases and test new systems
Commission and install new applications and ensure database security
Read and understand handbooks, and guides for new software
Design and develop database architecture for information systems projects
Design, construct and modify, integrate, implement and test data models and database management systems
Develop policies and procedures for network and/or internet database access and usage and for the backup and recovery of data
Load, program and manipulate data
Program in the latest development tools and languages such as SQL, PLSQL

Career Opportunities:

Graduates of this program will be able to secure employment in information technology consulting firms and units throughout the private and public sectors as data administrators, data custodians, data dictionary administrators, data warehouse analysts, database administrators (DBA), Database Analysts, database architects, data processing specialists, Electronic data processing analysts, information resource analysts, among other positions.

Course Duration

23 weeks