DATABASE ADMINISTRATION (DBA)
(DESCRIPTIONS AND PREREQUISITES) |
| DBA 110 |
Introduction to Relational Databases |
3 CR |
| Students will learn effective relational design and gain a general overview of relational database management systems. This course introduces students to the terminology and methods used to create and modify Database Management Systems (DBMS). Emphasis will be given to accessing large databases and developing methods for working with data on different DBMS. The course will concentrate on helping students gain confidence in using DBMS and understanding data structures. [32-32-64] Lab Fee |
| DBA 231 |
Microsoft SQL Server 2005-Implementation and Maintenance |
3 CR |
| Prerequisite: DBA 110. This course will help students install and configure SQL Server 2005, implement high availability and disaster recovery, maintain database and monitor and troubleshooting SQL Server Performance. It also provides information on how to create and implement database objects. [32-32-64] Lab Fee |
| DBA 243 |
Designing a Database Server Infrastucture by using Microsoft SQL Server 2005 |
3 CR |
| Prerequisites: DBA 110 and 231. This course will help students identify high availability and security solutions, automate administrative tasks, monitor and troubleshoot the database server, design and execute deployments. [32-32-64] Lab Fee |
| DBA 244 |
Optimizing and Maintaining a Database Administration Solution using Microsoft SQL Server 2005 |
3 CR |
| Prerequisites: DBA 110 and 231. This course will help students to identify methods to optimize the performance of database server and databases, implement a data recovery plan, monitor and maintain a database solution and manage database security. [32-32-64] Lab Fee |
| DBA 251 |
Oracle I |
3 CR |
| Prerequisites: DBA 110 or department approval. This course is designed to give students a firm foundation in basic database administration. Students will learn how to install and maintain an Oracle database. Students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structure hands-on practices. This course is also designed to prepare you for the corresponding Oracle Certified Associate exam. [32-32-64] Lab Fee |
| DBA 252 |
Oracle II |
3 CR |
| Prerequisites: DBA 251 or department approval. This course is designed to configure an Oracle database for multilingual applications. Students will practice various methods of recovering the database, using RMAN, SQL, and Flashback technology. Tools to monitor database performance and what steps to take to improve database performance are also covered in this course. Students will also learn how to use various database technologies, such as Resource Manager, the Scheduler, and Automatic Storage Management (ASM). The lesson topics are reinforced with structure hands-on practices and a workshop. This course is also designed to prepare you for the corresponding Oracle Certified Professional exam. [32-32-64] Lab Fee |
| NOTE: The course descriptions for the Cooperative Education course electives within the Database Administrator (DBA) Program can be found under the Information Technology (IT) course descriptions. |
