Course Requirements
This concentration in Database Administration is designed to prepare students to be Database Administrators. Large organizations have entire teams or even departments responsible for the DBA function, while small organizations may have just one DBA. In general, DBA's are responsible for the validity, reliability, security, and online responsiveness of their organization's database. They design both the physical and logical structure of these databases, develop processes and procedures to ensure both security and business continuity and disaster recovery.
Introductory Courses
Introductory course requirements for this concentration should be completed before pursuing advanced courses.
Foundation Courses
Advanced Courses
CDM Open Elective Courses
Students must complete 1 CDM Open Elective Course chosen from either IS concentration courses from any IS concentration or other courses meeting the following rules:
- Any 500-level CDM course qualifies, with the exception of ANI, DC, TV and VFX courses, which do not qualify.
Credit for courses taken outside of CDM will only be given if approved by a faculty advisor.
Capstone
IT 411
SCRIPTING FOR INTERACTIVE SYSTEMS
CSC 401
INTRODUCTION TO PROGRAMMING
An introduction to programming with a focus on problem solving, structured programming, and algorithm design with a gentle introduction to efficiency. Concepts covered include data types, expressions, variables, assignments, conditional and iterative structures, functions, file input/output, exceptions, namespaces, and recursion. PREREQUISITE(S): None
Prerequisites:
CDM graduate students in the Preqrequisite Phase are restricted from registering for this class.IS 400
INTRODUCTION TO IS MANAGEMENT SEMINAR
This one-credit seminar examines the concepts of information and technology management and career options in this field. Students will assess their own interests and skill requirements for various careers. They will also analyze the impacts of IS trends and emerging technologies on their career choices. All new IS master's students are required to take this seminar as the first course. PREREQUISITE(S): None
Prerequisites:
CDM graduate students in the Preqrequisite Phase are restricted from registering for this class.IS 421
SYSTEMS ANALYSIS
Course focus is on both traditional and object oriented systems analysis, with an emphasis upon developing competency in a wide range of modeling techniques. Specific topics include: overview of the software development environment and project management; project selection, initiation, and planning; determining requirements; process modeling, including DFDs and use cases; logic modeling, including decision tables, sequence diagrams, and activity diagrams; introduction to Entity-Relationship Diagrams. PREREQUISITE(S): Completion of Prerequisite Phase
Prerequisites:
CDM graduate students in the Preqrequisite Phase are restricted from registering for this class.CSC 451
DATABASE DESIGN
Requirement analysis, conceptual design, logical design and implementation of relational databases. Emphasis will be on E-R modeling and E-R mapping, along with basic normalization and SQL for database implementation. PREREQUISITE(S): Graduate Standing.
Prerequisites:
CDM graduate students in the Preqrequisite Phase are restricted from registering for this class.IS 422
SYSTEM DESIGN, IMPLEMENTATION, AND MAINTENANCE
Course focus is on both traditional and object oriented systems design. Specific topics include: database design, including logical and physical design; Entity-Relationship diagrams, class diagrams, form and report design; interface and dialogue design; design specifications, including structure charts and prototypes; designing for LANs and distributed systems, as well as the Internet; system implementation, including parallel and phased implementation, testing, documentation, and user training; system maintenance, including types of maintenance, controlling and coordinating maintenance requests, and configuration management. Course ends with a multi-week case study applying the principles from both this course and IS 421, Systems Analysis. PREREQUISITE(S): IS 421 and CSC 451
Prerequisites:
CDM graduate students in the Preqrequisite Phase are restricted from registering for this class.ECT 424
ENTERPRISE INFRASTRUCTURE
Introduction to modern infrastructure and the evolving technology environment. Major topics include: computer networks, Internet infrastructure, Web 2.0, Enterprise 2.0, social media and networking, software as a service, content management systems, cloud computing, and portal.
Prerequisites:
CDM graduate students in the Preqrequisite Phase are restricted from registering for this class.IS 430
FUNDAMENTALS OF IT PROJECT MANAGEMENT
This course concentrates on monitoring, managing and controlling assets and resources on a single IT project. Topics covered are risk management; procurement and contract management; time and cost estimating; controlling and tracking techniques; quality assurance; testing and audit. Students will use common project management software for resource allocation and balancing. NO PREREQUISITES.
Prerequisites:
CDM graduate students in the Preqrequisite Phase are restricted from registering for this class.IS 433
INFORMATION SECURITY MANAGEMENT
Survey of security considerations as they apply to information systems analysis and design. Vulnerability assessment. Security audits. Access controls for Internet-based and internal systems. Firewalls. Data protection. Physical access controls. Security policies. Personnel and equipment security. Risk management. Legal requirements and considerations. Privacy. PREREQUISITE(S): NONE.
Prerequisites:
CDM graduate students in the Preqrequisite Phase are restricted from registering for this class.IS 549
DATA WAREHOUSING AND DATA MINING
Introduction to data warehousing and the foundations of understanding the issues involved in building a successful data warehouse. Data warehouse development methodology and issues surrounding the planning of the data warehouse. Data quality and metadata in the data warehouse. Analysis, transformation and loading of data into a data warehouse. Development of the data architecture and physical design. Implementation and administration of the data warehouse. Introduction to data mining. (PREREQUISTE(S):CSC 449 or CSC 451 or CSC 453).
Prerequisites:
CDM graduate students in the Preqrequisite Phase are restricted from registering for this class.CSC 454
DATABASE ADMINISTRATION AND MANAGEMENT
This course is designed to give students a comprehensive foundation in database administration and management. The course provides a conceptual understanding of the database architecture and how its components work and interact with one another. Topics covered in this course include: database architecture, capacity planning, installation and maintenance, network configuration, security management, utilities and tools, industry standards and guidelines, database management techniques and practices. PREREQUISITE(S): CSC 453 or CSC 451.
Prerequisites:
CDM graduate students in the Preqrequisite Phase are restricted from registering for this class.CSC 452
DATABASE PROGRAMMING
Programming in large-scale relational database environment using host languages. Design and implementation of on-line applications. Topics covered in this course include: database programming using open architectures, embedded query languages, dynamic query language, procedural extension of query languages, stored procedures, transaction management, and introduction to extensible markup data definition and retrieval languages. PREREQUISITE(S): (CSC 453 or CSC 451) and (CSC 212 or CSC262 or CSC 224 or CSC 300 or CSC 309).
Prerequisites:
CDM graduate students in the Preqrequisite Phase are restricted from registering for this class.CSC 554
ADVANCED DATABASE MANAGEMENT
In this class, we will discuss concepts, technologies, guiding principles, processes and best practices in managing database environment to meet high availability, scalability, and compliance needs. Organizations with business critical applications must reduce their risk of downtime, manage database environment efficiently and ensure data meets compliance requirements effectively. IT now has additional responsibilities to secure and manage information in alignment with legal, records management and regulations. This class explores methods and techniques to achieve the availability needs and also focuses on how to protect the database against disasters by maintaining multiple copies of the databases in separate locations, synchronized in real-time. Students learn to design and manage key business resumption functions including disaster recovery plans and business continuity plans. Data governance challenges will be discussed along with solutions including data life cycle management, preservation, retention, and disposition. Prerequisite(s): CSC 453 or CSC 454
Prerequisites:
CDM graduate students in the Preqrequisite Phase are restricted from registering for this class.IS 505
BUSINESS CONTINUITY/DISASTER RECOVERY THEORIES AND STRATEGIES
This course focuses on the knowledge necessary for an organization to prepare for a variety of major disruptions (floods, earthquakes, terrorist attacks, etc.). The goal is survival of the organization and its daily workflow despite major disruption. Students learn to analyze and prioritize risks and determine criticality ratings that are used to determine survival strategies. Students also learn how to organize employees to respond to a major disruption and how to document recovery plans. Course content includes coverage of current industry trends, as well as planning for the survival of Information Technology functions within an organization.
Prerequisites:
CDM graduate students in the Preqrequisite Phase are restricted from registering for this class.IS 577
INFORMATION SYSTEMS POLICIES AND STRATEGIES
This capstone course emphasizes the planning and management of information technologies and related resources at the corporate level. Topics covered include assessment of information technologies, tracking emerging technologies and trends, managing portfolio resources and matching them to business needs, technology transfer, end-user computing, outsourcing, theoretical models, strategic applications and strategic IT planning. Students are encouraged to take this course toward the end of their study. PREREQUISTE(S):Ten or more CDM MS level courses.
Prerequisites:
CDM graduate students in the Preqrequisite Phase are restricted from registering for this class.