[ Login ]

Classes

DBA 233 Advanced Database Administration • 5 Cr.

Description:

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
v3.4.0.0

Footer Navigation

Contact info

Bellevue College
3000 Landerholm Circle SE Bellevue, WA 98007-6484 U.S.A.
Work: (425) 564-1000