Information Technology AAS – Database Programming and Administration Program
Code: AAS.IT.DB
This program emphasizes computer programming skills and database management. Three semesters of programming language courses, three semesters of database courses, and systems analysis courses help prepare the student to actively participate in real-world software development projects.
Program Learning Outcomes
- Design, implement and administer databases.
- Design a normalized database, create a conceptual model, create the physical model and
manipulate the database using structured query language (SQL), data definition language
(DDL), data manipulation language (DML), transaction control language (TCL) and data
control language (DCL).
- Analyze a business situation and develop a database application that meets customer
requirements.
- Create database applications using a procedural language extension to SQL. Include
procedural language constructs, exception handling as well as using, creating and
managing subprograms, packages, and triggers.
- Install, configure, deploy and administer database servers. Resolve basic installation and
configuration issues, data management, backup, recovery, transfer of data between
databases, user administration and network configuration.
Career Pathways
| Computer programmer |
Software / Application Developer |
Computer Systems Analyst |
| Database Administrator |
|
|
Recommended Semester Sequence
First Semester
| |
Humanities or Social Science Elective† |
3 |
| INF-101 | Introduction to Information Technology | 3 |
| INF-103 | Introduction to Programming (Python) | 3 |
| INF-160 | Networking Technologies and Data Communications | 3 |
| WRT-101 | English Composition I | 3 |
| Total Credit Hours: | 15 |
Second Semester
| INF... |
Programming Language Fundamentals Elective** |
3 |
| ....... |
Humanities or Social Sciences Elective† |
3 |
Third Semester
| MAT/INF |
Mathematics Elective†
4-credit Mathematics Elective† OR ( 3-credit Mathematics Elective AND 1-credit INF restricted elective* )
|
4 |
| INF |
1-credit INF Restricted Elective* |
1 |
| |
Free Elective^^ |
3 |
| INF-208 | Systems Analysis and Design | 3 |
| INF-217 | Database for Applications [Oracle] | 3 |
| Total Credit Hours: | 14 |
Fourth Semester
| |
Free Elective^^ |
3 |
| |
Natural Science Elective† |
4 |
| INF |
Advanced Programming Language Elective*** |
3 |
| INF-218 | Database Programming [Oracle-PL/SQL] | 3 |
| INF-219 | Database Administration | 3 |
| Total Credit Hours: | 16 |
General Education Requirements
Communication
| WRT-101 | English Composition I | 3 |
| WRT-201 | English Composition II | 3 |
| - | or | |
| WRT-202 | Technical Writing | 3 |
| Total Credit Hours: | 6 |
Humanities and Social Sciences†
Two general education courses selected from the following fields, with no more than one course in any one field: Arts (Art [ART], Music [MUS], Theatre Arts [THR], Cinema Studies [CIN]); History (HIS); Literature (LIT); Philosophy and Religion (PHR); World Languages and Cultures (LAN); Economics (ECO); Geography (GEO); Political Science (POL); Psychology (PSY); Sociology (SOC) and Anthropology (ANT).
Mathematics, Natural Science, and Technology
| MAT |
Mathematics Elective†
4-credit Mathematics Elective OR (3-credit Mathematics Elective AND 1-credit INF restricted elective);
|
4 |
| |
Natural Science Elective†
select from the following fields: BIO, CHM, PHY
|
4 |
Total Credit Hours: 20-22
Program Requirements
| INF |
Programming Language Fundamentals Elective** |
3 |
| INF |
Advanced Programming Language Elective*** |
3 |
| INF |
1-credit INF Restricted Elective* |
1 |
| INF-101 | Introduction to Information Technology | 3 |
| INF-103 | Introduction to Programming (Python) | 3 |
| INF-146 | Web Development | 3 |
| INF-160 | Networking Technologies and Data Communications | 3 |
| INF-208 | Systems Analysis and Design | 3 |
| INF-217 | Database for Applications [Oracle] | 3 |
| INF-218 | Database Programming [Oracle-PL/SQL] | 3 |
| INF-219 | Database Administration | 3 |
Free Elective^^
Total Credit Hours: 45
Total Credit Hours: 60
Specific Program Notes
Students are encouraged to take their courses in semester sequence order.
Please note that required courses may have prerequisites. Click on each course to view details.
**Programming Language Fundamentals Elective – INF-220, INF-221, INF-236.
***Advanced Programming Language Elective – INF-224, INF-246, INF-268.
*1-credit INF Restricted Elective: INF-115, INF-120, INF-124, INF-143, INF-144, INF-151, INF-161, INF-162, INF-165, INF-228, INF-251, or INF-291.
†General Education Elective(s). Recommended Mathematics elective: MAT-180, MAT-280, or MAT-223.
(If a 3-credit Mathematics course is selected, a 1-credit INF restricted elective^ is required.)
^^ Recommended Free Electives: INF-130, INF-140, INF-239, INF-253, INF-254, INF-263, INF-271, BUS-101
Students enrolled in this program ARE REQUIRED to successfully complete a course in basic algebra if indicated by the Basic Skills Placement Test.