CSI 258 - SQL Server Development and Administration

Credits 7
This course is designed for the student who is already familiar with basic relational database theory. The focus of this course is on the database portion of the n-tier client/server development model and data warehousing. Microsoft SQL Server for Windows is the primary tool. Students learn Structured Query Language (Transact SQL) and receive hands-on instruction in how to administer an enterprise database server. Administrative topics include database creation and administration, user management, security, and performance tuning. Development topics include relational database normalization concepts, writing queries (including joins and nested queries), stored procedures, triggers, cursors, transactions and creation of schemas using Data Definition Language. Appropriate use of indexes is also covered. There is an introduction to data warehousing topics including analysis of business requirements, defining technical architecture for a data warehouse, deriving the physical design, creating data services and creating the physical database.
Prerequisite(s): CSI 101 and CSI 159.