CIS 243: Database Administration

Course Description

Provides students with hands-on experience installing, configuring, maintaining and supporting a currently popular relational database management system (DBMS). Includes installation, configuration, backup and restore, security, performance monitoring and replication. Recommended preparation: CIS 143 or equivalent experience.

Course Outline

  1. Introduction
  2. Installing and Navigating Microsoft SQL Server 2005
  3. Datatypes and Databases
  4. Tables and Performing Indexing and Full-Text Searching
  5. Views and Constraints
  6. Stored Procedures and Triggers
  7. Functions and Transactions and Locks
  8. Moving Data and XML Data
  9. Permissions and Backing Up and Restoring
  10. Maintaining, Automating, Monitoring and Optimizing SQL Server
  11. High-Availability Methods and Replication
  12. Service Broker and Endpoints

Required Materials

  • Textbook
  • Internet access and a Harper Blackboard account.
  • Access to a computer running a licensed or free trial version of Microsoft SQL Server 2005. Harper lab I 205 has computers and software that may be configured as necessary for this course.

Faculty Contact

For questions about this course contact the department coordinator:

Dave Braunschweig
dbraunsc@harpercollege.edu
847.925.6817