Database Technologies Minor

Program Requirements

Core

This is the first course for students planning to major or minor in Information Systems or Information Technology. Programming in a high-level language, abstraction and problem-solving skills are emphasized. Prereq: Select from 1 course: MATH 112, 115, 121 or 181 OR a math placement score permitting placement in a course that requires any of these as a prerequisite.

Prerequisites: MATH 112 or MATH 113 or MATH 115 or MATH 121 or MATH 180

A continuation of IT 210, IT 214 introduces object-oriented concepts, programming techniques, lists, stacks, queues, and trees. Students are expected to produce larger applications, utilizing multiple compilation units. Fall, Spring

Prerequisites: (EE 107 or IT 210) and (MATH 113 or MATH 115 or MATH 121 or MATH 180)

Introduction to database systems, entity relationship models, relational algebra, database design, data modeling, normalization, and conversion of business rules into relational model. Introduction to basic SQL including subqueries, joins, functions, sequences, triggers, views, and stored procedures.

Prerequisites: IT 210, a 3.0 or higher grade in IT 210 or in an approved substitute is required.

Restricted Electives

Choose 8 Credit(s).

Extensive coverage of SQL, database programming, large scale data modeling, and database enhancement through reverse engineering. This course also covers theoretical concepts of query processing, and optimization, basic understanding of concurrency control and recovery, and database security and integrity in centralized/distributed environments. Team-oriented projects in a heterogeneous client server environment.

Prerequisites: IT 380

This course covers science and study of methods of protecting data, and designing disaster recovery strategy. Secure database design, data integrity, secure architectures, secure transaction processing, information flow controls, inference controls, and auditing. Security models for relational and object-oriented databases.Variable

Prerequisites: IT 350, IT 440

The course explores big data in structured and unstructured data sources. Emphasis is placed on big data strategies, techniques and evaluation methods. Various data analytics are covered. Students experiment with big data through big data analytics, data mining, and data warehousing tools.Does the proposal require a modify Program proposal?No

Prerequisites: IT 310, IT 440