Thomas College

Course Information

another search

Number:CS223
Name:Database Management Systems
Description:This course deals with the interaction with, software for, and management of database systems. This course focuses on installing and configuring database software. It deals with the process of creating tables, queries, and reports as well as the rules of performance tuning. Maintaining a secure database environment is stressed. Students will be given the opportunity to write SQL statements that query and manipulate the database, as well as how to maintain the integrity of the database through backups and restores.
Credit(s):3
Offered (DAY schedule):
Instructor Permission Required:N
Pre-Requisite(s): CS117

Course Objectives

By the end of this course, students should be able to: Plan a MS SQL Server Installation based on hardware and environmental requirements ? Install MS SQL Server, multiple instances of MS SQL Server and the client & administration tools required to connect to MS SQL Server ? Explain the design and choices of a MS SQL Server Installation ? Administrate & Secure a MS SQL Server ? Monitor & Optimize MS SQL Server depending on the environment ? Effectively research and troubleshoot issues that occur with a working installation of MS SQL Server ? Write SQL SELECT, INSERT, UPDATE, and DELETE queries. ? Integrate databases with web-based front-ends.

Books Previously Used in this Course

Term Year Title ISBN Author Edition Publisher
S 2012 Modern Database Management 0136088392 Hoffer 10 Prentice Hall
S 2009 Beginning SQL Server 2005 Administration 9780470047040 Dan Wood Wrox
F 2005 MCSE GUIDE TO MS SQL SERVER 2000..-W/CD RAFTREE 2
F 2005 MICROSOFT SQL SERVER 2000 ADMIN.LAB.MAN YORK-LEVINE 2
F 2004 SQL Server 2000 Administration 0-619-03553-6 Raftree, Mathew Course Technology
F 2004 SQL Server 2000 Administration Lab Manual 0-619-12059-2 York-Levine, Karen Course Technology