2018-2019 Catalog 
    
    Oct 17, 2021  
2018-2019 Catalog [ARCHIVED CATALOG]

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.