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 NEW
A25590DA
NC CIP: 11.0103
Day, Evening, and Online
POS Approved: Fall 2017
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 NEW 2017FA | 2 | 2 | 0 | 3 |
| CTI 120 | Network & Sec Foundation NEW 2017FA | 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 2017FA |
(3) | (0) | (0) | (3) |
| ENG 111 | Writing and Inquiry   |
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 |
|---|---|---|---|---|---|
| DBA 110 | Database Concepts | 2 | 3 | 0 | 3 |
| DBA 120 | Database Programming I NEW REQUISITE 2017FA |
2 | 2 | 0 | 3 |
| SEC 110 | Security Concepts | 2 | 2 | 0 | 3 |
Select one:
| Course | Course Title | Class Hours | Lab/Shop Hours | Clinical/WBL Hours | Credit Hours |
|---|---|---|---|---|---|
| MAT 110 OR |
Mathematical Measurement and Literacy |
(2) | (2) | (0) | (3) |
| MAT 143 OR |
Quantitative Literacy |
2 | 2 | 0 | 3 |
| MAT 171 | Precalculus Algebra |
(3) | (2) | (0) | (4) |
Totals
Class Hours: 8
Lab/Shop Hours: 9
Clinical/WBL Hours: 0
Credit Hours: 12
Summer Term
| Course | Course Title | Class Hours | Lab/Shop Hours | Clinical/WBL Hours | Credit Hours |
|---|---|---|---|---|---|
| CTI 141 | Cloud & Storage Concepts NEW 2017FA | 1 | 4 | 0 | 3 |
| CTS 115 | Info Sys Business Concept |
3 | 0 | 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 |
(3) | (0) | (0) | (3) |
| COM 231 OR |
Public Speaking |
(3) | (0) | (0) | (3) |
| ENG 114 OR |
Prof Research & Reporting |
(3) | (0) | (0) | (3) |
| ENG 116 | Technical Report Writing NEW 2017FA |
3 | 0 | 0 | 3 |
Totals
Class Hours: 7
Lab/Shop Hours: 4
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 NEW REQUISITE 2017FA |
2 | 3 | 0 | 3 |
| DBA 240 | Database Analysis/Design NEW REQUISITE 2017FA |
2 | 3 | 0 | 3 |
| NET 125 | Introduction to Networks NEW VERSION 2017FA | 1 | 4 | 0 | 3 |
| NET 126 | Routing Basics NEW VERSION 2017FA |
1 | 4 | 0 | 3 |
| ___ ___ | Elective List 1 | ** | ** | ** | 1 |
Totals
Class Hours: 6
Lab/Shop Hours: 14
Clinical/WBL Hours: 0
Credit Hours: 13
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 NEW VERSION 2017FA |
1 | 4 | 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 |
|---|---|---|---|---|---|
| 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 NEW VERSION 2017FA | (2) | (2) | (0) | (3) |
| DBA 273 | MySQL Performance Tuning NEW VERSION 2017FA | 2 | 2 | 0 | 3 |
Totals
Class Hours: 10
Lab/Shop Hours: 10
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
