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 640 Oracle Database Administration (3.00)
Examines key tasks and functions required of a database administrator in a production environment. Students create, start up, and manage a database. In addition, students implement data security and integrity measures and grant access privileges to individual database users.
Pre-requisite: TAKE MSCD*610 OR MCT*614;
Cross listing(s): MCT 615.
MSCD 650 PL/SQL Programming (3.00)
Studies advanced SQL and SQL*Plus concepts and how to write PL/SQL procedures, functions and packages. Topics include extending statements to include Set Operators, and building correlated sub queries and hierarchical queries. Student creates and manages PL/SQL program units and database triggers as a basis for complex application development.
Pre-requisite: MSCD*610
MSCD 670 Middleware Architectures & Database Apps (3.00)
Examines middleware implementation of portals using Oracle's advanced 10gAS platform as an application study. Focuses on middleware design, development and administration of web- based enterprise portal technology. Explores B2B applications, case studies, and Internet access to the database.
Pre-requisite: TAKE MSCD*610 OR MCT*614;
Cross listing(s): MCT 616.
MSCD 675 Database Technologies and SOA (3.00)
Introduces SOA, middleware, with enterprise architecture, interoperability and loose coupling. Explores technical and organizational perspectives and alignment using design principles and industry-standard organizational models. Includes hands-on implementation of distributed Web Services-based interfaces to database system.
Pre-requisite: TAKE MSCD*670;
Cross listing(s): MCT 627.
MSCD 681 Data Warehouse Design (3.00)
Data warehouse design includes in-depth exploration of organizational decision based on data repository, focusing on requirements, data warehouse design, data extraction and data stores. Includes business intelligence systems implications with hands-on approach to design.
Pre-requisite: MSCD*600, MSCD*610