An advanced-level course familiarizing the student with the Oracle Database Management System covering database terminology, data structure design, data retrieval, and manipulation. Includes database server installation, configuration, Oracle components and architecture, user administration and security, performance monitoring, client application access, and backup and recovery through laboratory exercises.
Goals, Topics, and Objectives
Upon successful completion of this course, students should be able to:
- Introduction to database management systems
- Planning and designing a database
- The Database Administrator (DBA)
- Oracle instance installation and upgrade
- Oracle architecture and components
- User/group administration
- Database security
- Database monitoring and tuning
- Oracle and third-party database administration software and tools
- Client/server connectivity
- Database backup and recovery
- Describe the difference between small-business database management systems and large-scale enterprise databases.
- Describe the role of a Database Administrator (DBA).
- Install and upgrade an Oracle instance.
- Configure an Oracle instance.
- Describe the various Oracle architecture and components.
- Perform user/group administration and security based on organizational business rules.*
- Monitor and tune database performance based on usage.*
- Perform database administration tasks using Oracle and third-party software and tools.
- Configure client access to the server, e.g. windows, web, application.
- Implement the appropriate database backup and recovery strategies based on organizational needs.*
Assessment and Requirements
Exams, quizzes, homework and laboratory assignments