Database Management Technology (DBA)

Courses

DBA 110. Database Concepts. 3.0 Credits. Class-2.0. Clinical-0.0. Lab-3.0. Work-0.0

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.

Prerequisites: Take CIS 110 or CTI 110 Minimum grade C

DBA 112. Database Utilization. 3.0 Credits. Class-2.0. Clinical-0.0. Lab-2.0. Work-0.0

This course introduces basic database functions and uses. Emphasis is placed on database manipulation with queries, reports, forms, and some table creation. Upon completion, students should be able to enter and manipulate data from the end user mode.

Prerequisites: Take CIS 110 CTI 110 or DBA 110 Minimum grade C

DBA 115. Database Applications. 3.0 Credits. Class-2.0. Clinical-0.0. Lab-2.0. Work-0.0

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.

Prerequisites: Take DBA 110

DBA 120. Database Programming I. 3.0 Credits. Class-2.0. Clinical-0.0. Lab-2.0. Work-0.0

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.

Prerequisites: Take CTI 110 or DBA 110 Minimum grade C

DBA 125. Database Reporting. 3.0 Credits. Class-2.0. Clinical-0.0. Lab-2.0. Work-0.0

This course provides a survey of the tools used in designing, creating and publishing database reports. Topics include both relational and XML datasets. Upon completion, students should be able to demonstrate an understanding of the different tools and frameworks used for database reporting.

Prerequisites: Take DBA 120 Minimum grade C

DBA 210. Database Administration. 3.0 Credits. Class-2.0. Clinical-0.0. Lab-3.0. Work-0.0

This course covers database administration issues and distributed database concepts. Topics include database administrator (DBA) goals and functions, backup and recovery, standards and procedures, training, and database security and performance evaluations. Upon completion, students should be able to produce functional DBA documentation and administer a database.

Prerequisites: Take DBA 110 Minimum grade C

DBA 220. Oracle Database Programming II. 3.0 Credits. Class-2.0. Clinical-0.0. Lab-2.0. Work-0.0

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 an Oracle DBMS application which includes a GUI front-end and report generation.

Prerequisites: Take DBA 120 Minimum grade C

DBA 221. SQL Server Database Programming II. 3.0 Credits. Class-2.0. Clinical-0.0. Lab-2.0. Work-0.0

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.

Prerequisites: Take DBA 120

DBA 285. Data Warehousing and Mining. 3.0 Credits. Class-2.0. Clinical-0.0. Lab-3.0. Work-0.0

This course introduces data warehousing and data mining techniques. Emphasis is placed on data warehouse design, data transference, data cleansing, retrieval algorithms, and mining techniques. Upon completion, students should be able to create, populate, and mine a data warehouse.

Prerequisites: Take DBA 120 Minimum grade C