2024-2025 Catalog 
  
    May 19, 2024  
2024-2025 Catalog

Information Technology AAS - Database Programming and Administration Program


Return to {$returnto_text} Return to: Academic Programs (A-Z)

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 (PLOs)

  1. Design, implement and administer databases.
  2. 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).
  3. Analyze a business situation and develop a database application that meets customer requirements.
  4. 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.
  5. 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


Subtotal: 15 Credits


Second Semester


Subtotal: 15 Credits


Third Semester


Subtotal: 14 Credits


Fourth Semester


Subtotal: 16 Credits


General Education Requirements


Subtotal: 6 Credits


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).

Subtotal: 6 Credits


Mathematics, Natural Science, and Technology


  • MAT Mathematics Elective† 4-credit Mathematics Elective OR (3-credit Mathematics Elective AND 1-credit INF restricted elective); 4 Credit(s)
  • Natural Science Elective† select from the following fields: BIO, CHM, PHY 4 Credit(s)

Subtotal: 8 Credits


Subtotal: 20-22


Free Elective ^^


Subtotal: 6


Subtotal: 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-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.

Return to {$returnto_text} Return to: Academic Programs (A-Z)