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. The Higher Learning Commission 230 South LaSalle Street, Suite 7-500 Chicago, IL 60604-1411 http://www.ncahigherlearningcommission.org Phone: 312.263.0456 / 800.621.7440
Tracks

Curriculum overview

Credits Requirement type
60 Required courses
60 Total

Curriculum

Required Courses:

Course Credits
CPTR1001 - Introduction To Programming and Scripting 3
CPTR1106 - Microcomputer Databases 3
CPTR1108 - CISCO 1 3
CPTR2001 - Scripting for Automation 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
CPTR2275 - Data Analytics 3
CSCI1121 - Computer Science I 4
CSEC2204 - Managing Directory Services 3
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

Course Credits
CPTR1001 - Introduction To Programming and Scripting 3
CPTR1106 - Microcomputer Databases 3
CPTR1108 - CISCO 1 3
CPTR2224 - Linux I 3
MATH1100 - World of Math 3

1st Spring Term - 17 credits

Course Credits
CPTR2001 - Scripting for Automation 3
CPTR2230 - Structured Query Language 3
CPTR2240 - Database Administration 3
CSCI1121 - Computer Science I 4
MATH1114 - College Algebra 4

2nd Fall Term - 16 credits

Course Credits
CPTR2234 - Linux II 3
CPTR2260 - Advanced Structured Query Language 3
CSEC2204 - Managing Directory Services 3
HUM2236 - Technology in the Humanities 3
MATH1213 - Introduction to Statistics 4

2nd Spring Term - 12 credits

Course Credits
CPTR2210 - Database Report Generation 3
CPTR2245 - Enterprise Network Technologies 3
CPTR2275 - Data Analytics 3
ENGL1101 - College Writing 3

Computer requirements