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
- Introduction to database management systems
- The Database Administrator (DBA)
- Planning and designing a database
- Oracle installation and upgrade
- Oracle architecture and components
- Database security
- Database monitoring and tuning
- Oracle and third-party database administration software and tools
- Client/server connectivity
- Database backup and recovery
- Differentiate a personal database from a large-scale enterprise database.
- Describe the role of a Database Administrator (DBA).
- Describe planning and design aspects to a database.
- Install and upgrade an Oracle instance.
- Configure an Oracle instance.
- Describe the Oracle architecture and its various components.
- Implement database security methods such as Perform user, roles, privileges, and profiles.
- 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
Assessment of academic achievement may include (but is not limited to) exams, quizzes, homework, and laboratory assignments.
Credit for Prior College-Level Learning
Student posses a recent (among the two most recent editions) Oracle Certified Associate (OCA) certifications in Oracle Database Administration. Credential will be reviewed by CIS Department.