Database Technologies Minor

Summary

This minor prepares students to design, apply, and use database technologies in any field, starting from an introduction to programming and progressing to advanced courses in big data, database security, and query processing. 

Catalog Year

2024-2025

Degree

Minor

Total Credits

20

Locations

Mankato

Career Cluster

Science, Technology, Engineering, Mathematics

Update Your Major

Program Requirements

Core

This course provides conceptual and logical tools for students planning to major in a computing-based major. Programming in a high-level language such as C++, Python, or Java, and the development of skills in abstraction, problem-solving, and algorithmic thinking are emphasized.

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

This course is a continuation of CIS 121. Students develop a basic knowledge of programming skills and object-oriented concepts, and use fundamental data structures such as lists, stacks, queues, and trees.

Prerequisites: CIS 121. Select One Course: MATH 112, MATH 113, MATH 115, MATH 121, or MATH 130

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: CIS 121 or an approved substitute.

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: CIS 340, CIS 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: CIS 350, CIS 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: CIS 440