DBA 233 Advanced Database Administration • 5 Cr.
Department
Provides students with advanced concepts and hands-on practice in database administration. Topics include: creating and managing indexes, multi-user issues (locks, data integrity), replication, data warehousing, data analysis services, advanced Data Transformation Services, full text search and English query. Prerequisite: DBA 232 with a C- or better or entry code.
Outcomes:
After completing this class, students should be able to:
- Define the role of indexes in optimizing database performance
- Create clustered, un-clustered and unique indexes
- Create and analyze statistics generated by the use of indexes
- Describe the role of locks in a database transaction
- Describe how the database server applies locks
- Use database server tools to obtain lock information
- Describe lock escalation
- Describe the role of replication in database administration
- Compare and contrast replication types
- Implement Transactional Replication
- Compare and contrast On Line Transaction Processing )OLTP) and On Line Analysis Processing (OLAP)
- Describe the role of the Data Warehouse and the Data Mart in OLAP
- Describe the role of Data Transformation Services (DTS)
- Create DTS Packages with complex workflow, scripting and transformation components
- Define the concept of a Data Cube
- Build a dimensional database for use in Analylsis Services
- Construct an OLAP Cube
- Create a Data Warehouse
