DBA – Database Management Technology

All courses are alphabetized by course code. All courses are to be pursued in a normal sequence with prerequisite courses taken as indicated. Provided for each course is the following information: course number and title; number of class, laboratory, clinical/shop/work experience (if any), and credit hours; and the semester in which the course is offered - FA (Fall), SP (Spring), and SU (Summer).

DBA-110 Database Concepts (2 3 0 3)

This course introduces database design and creation using a DBMS product. Emphasis is placed on data dictionaries, normalization, data integrity, data modeling, and creation of simple tables, queries, reports, and forms. Upon completion, students should be able to design and implement normalized database structures by creating simple database tables, queries, reports, and forms. (SP). National ID (CIP) 11.0802 Data Modeling/Warehousing and Database Administration.

DBA-115 Database Applications (2 2 0 3)

This course applies concepts learned in DBA 110 to a specific DBMS. Topics include manipulating multiple tables, advanced queries, screens and reports, linking, and command files. Upon completion, students should be able to create multiple table systems that demonstrate updates, screens, and reports representative of industry requirements. State prerequisites: Take DBA-110. (SP). National ID (CIP) 11.0802 Data Modeling/Warehousing and Database Administration.