IT-Database Administration
Curriculum Description
Information Technology
Career Cluster:Â Â Â Â
Web and Digital Communications, Information Support and Services, Programming and Software Development, and Network Systems
Pathway:Â Â Â Â Â Â Â Â Â Â Â Â Â Information Technology
Program Major   Information Technology
Pathway Description
The Information Technology (IT) curriculum prepares graduates for employment in the technology sector as designers, testers, support technicians, system administrators, developers, or programmers who use computer software and\or hardware to design, process, implement and manage information systems in specialties such as database services, security, business intelligence, healthcare informatics and others depending on the technical path selected within this curriculum.
Course work includes development of a student’s ability to create, store, communicate, exchange and use information to solve technical issues related to information support and services, interactive media, network systems, programming and software development, information security and other emerging technologies based on the selected area of study.
Graduates should qualify for employment in entry-level positions with businesses, educational systems, and governmental agencies which rely on computer systems to design and manage information. The program will incorporate the competencies of industry-recognized certification exams.
This curriculum model is designed for the student that wishes to obtain the Associate in Applied Science degree in Information Technology with an emphasis in Database Administration.
The following represents one way in which the program of study can be completed. Students who aren’t able to follow the recommended curriculum model below should consult their academic advisor to be sure that they take courses in the best order for their success.
Associate in Applied Science
A25590DA
NC CIP: 11.0103
Day, Evening, and Online
POS Approved: Fall 2021
Fall Semester
| Course | Course Title | Class Hours | Lab/Shop Hours | Clinical/WBL Hours | Credit Hours |
|---|---|---|---|---|---|
| CIS 110 | Introduction to Computers | 2 | 2 | 0 | 3 |
| CTI 110 | Web, Pgm, & Db Foundation | 2 | 2 | 0 | 3 |
| CTI 120 | Network & Sec Foundation | 2 | 2 | 0 | 3 |
| Select one: | |||||
| Freshman Composition | (3) | (0) | (0) | (3) | |
| OR | |||||
| Writing and Inquiry | 3 | 0 | 0 | 3 | |
| Total: | 9 | 6 | 0 | 12 | |
Spring Semester
| Course | Course Title | Class Hours | Lab/Shop Hours | Clinical/WBL Hours | Credit Hours |
|---|---|---|---|---|---|
| CTS 115 | Info Sys Business Concept | 3 | 0 | 0 | 3 |
| DBA 110 | Database Concepts | 2 | 3 | 0 | 3 |
| DBA 120 | Database Programming I | 2 | 2 | 0 | 3 |
| ___ ___ | Social/Behavioral Science Elective | 3 | 0 | 0 | 3 |
| Select one: | |||||
| Mathematical Measurement and Literacy | (2) | (2) | (0) | (3) | |
| OR | |||||
| Quantitative Literacy | 2 | 2 | 0 | 3 | |
| OR | |||||
| Precalculus Algebra | (3) | (2) | (0) | (4) | |
| Total: | 12 | 7 | 0 | 15 | |
Summer Term
| Course | Course Title | Class Hours | Lab/Shop Hours | Clinical/WBL Hours | Credit Hours |
|---|---|---|---|---|---|
| CTI 141 | Cloud & Storage Concepts | 1 | 4 | 0 | 3 |
| SEC 110 | Security Concepts | 2 | 2 | 0 | 3 |
| ___ ___ | Humanities/Fine Arts Elective | ** | ** | 0 | 3 |
| Select one: | |||||
| Intro Interpersonal Com | (3) | (0) | (0) | (3) | |
| OR | |||||
| Public Speaking | (3) | (0) | (0) | (3) | |
| OR | |||||
| Prof Research & Reporting | (3) | (0) | (0) | (3) | |
| OR | |||||
| Technical Report Writing | 3 | 0 | 0 | 3 | |
| Total: | 6 | 6 | 0 | 12 | |
Fall Semester
| Course | Course Title | Class Hours | Lab/Shop Hours | Clinical/WBL Hours | Credit Hours |
|---|---|---|---|---|---|
| DBA 210 | Database Administration | 2 | 3 | 0 | 3 |
| DBA 240 | Database Analysis/Design | 2 | 3 | 0 | 3 |
| NET 125 | Introduction to Networks | 1 | 4 | 0 | 3 |
| ___ ___ | Elective List 1 | ** | ** | ** | 1 |
| Total: | 5 | 10 | 0 | 10 |
Spring Semester
| Course | Course Title | Class Hours | Lab/Shop Hours | Clinical/WBL Hours | Credit Hours |
|---|---|---|---|---|---|
| DBA 261 | SQL Server DBMS Admin | 2 | 2 | 0 | 3 |
| DBA 289 | Database Project | 1 | 4 | 0 | 3 |
| NET 126 | Routing Basics | 1 | 4 | 0 | 3 |
| Select one: | |||||
| SQL Server DB Prog II | (2) | (2) | (0) | (3) | |
| OR | |||||
| MySQL DB Programming II | 2 | 2 | 0 | 3 | |
| Select one: | |||||
| SQL Server Perf Tuning | (2) | (2) | (0) | (3) | |
| OR | |||||
| MySQL Performance Tuning | 2 | 2 | 0 | 3 | |
| Total: | 8 | 14 | 0 | 15 | |
Total Credit Hours: 64
Additional Information
2017FA State Curriculum Standard Revision; new title and code; repackaging only.
           This program was formerly Database Management A25150.Â
Elective – Select 1 credit hour: CTI 140, CTS 240, DBA 285, HBI 110, NOS 130, NOS 230, WBL 111, WBL 121, WBL 131
Humanities/Fine Arts Elective – Select one: ART 111, HUM 110, HUM 115, MUS 110, PHI 240
Social/Behavioral Science Elective – Select one: ECO 151, ECO 251, ECO 252, PSY 118, PSY 150, SOC 210
**Hours will vary depending on course selection.
A25590DA