ITS 221M - Topics in System Development:Database Server Administration

Institution:

Kapiolani Community College

Subject:

Description:

3 hours lecture per week Prerequisite(s): ITS 151 and ITS 221F with a grade of "C" or higher or consent of Business Education Chairperson. program coordinator, or instructor.Comment: Hardware/software supplies for hands-on activities may cost up to $50. ITS 221M is designed to give the student a firm foundation in basic administrative tasks. The primary goal of this course is to give the student the necessary knowledge and skills to set up, maintain, and troubleshoot a network database. Students gain a thorough conceptual understanding of database architecture, and reinforce instructor-led learning with structured hands-on practices. The course uses challenge-level exercise labs providing practical experience. Additionally, bulletins from online support that address the most frequently asked questions are used to prepare participants to troubleshoot "real world" issues.Upon successful completion of ITS 221M, the student should be able to: Create and populate a database. Start up and shut down a database. Manage tablespaces. Configure rollback segments. Monitor space allocation. Create user accounts with appropriate privileges and resources. Partition tables and indexes. Detect and eliminate migrated rows. Back up and restore databases. Recover from disk failure. Eliminate chaining and optimize database storage.

Credits:

3.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

Institution Website:

kapiolani.hawaii.edu/page/home

Phone Number:

(808) 734-9000

Regional Accreditation:

Western Association of Schools and Colleges

Calendar System:

Semester

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.