Lecture Lab Credit
DBA 110 Database Concepts 2 3 3
Prerequisites: CIS 110 or CIS 111 or CIS 115 Corequisites: None
This course introduces database design and creation using a DBMS product. Emphasis is placed on data dictionaries, nor- malization, 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. . This course is taught online and web enhanced; online testing and Internet access will be utilized; installation of Oracle Personal edition, MS Access, and SQL Server are required for online sections.
DBA 112 Database Utilization 2 2 3
Prerequisites: CIS 110 or CIS 111 or OST 137 Corequisites: None
This course introduces basic database functions and uses. Emphasis is placed on database manipulation with queries, reports, forms, and some table creation. Upon completion, stu- dents should be able to enter and manipulate data from the end user mode. . This course is taught online and web enhanced; online testing and Internet access will be utilized; installation of MS Access is required for online sections.
DBA 115 Database Applications 2 2 3
Prerequisites: DBA 110 Corequisites: None
This course applies concepts learned in DBA110 to a specif- ic DBMS. Topics include manipulating multiple tables, advanced queries, screens and reports, linking, and command files. Upon completion, students should be able to create multi- ple table systems that demonstrate updates, screens, and reports representative of industry requirements. This course is taught online and web enhanced; online testing and Internet access will be utilized; installation of Oracle Personal edition is required for online sections.
DBA 120 Database Programming I 2 2 3
Prerequisites: DBA 110 and DBA 115 Corequisites: None
This course is designed to develop SQL programming profi- ciency. Emphasis is placed on data definition, data manipula- tion, 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. . This course is taught online and web enhanced; online testing and Internet access will be utilized; installation of Oracle Personal edition is required for online sections.
DBA 210 Database Administration 2 3 3
Prerequisites: DBA 110 or DBA 115 or DBA 120 Corequisites: None
This course covers database administration issues and dis- tributed database concepts. Topics include: database administra- tor (DBA) goals and functions, backup and recovery, standards and procedures, training, and database security and performance evaluations. Upon completion, students should be able to func- tions DBA documentation and administer a database. This course is taught online and web enhanced; online testing and Internet access will be utilized; installation of Oracle Personal edition is required for online sections.
CENTRAL PIEDMONT COMMUNITY COLLEGE
271
College-Level Credit Course Descriptions
DBA 220 Oracle Database Programming II 2 2 3 Prerequisites: DBA 120
Corequisites: None
This course is designed to enhance programming skills developed in DBA120. Topics include application development with GUI front-ends and embedded programming. Upon com- pletion, students should be able to develop an Oracle DBMS application which includes a GUI front-end and report genera- tion. This course is taught online and web enhanced; online test- ing and Internet access will be utilized; installation of Oracle Personal edition is required for online sections.
DBA 221 SQL Server Database
Programming II 2 2 3
Prerequisites: DBA 120 Corequisites: None
This course is designed to enhance programming skills developed in DBA120. Topics include application development with GUI front-ends and embedded programming. Upon com- pletion, students should be able to develop a SQL Server DBMS application which includes a GUI front-end and report genera- tion. This course is taught online and web enhanced; online test- ing and Internet access will be utilized; installation of SQL Server is required for online sections.
DBA 222 DB2 Database
Programming II 2 2 3
Prerequisites: DBA 120 Corequisites: None
This course is designed to enhance programming skills developed in DBA120. Topics include application development with GUI front-ends and embedded programming. Upon com- pletion, students should be able to develop a DB2 DBMS appli- cation which includes a GUI front-end and report generation. This course is taught online and web enhanced; online testing and Internet access will be utilized; installation of DB2 is required for online sections.
DBA 223 MySQL Database
Programming II 2 2 3
Prerequisites: DBA 120 Corequisites: None
This course is designed to enhance programming skills developed in DBA120. Topics include application development with GUI front-ends and embedded programming. Upon com- pletion, students should be able to develop a MySQL DBMS application which includes a GUI front-end and report genera- tion. This course is taught online and web enhanced; online test- ing and Internet access will be utilized; installation of MySQL is required for online sections.
DBA 224 SAS Database
Programming II 2 2 3
Prerequisites: DBA 120 Corequisites: None
This course is designed to enhance programming skills developed in DBA120. Topics include application development with GUI front-ends and embedded programming. Upon com- pletion, students should be able to develop a SAS DBMS appli- cation which includes a GUI front-end and report generation. This course is taught online and web enhanced; online testing and Internet access will be utilized; installation of SAS is required for online sections.
DBA 230 Database in Corporate
Environments 3 0 3
Prerequisites: DBA 110 Corequisites: None
This course covers database systems as they relate to the cor- porate environment. Topics include knowledge-based, decision- support, 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 &
Design 3 0 3
Prerequisites: DBA 110 Corequisites: None
This course is an exploration of the established and evolving methodologies for analysis, design, and development of a data- base system. Emphasis is placed on business data characteristics and usage, managing database projects, prototyping and model- ing, and CASE tools. Upon completion, students should be able to analyze, develop, and validate a database implementation plan.
DBA 260 Oracle Database Administration 2 2 3 Prerequisites: DBA 210
Corequisites: None
This course examines advanced Oracle database administra- tion issues and distributed database concepts. Topics include backup and recovery, transporting of data between databases, database networking concepts, and resolution of database net- working issues. Upon completion, students should be able to manage backup recovery and implement networked database solutions. This course is taught online and web enhanced; online testing and Internet access will be utilized; installation of Oracle Personal edition is required for online sections.
DBA 261 SQL Server Database
Administration 2 2 3
Prerequisites: None Corequisites: None
This course examines advanced SQL Server database administration issues and distributed database concepts. Topics include backup and recovery, transporting of data between data- bases, database networking concepts, and resolution of database networking issues. Upon completion, students should be able to manage backup recovery and implement networked database solutions. This course is taught online and web enhanced; online testing and Internet access will be utilized; installation of SQL Server is required for online sections.
DBA 262 DB2 Database Administration 2 2 3 Prerequisites: None
Corequisites: None
This course examines advanced DB2 database administra- tion issues and distributed database concepts. Topics include backup and recovery, transporting of data between databases, database networking concepts, and resolution of database net- working issues. Upon completion, students should be able to manage backup recovery and implement networked database solutions. This course is taught online and web enhanced; online testing and Internet access will be utilized; installation of DB2 is required for online sections.
272
College-Level Credit Course Descriptions
DBA 263 MySQL Database Administration 2 2 3 Prerequisites: None
Corequisites: None
This course examines advanced MySQL database adminis- tration issues and distributed database concepts. Topics include backup and recovery, transporting of data between databases, database networking concepts, and resolution of database net- working issues. Upon completion, students should be able to manage backup recovery and implement networked database solutions. This course is taught online and web enhanced; online testing and Internet access will be utilized; installation of MySQL is required for online sections.
DBA 264 SAS Database Administration 2 2 3 Prerequisites: None
Corequisites: None
This course examines advanced SAS database administra- tion issues and distributed database concepts. Topics include backup and recovery, transporting of data between databases, database networking concepts, and resolution of database net- working issues. Upon completion, students should be able to manage backup recovery and implement networked database solutions. This course is taught online and web enhanced; online testing and Internet access will be utilized; installation of SAS is required for online sections.
DBA 270 Oracle Performance Tuning 2 2 3 Prerequisites: NOS 130 and (DBA 210 or DBA 260) Corequisites: None
This course covers Oracle performance tuning concepts and techniques. Topics include database tuning and Oracle perfor- mance tools. Upon completion, students should be able to con- figure and diagnose an Oracle database for optimal
performance. This course is taught online and web enhanced; online testing and Internet access will be utilized; installation of Oracle Personal Edition is required for online sections.
DBA 271 SQL Server Performance
Tuning 2 2 3
Prerequisites: NOS 130 and DBA 261 Corequisites: None
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 a SQL Server database for optimal per- formance. This course is taught online and web enhanced; online testing and Internet access will be utilized; installation of SQL Server is required for online sections.
DBA 272 DB2 Performance
Tuning 2 2 3
Prerequisites: NOS 130 and DBA 262 Corequisites: None
This course covers DB2 performance tuning concepts and techniques. Topics include database tuning and DB2 perfor- mance tools. Upon completion, students should be able to con- figure and diagnose a DB2 database for optimal performance. This course is taught online and web enhanced; online testing and Internet access will be utilized; installation of DB2 is required for online sections.
DBA 273 MySQL Performance Tuning 2 2 3 Prerequisites: NOS 130 and DBA 263
Corequisites: None
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 perfor- mance. This course is taught online and web enhanced; online testing and Internet access will be utilized; installation of MySQL is required for online sections.
DBA 274 SAS Performance Tuning 2 2 3
Prerequisites: NOS 130 and DBA 264 Corequisites: None
This course covers SAS performance tuning concepts and techniques. Topics include database tuning and SAS perfor- mance tools. Upon completion, students should be able to con- figure and diagnose a SAS database for optimal performance. This course is taught online and web enhanced; online testing and Internet access will be utilized; installation of SAS is required for online sections.
DBA 285 Data Warehousing & Mining 2 2 3 Prerequisites: NOS 130
Corequisites: None
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. This course is taught online and web enhanced; online testing and Internet access will be utilized.
DBA 289 Database Project 1 4 3
Prerequisites: DBA 240 and DBA 120 Corequisites: None
This course provides an opportunity to complete a signifi- cant database systems project with minimal instructor support. Emphasis is placed on written and verbal communication skills, documentation, presentation, and user training. Upon comple- tion, students should be able to present an operational database system which they have created. This course is taught online and web enhanced; online testing and Internet access will be utilized.