|
|
Apr 29, 2024
|
|
2019-2020 Catalog [ARCHIVED CATALOG]
|
ITSE 2333 - Implementing a Database on Microsoft SQL Server Credit Hours: 3 Contact Hours - Lecture: 2 Lab: 3 Skills development in the implementation of a database solution using Microsoft SQL Server client/server database management system. Prerequisite: ITSW 1307 and ITSE 1302 or COSC 1315 . Student Learning 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.
|
|
|