College Catalog

Database Concepts, Database Programming I, SQL Server DB Prog II

Courses are listed by course discipline prefix, number, course title, credit hours, and, in parentheses, the number of lecture, laboratory and/or work experience/clinical hours, and the semester the course is offered. Local and state prerequisites and corequisites are identified by superscript L for localL and S for stateS. The symbol “AND” indicates the course will be offered “As Needs Demand.”

UGETC represents the Universal General Education Transfer Component as described in the Comprehensive Articulation Agreement (CAA).

Prefix Number Title Hours Semester
DBA 110 Database Concepts 3 (2-3) Fall

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. (2006 SP)

Prefix Number Title Hours Semester
DBA 120 Database Programming I 3 (2-2) Fall

This course is designed to develop SQL programming proficiency. Emphasis is placed on data definition, data manipulation, and data control statements as well as on report generation. Upon completion, students should be able to write programs which create, update, and produce reports. (2006 SP)

Prefix Number Title Hours Semester
DBA 221 SQL Server DB Prog II 3 (2-2) Spring

Prerequisite: DBA-120S

This course is designed to enhance programming skills developed in DBA 120. Topics include application development with GUI front-ends and embedded programming. Upon completion, students should be able to develop a SQL Server DBMS application which includes a GUI front-end and report generation. (2006 SP)