ITSE 2333 - Implementing a Database on Microsoft SQL Server

3 Credits (2 hrs. lec., 3 hrs. lab.) Skills development in the implementation of a database solution using Microsoft SQL Server client/server database management system. Prerequisite: ITSW 1307 and ITSE 1302
Course Outcomes
1 - Describe the elements of Microsoft SQL Server and its operational environments.
2 - Describe the elements of the Transact-SQL language.
3 - Demonstrate and configure the data storage architecture of SQL server.
4 - Write, maintain, and tune advanced queries.
5 - Manage locking options and transactions to ensure data concurrency and recoverability.
6 - Create views of data.
7 - Design and create stored procedures.
8 - Design and create triggers.
9 - Use distributed data.