| DataBase Administrators (DBA's) have to perform multiple functions within an organization. This class focuses on the issues that database administrators have to deal with in their everyday professional life. Responsibilities of a DBA are broken down by functions and each function is studied. These include: database system planning, database system installation and upgrading, database design (conceptual, logical, and physical), normalization (de-normalization), database loading and unloading, database change management, data availability, database security and access management, performance management (query processing, indexing, physical space planning, etc.), system performance, data integrity, data and storage management, data migration, data movement and distribution, database connectivity, fault tolerance (back ups and recovery) and disaster recovery planning. Students will use SQL Server and Oracle to design, implement and administer their database using these two commerical products. Although the course uses examples of these two two product functions, it is not a SQL Server or Oracle DBA certfication course. Prerequisite: SEIS 630 |
