MSCC 610 Information Technology Concepts (3.00)
Introduces information systems concepts, architectures, and technologies. Emphasizes information systems resources needed to meet organizational mission and objectives. Focuses on information systems from business viewpoint including processes, value proposition, and different types of information systems.
MSCC 630 Enterprise Architecture (3.00)
Examines information needed to create adaptive strategies for successfully implementing enterprise architectures. Focuses on strategies that are based on experiences within organizations across multiple industry verticals.
Pre-requisite: TAKE MSCC*697;
MSCC 693 Graduate Capstone (3.00)
Case-based scenario that emphasizes real-world application of Information Technology knowledge and skills. Simulates a real-world information technology organization where students enhance skills learned in previous courses. Employing critical analysis, students fulfill the final project requirement.
Pre-requisite: TAKE MSCC*630
MSCC 697 Information Technology Research Methods (3.00)
Concentrates on project management, proposal preparation, research and thesis writing. Deliverable include abstract proposal outline and research plan. Students research and develop project proposals that are then approved by the faculty.
Pre-requisite: TAKE MSCC*610;
MSCC 698 Graduate Thesis (3.00)
Students complete a masters thesis that is a substantial body of original scholarly work in the area of information technology.
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 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.
Pre-requisite: MSCD*640
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.
Pre-requisite: MSCD*640
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
MSCD 692 Database Practicum I (3.00)
Simulates a real-world information technology organization where students enhance skills learned in previous database courses. Provides a research platform that can be used towards the collection of data to fulfill the thesis requirement.
Pre-requisite: TAKE MSCC*630 AND MSCD*640;
Cross listing(s): MCT 692.
MSCD 696 Database Practicum II (3.00)
Continuation of Database Practicum I. Simulates a real-world information technology organization where students enhance skills learned in previous database courses. Provides a research platform that can be used towards the collection of data to fulfill the thesis requirement.
Pre-requisite: TAKE MSCD*692;
Cross listing(s): MCT 696.