Information Technology - Database Administration

Associate of Applied Science (AAS) - 60 credits

About this program
This program prepares students for careers in support, maintenance, and administration of database management systems in a wide variety of market segments. Students will learn how to implement security measures while performing database administration tasks, generate database-driven reports to support business intelligence, apply ethical and security practices in handling data, establish interconnectivity of databases and web services, use testing and debugging methods, devise backup and recovery measures in a database environment and learn the software development life cycle. This program teaches students the skills and knowledge for occupations such as database administrator, database analyst, data analyst or database support specialist.
Program outcomes
  1. Function effectively within teams.
  2. Demonstrate professionalism, including presentation skills, utilizing research for problem solving, working independently and in teams, being accountable and meeting deadlines.
  3. Implement security measures while performing database administration tasks.
  4. Generate database-driven reports to support business intelligence.
  5. Demonstrate appropriate ethical and security practices in handling data.
  6. Establish interconnectivity of databases and web services.
  7. Apply testing and debugging methods to assure quality and workability of finished product.
  8. Devise backup and recovery measures in a database environment.
  9. Demonstrate knowledge of the software development life cycle and how the database layer is managed and administered.
Accreditation
Minnesota State Community and Technical College is accredited by the Higher Learning Commission, a regional accreditation agency recognized by the U.S. Department of Education. More information can be found at www.minnesota.edu/accreditation.
Tracks

Curriculum overview

Credits Requirement type
60 Required courses
60 Total

Curriculum

Required Courses:

Subj. Number Course Credits
CPTR1001 Introduction To Programming and Scripting 3
CPTR1106 Microcomputer Databases 3
CPTR1108 CISCO 1 3
CPTR1170 Web Engineering I 3
CPTR2210 Database Report Generation 3
CPTR2224 Linux I 3
CPTR2230 Structured Query Language 3
CPTR2234 Linux II 3
CPTR2240 Database Administration 3
CPTR2245 Enterprise Network Technologies 3
CPTR2260 Advanced Structured Query Language 3
CPTR2272 Network Operating Systems 3
CPTR2275 Data Analytics 3
CSCI1121 Computer Science I 4
ENGL1101 College Writing 3
HUM2236 Technology in the Humanities 3
MATH1100 World of Math 3
MATH1114 College Algebra 4
MATH1213 Introduction to Statistics 4
Plans

PDF downloads:

1st Fall Term - 15 credits

Subj. Number Course Credits
CPTR1001 Introduction To Programming and Scripting 3
CPTR1106 Microcomputer Databases 3
CPTR1108 CISCO 1 3
CPTR1170 Web Engineering I 3
MATH1100 World of Math 3

1st Spring Term - 17 credits

Subj. Number Course Credits
CPTR2210 Database Report Generation 3
CPTR2224 Linux I 3
CPTR2230 Structured Query Language 3
CSCI1121 Computer Science I 4
MATH1114 College Algebra 4

2nd Fall Term - 16 credits

Subj. Number Course Credits
CPTR2234 Linux II 3
CPTR2260 Advanced Structured Query Language 3
CPTR2272 Network Operating Systems 3
HUM2236 Technology in the Humanities 3
MATH1213 Introduction to Statistics 4

2nd Spring Term - 12 credits

Subj. Number Course Credits
CPTR2240 Database Administration 3
CPTR2245 Enterprise Network Technologies 3
CPTR2275 Data Analytics 3
ENGL1101 College Writing 3