Database Administration (DBA)
|
|---|
| DBA-110 |
Database Concepts |
2 |
3 |
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. |
|
| DBA-112 |
Database Utilization |
2 |
2 |
3 |
|
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 |
2 |
2 |
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. |
|
| DBA-120 |
Database Programming I |
2 |
2 |
3 |
|
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-210 |
Database Administration |
2 |
3 |
3 |
|
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-220 |
Oracle Database Programming II |
2 |
2 |
3 |
|
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. |
|
| DBA-221 |
SQL Server Database Programming II |
2 |
2 |
3 |
|
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. |
|
| DBA-222 |
DB2 Database Programming II |
|
|
|
|
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 DB2 DBMS application which includes a GUI front-end and report generation. |
|
| DBA-223 |
MySQL Database Programming II |
|
|
|
|
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 MySQL DBMS application which includes a GUI front-end and report generation. |
|
| DBA-224 |
SAS Database Programming II |
|
|
|
|
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 SAS DBMS application which includes a GUI front-end and report generation. |
|
| DBA-230 |
Databases in Corporate Environments |
3 |
0 |
3 |
|
This course covers database systems as they relate to the corporate environment. Topics include knowledge-based, decision-support, and expert systems; database choices; data warehousing; and corporate structure. Upon completion, students should be able to analyze and recommend database systems needed by a corporation. |
|
| DBA-240 |
Database Analysis and Design |
3 |
2 |
3 |
|
This course is an exploration of the established and evolving methodologies for the analysis, design, and development of a database system. Emphasis is placed on business data characteristics and usage, managing database projects, prototyping and modeling, and CASE tools. Upon completion, students should be able to analyze, develop, and validate a database implementation plan. |
|
| DBA-260 |
Oracle Database Management System Admin |
2 |
2 |
3 |
|
This course examines advanced Oracle database administration issues and distributed database concepts. Topics include backup and recovery, transporting of data between databases, database networking concepts, and resolution of database networking issues. Upon completion, students should be able to manage backup recovery and implement networked database solutions. |
|
| DBA-261 |
SQL Server Database Management System Administration |
2 |
2 |
3 |
|
This course examines advanced SQL Server database administration issues and distributed database concepts. Topics include backup and recovery, transporting of data between databases, database networking concepts, and resolution of database networking issues. Upon completion, students should be able to manage backup recovery and implement networked database solutions. |
|
| DBA-262 |
DB2 Database Management System Admin |
|
|
|
|
This course examines advanced DB2 database administration issues and distributed database concepts. Topics include backup and recovery, transporting of data between databases, database networking concepts, and resolution of database networking issues. Upon completion, students should be able to manage backup recovery and implement networked database solutions. |
|
| DBA-263 |
MySQL Database Management System Admin |
|
|
|
|
This course examines advanced MySQL database administration issues and distributed database concepts. Topics include backup and recovery, transporting of data between databases, database networking concepts, and resolution of database networking issues. Upon completion, students should be able to manage backup recovery and implement networked database solutions. |
|
| DBA-264 |
SAS Database Management System Admin |
|
|
|
|
This course examines advanced SAS database administration issues and distributed database concepts. Topics include backup and recovery, transporting of data between databases, database networking concepts, and resolution of database networking issues. Upon completion, students should be able to manage backup recovery and implement networked database solutions. |
|
| DBA-270 |
Oracle Performance Tuning |
2 |
2 |
3 |
|
This course covers Oracle performance tuning concepts and techniques. Topics include database tuning and Oracle performance tools. Upon completion, students should be able to configure and diagnose an Oracle database for optimal performance. |
|
| DBA-271 |
SQL Server Performance Tuning |
2 |
2 |
3 |
|
This course covers SQL Server performance tuning concepts and techniques. Topics include database tuning and SQL Server performance tools. Upon completion, students should be able to configure and diagnose an SQL Server database for optimal performance. |
|
| DBA-272 |
DB2 Performance Tuning |
|
|
|
|
This course covers DB2 performance tuning concepts and techniques. Topics include database tuning and DB2 performance tools. Upon completion, students should be able to configure and diagnose a DB2 database for optimal performance. |
|
| DBA-273 |
MySQL Performance Tuning |
|
|
|
|
This course covers MySQL performance tuning concepts and techniques. Topics include database tuning and MySQL performance tools. Upon completion, students should be able to configure and diagnose a MySQL database for optimal performance. |
|
| DBA-274 |
SAS Performance Tuning |
|
|
|
|
This course covers SAS performance tuning concepts and techniques. Topics include database tuning and SAS performance tools. Upon completion, students should be able to configure and diagnose a SAS database for optimal performance. |
|
| DBA-285 |
Data Warehousing and Mining |
2 |
2 |
3 |
|
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. |
|
| DBA-289 |
Database Project |
1 |
4 |
3 |
|
This course provides an opportunity to complete a significant database systems project with minimal instructor support. Emphasis is placed on written and verbal communication skills, documentation, presentation, and user training. Upon completion, students should be able to present an operational database system which they have created. Mortuary Law, OSHA requirements, anatomical donations, vital statistics, and general law relative to mortuary law. Upon completion, students should be able to demonstrate an understanding of the legal and ethical aspects of |
|
