Database Administration Courses & Descriptions
2011-2012
DBA 130 Database Theory • 5 CR
Develops in-depth understanding of database concepts and terminology, emphasizing the relational databases model. Understanding the role of Structured Query Language (SQL), data modeling and normalization of database tables. Prerequisite: BTS 168 with a C- or better. Placement by assessment into ENGL 089 and ENGL 092 or 093 with a C- or better.
DBA 232 Database Administration • 5 CR
Develops the concepts and skills required to perform the duties of Database Administrator (DBA) in organizations using large relational databases. Students develop coherent plans for security, disaster recovery, backup and restore, replication and other administrative functions, including the creation and use of SQL scripts to automate administrative tasks. Prerequisite: DBA 130 with a C- or better. Placement by assessment into ENGL& 101 or ENGL 092 or 093 with a C- or better.
DBA 233 Advanced Database Administration • 5 CR
Provides students with advanced concepts and hands-on practice in database administration. Topics include: creating and managing indexes, multi-user issues (locks, data integrity), replication, data warehousing, data analysis services, advanced Data Transformation Services, full text search and English query. Prerequisite: DBA 232 with a C- or better or entry code.
DBA 294/295/296/297 Special Topics in Database Administration • V1-10 CR
Allows specialized or in-depth study of a subject related to database administration. Topics are announced in the quarterly schedule. May be repeated for a maximum of 15 credits of different topics. Prerequisite: Permission of instructor.
DBA 299 Individual Studies in Database Administration • V1-10 CR
Covers directed readings, special projects, and independent study by an individual student. May be repeated for a maximum of 15 credits. Prerequisite: Permission of instructor.
2010-2011
DBA 130 Database Theory • 5 CR
Develops in-depth understanding of database concepts and terminology, emphasizing the relational databases model. Understanding the role of Structured Query Language (SQL), data modeling and normalization of database tables. Prerequisite: Placement by assessment into ENGL 089 and ENGL 092 or 093 and BTS 168 with a C- or better.
DBA 232 Database Administration • 5 CR
Develops the concepts and skills required to perform the duties of Database Administrator (DBA) in organizations using large relational databases. Students develop coherent plans for security, disaster recovery, backup and restore, replication and other administrative functions, including the creation and use of SQL scripts to automate administrative tasks. Prerequisite: Placement by assessment into ENGL& 101 or ENGL 092 or 093 and DBA 130 with a C- or better.
DBA 233 Advanced Database Administration • 5 CR
Provides students with advanced concepts and hands-on practice in database administration. Topics include: creating and managing indexes, multi-user issues (locks, data integrity), replication, data warehousing, data analysis services, advanced Data Transformation Services, full text search and English query. Prerequisite: DBA 232 with a C- or better, or entry code.
DBA 294/295/296/297 Special Topics in Database Administration • V 1-10 CR
Allows specialized or in-depth study of a subject related to database administration. Topics are announced in the quarterly schedule. May be repeated for a maximum of 15 credits of different topics. Prerequisite: Permission of instructor.
DBA 299 Individual Studies in Database Administration • V 1-10 CR
Covers directed readings, special projects, and independent study by an individual student. May be repeated for a maximum of 15 credits. Prerequisite: Permission of instructor.
