Information Technology

Certificate of Competence in Database Administration

The Information Technology Certificate of Competence in Database Administration is a competency‑based program designed for the novice or professional Information Technology worker who has little to no experience in Database Administration. This certificate is appropriate for upgrading the Database Administration skills of industry members or for a focus for Information Technology AS students..

Courses

ITS 129 Introduction to Databases (3)
3 hours lecture per week
Prerequisite(s): Qualification for ENG 22 or ESOL 94 or higher; qualification for MATH 24 or higher.
Comment: Formerly ITS 113, Introduction to SQL and Database Design

ITS 129 is an introduction to databases. The course covers the tools needed to query and modify database objects. The course also introduces the student to database design concepts. A substantial part of the course involves the understanding of the relationship between databases, tables, records and fields. The course includes hands-on use in a computer environment that provides the students with experience designing, creating, and manipulating a database using the appropriate information technology tools.

ITS 149AD Database Administration I (3)
3 hours lecture per week
Prerequisite(s): ITS 129 or consent of the instructor or BE department chair
Comment: Formerly ITS 221F, Topics in System Development: Databases

ITS 149AD is designed to give students a firm foundation in basic database administration. In this class, students learn how to install and maintain a database server. They will gain a conceptual understanding of database server architecture and how its components work and interact with one another. They will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques.

ITS 229AD Database Administration II (3)
3 hours lecture per week
Prerequisite(s): ITS 149AD or consent of the instructor or BE department chair

ITS 229AD advances students’ knowledge of database administration. In this class, students will learn how to configure a database server for multilingual applications. They will practice various methods of recovering the database using RMAN and Flashback technology. Database performance monitoring tools will be covered, in addition to the steps to take to resolve common problems and improve performance. Students will also learn how to administer a database efficiently by using database technologies such as the Resource Manager, the Scheduler, Automatic Storage Management (ASM), and VLDB features. They will set up a secure database using Virtual Private Database, and learn how to efficiently move data from database to database.