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 REVISED
NC CIP: 11.0103
Day, Evening, and Online
POS Approved: Fall 2020
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:
| Course | Course Title | Class Hours | Lab/Shop Hours | Clinical/WBL Hours | Credit Hours |
|---|---|---|---|---|---|
| ENG 110 OR |
Freshman Composition NEW VERSION  |
(3) | (0) | (0) | (3) |
| ENG 111 | Writing and Inquiry NEW VERSION   |
3 | 0 | 0 | 3 |
Totals
Class Hours: 9
Lab/Shop Hours: 6
Clinical/WBL Hours: 0
Credit Hours: 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 REVISED REQUISITE |
2 | 2 | 0 | 3 |
| ___ ___ | Social/Behavioral Science Elective | 3 | 0 | 0 | 3 |
Select one:
| Course | Course Title | Class Hours | Lab/Shop Hours | Clinical/WBL Hours | Credit Hours |
|---|---|---|---|---|---|
| MAT 110 OR |
Mathematical Measurement and Literacy NEW VERSION |
(2) | (2) | (0) | (3) |
| MAT 143 OR |
Quantitative Literacy NEW VERSION |
2 | 2 | 0 | 3 |
| MAT 171 | Precalculus Algebra NEW VERSION |
(3) | (2) | (0) | (4) |
Totals
Class Hours: 12
Lab/Shop Hours: 7
Clinical/WBL Hours: 0
Credit Hours: 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:
| Course | Course Title | Class Hours | Lab/Shop Hours | Clinical/WBL Hours | Credit Hours |
|---|---|---|---|---|---|
| COM 120 OR |
Intro Interpersonal Com REVISED |
(3) | (0) | (0) | (3) |
| COM 231 OR |
Public Speaking REVISED REQUISITE |
(3) | (0) | (0) | (3) |
| ENG 114 OR |
Prof Research & Reporting |
(3) | (0) | (0) | (3) |
| ENG 116 | Technical Report Writing |
3 | 0 | 0 | 3 |
Totals
Class Hours: 6
Lab/Shop Hours: 6
Clinical/WBL Hours: 0
Credit Hours: 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 |
Totals
Class Hours: 5
Lab/Shop Hours: 10
Clinical/WBL Hours: 0
Credit Hours: 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:
| Course | Course Title | Class Hours | Lab/Shop Hours | Clinical/WBL Hours | Credit Hours |
|---|---|---|---|---|---|
| DBA 221 OR |
SQL Server DB Prog II |
(2) | (2) | (0) | (3) |
| DBA 223 | MySQL DB Programming II |
2 | 2 | 0 | 3 |
Select one:
| Course | Course Title | Class Hours | Lab/Shop Hours | Clinical/WBL Hours | Credit Hours |
|---|---|---|---|---|---|
| DBA 271 OR |
SQL Server Perf Tuning | (2) | (2) | (0) | (3) |
| DBA 273 | MySQL Performance Tuning | 2 | 2 | 0 | 3 |
Totals
Class Hours: 8
Lab/Shop Hours: 14
Clinical/WBL Hours: 0
Credit Hours: 15
Total Credit Hours: 64
Legend
- : Comprehensive Articulation Agreement - This course is recommended for students transferring to a four-year university.
- : Local Requirement
- : Instructional Service Agreement
- : Universal General Education Transfer Component (UGETC)
- : Global Distinction
- : Requisite(s)
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 REVISED
