IT - Database Administration, Associate of Applied Science
Degree:
Associate of Applied Science
Overview
Database Administrators (DBAs) are critical to any organization, whether large or small. As the amount of data that companies collect and maintain continues to grow exponentially, the role of the DBA becomes critical to ensuring that data is accessible, confidential, and secure. Graduates will be able to design, implement and maintain databases, applying knowledge of database management systems.
Apply to LDSBC
Career opportunities
Companies are eager to hire people with understanding and skills necessary to manage technology.
Learning outcomes
Upon completion of the program, successful graduates should be able to:
- Confirm personal testimony in the restored gospel of Jesus Christ
- Collaborate with others using interpersonal skills in an honest, ethical, and Christ-like manner
- Communicate effectively using written and verbal presentation principles
- Install and configure database servers
- Create visualizations of large datasets using common visualization tools
- Install and configure Windows Servers and associated services
- Install and configure Linux Servers and associated services
- Complete and present effective systems design strategies and solutions
- Articulate career preparation confidently using resumes, and interviews
Course Requirements
Students are responsible to examine the course description of each course listed below for details of prerequisites, which must be satisfied before registering for the course.
Religion Courses
REL Two cornerstone religion courses (4 credit hours)
REL 200 | The Eternal Family | 2 credits |
REL 225 | Foundations of the Restoration | 2 credits |
REL 250 | Jesus Christ & Everlast Gospel | 2 credits |
REL 275 | Teach & Doct of Book of Mormon | 2 credits |
REL Two additional religion courses (4 credit hours)
College-wide Courses
COM 122 | Interpersonal Communications | 3 credits |
ENG 101 | Intro. to College Writing | 3 credits |
ENG 220 | Professional Bus Comm | 3 credits |
FIN 101 | Personal Finance | 3 credits |
| Total Credit Hours: | 12 |
Program Core Courses
CS 112 | Programming Fundamentals | 3 credits |
IT 110 | Introduction to Business Tech | 3 credits |
IT 125 | Windows Client | 3 credits |
IT 130 | Intro to Windows Serv Admin | 3 credits |
IT 143 | Structured Query Language(SQL) | 3 credits |
IT 145 | Business Metrics and Analytics | 3 credits |
IT 150 | Introduction to Networking | 3 credits |
IT 210 | Linux Administration | 3 credits |
IT 212 | Cyber Security Fund | 3 credits |
IT 214 | Systems Analysis & Design | 3 credits |
IT 216 | Information & Storage Mgmt | 3 credits |
IT 240 | Administering Microsoft SQL | 3 credits |
IT 243 | Data Warehousing | 3 credits |
IT 245 | Strategic Business Analysis | 3 credits |
IT 295 | Info Tech Capstone Project | 4 credits |
| Total Credit Hours: | 46 |
Total Credit Hours: 66
Recommended Sequence of Courses
Depending upon the number of preparatory courses a student must take, an additional semester may be required to complete the program.
First Semester
ENG 101 | Intro. to College Writing | 3 credits |
FIN 101 | Personal Finance | 3 credits |
IT 110 | Introduction to Business Tech | 3 credits |
IT 125 | Windows Client | 3 credits |
Religion | Cornerstone Religion course | 2 credits |
| Total Credit Hours: | 14 |
Second Semester
CS 112 | Programming Fundamentals | 3 credits |
IT 130 | Intro to Windows Serv Admin | 3 credits |
IT 143 | Structured Query Language(SQL) | 3 credits |
IT 150 | Introduction to Networking | 3 credits |
Religion | Cornerstone Religion course | 2 credits |
| Total Credit Hours: | 14 |
Third Semester
IT 145 | Business Metrics and Analytics | 3 credits |
IT 210 | Linux Administration | 3 credits |
IT 214 | Systems Analysis & Design | 3 credits |
IT 240 | Administering Microsoft SQL | 3 credits |
Religion | Cornerstone or Religion Elective | 2 credits |
| Total Credit Hours: | 14 |
Fourth Semester
IT 212 | Cyber Security Fund | 3 credits |
IT 216 | Information & Storage Mgmt | 3 credits |
IT 243 | Data Warehousing | 3 credits |
IT 245 | Strategic Business Analysis | 3 credits |
Religion | Cornerstone or Religion Elective | 2 credits |
| Total Credit Hours: | 14 |
Fifth Semester
COM 122 | Interpersonal Communications | 3 credits |
ENG 220 | Professional Bus Comm | 3 credits |
IT 295 | Info Tech Capstone Project | 4 credits |
| Total Credit Hours: | 10 |
Graduation Requirements
- Minimum of 66 total semester credit hours as outlined
- Grade of C or higher in all IT and CS core courses
- Cumulative grade-point average of 2.0 or higher
- Complete 2 cornerstone religion courses, plus 4 additional credits of religion