MSCD 600 Database Architecture (3.00)
Provides an introduction to the internal structures and architectures of database management systems. Focuses on the Oracle10g ORDBMS architecture and associated processes and physical files. Covers general concepts such as design, deployment, and operation. NOTE: Acceptance into the MS program.
Pre-requisite: TAKE MSCC*610;
Cross listing(s): MCT 613.
MSCD 610 Database Concepts (3.00)
Explores data modeling, database design, management concepts, and SQL3 in-depth. Utilizes Oracle10g ORDBMS and Oracle command line interface, SQL*Plus for all lab work. Provides hands-on experience with an enterprise class, object-relational database management system.
Pre-requisite: MSCD*600 OR MCT*613
Cross listing(s): MCT 614.
MSCD 642 Database Backup & Recovery (3.00)
Studies the critical tasks of planning and implementing database backup and recovery strategies. Explores backup methodologies based on business requirements in a typical enterprise and utilizes multiple strategies to recover from different types of recovery failures.
MSCD 644 Database Performance Tuning (3.00)
Studies database servers from the perspective of optimization and performance. Focuses on techniques for improving data access and storage, emphasizing performance diagnosis and resolution using real-world scenarios.