Database Management Technology (DBA)

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.

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.

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 118. Google Data Analytics I. 3.0 Credits. Class-1.0. Clinical-0.0. Lab-6.0. Work-0.0

This course introduces the role of a Google data analyst and how to make data-driven decisions using effective questions, data transformation and analyzation processes. Emphasis is placed on setting up a data toolbox, spreadsheets, database and query basics, visualization basics, effective communication techniques, and data validation. Upon completion, students should be able to review assessments, use formulas and calculations to analyze datasets, create queries, use visualization tools and communicate effectively with stakeholders.

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.

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.

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.

DBA 218. Google Data Analytics II. 3.0 Credits. Class-2.0. Clinical-0.0. Lab-3.0. Work-0.0

This course introduces the role of an advanced Google data analyst and how to make data-driven decisions using effective questions, data transformation, analyzation processes, visualization and programming. Emphasis is placed on setting up a design thinking, data-driven storytelling, dashboards, R programming, job portfolios and technical expertise. Upon completion, students should be able to create a data-driven storyboard, develop dashboards and presentations, create analytical reports using R, and showcase technical analytical skills.

Corequisites: Take DBA 118

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

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.