Computer Systems
COMP 4663 - Microsoft SQL Server 2000 Design and Administration

Continuing from COMP 1630, students who already understand RBDMS theory, data modelling and SQL programming are provided with an in-depth understanding of designing, implementing and fine-tuning Microsoft SQL 2000 Server databases. Topics include: architecture overview, advanced queries and views, tutorial on SQL Server utilities, transactions, optimization and monitoring performance.There will be emphasis on Transact-SQL, and students will be given advanced topics and exercises on functions (both built in and user defined), cursors, stored procedures, and triggers.This course helps prepare the MS Certified Database Administrator (MCDBA) and an elective for the MCSE (Exam# 70-229). Please Note: There is also a series of MS SQL 2005 courses starting with COMP 4677. Prerequisites: COMP 2712

This course isn't currently offered. Please check back next term or contact the appropriate Program Assistant [PDF] to determine when this course will be offered again.