Database Systems

Explores current issues in designing, managing, and securing complex, organized information systems. For industry professionals, recent computer science graduates, as well as newcomers to the industry.

Faculty Spotlight

Jonathan Robinson, Ph.D.
Dissertation Topic:
Computing the Domain of a Digital Curve
Current Research:
robot vision, OCR and curve fitting

Required Courses

MSIS 615	Database Management and AdministrationAddresses the basic concepts of sound database design. The course covers database normalization; data integrity, including setting domain constraints, triggers, and referential integrity constraints; design presentation tools such as Visio; E-R diagrams; data manipulation and retrieval using SQL; database implementation using SQL Server; transaction processing; and database issues such as concurrency control, database recovery, and query optimization. Prerequisite: Completion of required prerequisite "bridge" courses (if applicable).
MSIS 616	Advanced Database AdministrationBuilding on Database Management and Administration, the course explores additional data modeling techniques, concepts of database integrity and transaction management, stored procedures, user-defined functions, database programming, query optimization, performance and tuning, and other advanced SQL topics. Prerequisite: MSIS 615
MSIS 620	Data Mining and Warehousing Introduces basic concepts and techniques of data mining and warehousing. Students learn the motivation behind both data mining and warehousing. Topics covered include a survey of data mining applications, techniques and models. The course also introduces students to data mining software and its integration into existing systems. Prerequisite: MSIS 616
MSIS 626	Database Security Introduces database security, which greatly impacts the design of today's information systems. This vendor-neutral course provides an overview of database security concepts and techniques and discusses new directions of database security in the context of Internet information management. The course expounds on the security context of database technologies and examines the exploitation of database vulnerabilities. It also provides an overview of security issues in database systems and shows how current and future commercial systems may be designed to ensure secrecy and confidentiality. Students will learn about common pitfalls of database design and how to identify and avoid them. Also covered are basic security mechanisms and software, database security, intrusion detection, and security models for next-generation databases. Prerequisite: MSIS 615

Electives

MSIS 623	Database Concepts for Financial SystemsFocuses on the intersection of global financial markets and database concepts. The course considers the various business processes involved that affect investors, savers, borrowers, and corporations and how global financial markets rely on data and information. Activities explored include trading, risk management, and portfolio management, among others, and the essential database concepts and data content required to support these functions. Prerequisite: MSIS 615
MSIS 628	Special Topics in DatabasesExplores in-depth theoretical and practical issues of advanced database management systems. The main focus is on the introduction of specific concepts, methodologies and techniques related to advanced database topics, which may include database application development, storage and indexing, transactions, query management and optimization, concurrency control, and recovery. Prerequisite: MSIS 615
MSIS 630	Web Database Application DevelopmentIntroduces the principles and practice of implementing and designing medium-sized web database applications. Students learn to apply web programming technology and tools for database implementation to the web, including server-side scripting, session management, and authentication. Students also investigate Internet database application issues including database design, human computer interface (HCI) techniques, and evaluation criteria for designing good web database applications. Prerequisite: MSIS 615
MSIS 632	Enterprise Database SystemsA hands-on approach to the effective management of large-enterprise databases. The objective is for students to acquire the skills for designing, maintaining, and optimizing these databases. Concepts and techniques needed to install, configure, administer, maintain, query and generate reports, troubleshoot, backup and recover data, and fine-tune such systems are explored. Pre- or Corequisite: MSIS 616
MSIS 633	Database ApplicationsIntroduces the details of various database structures in several database systems in common use in today's market, such as Oracle, SQL Server, MySQL, Sybase, and DB2. The course covers the implementation of database features including indices, keys, foreign keys, triggers, cursors, stored procedures, concurrency and transaction management, among other topics. Rudimentary proprietary extensions to SQL are also studied and compared. Pre- or Corequisite: MSIS 616
MSIS 634	Intro to DBMS Internals and Data Structures Discusses the implementation of many typical database concepts using Microsoft's SQL Server database. Some basic computer science data structures and operating system concepts are covered, as well, in the context of SQL Server internals. Pre- or Corequisite: MSIS 616
Any Other Elective Approved by the Dean

"Bridge" Prerequisites

Students with insufficient background in computer science or information systems may be required to complete some or all of these courses:

Computer Concepts Tutorial - 1 credit
Computer Theory with Operating System
Introduction to Programming
Database Concepts and Design

Name:
E-mail:
Phone:

Faculty Spotlight

Required Courses

Electives

"Bridge" Prerequisites

Questions?