ITSE 2333 - IMPLEMENTING A DATABASE ON MICROSOFT SQL SERVER

Skills development in the implementation of a database solution using Microsoft SQL Server client/server database management system. 32 lecture hours + 32 laboratory hours

Upon completion, students will be able to:

  • Describe the elements of Microsoft SQL Server and its operational environments
  • Describe the elements of the Transact-SQL language
  • Demonstrate and configure the data storage architecture of SQL server
  • Write, maintain, and tune advanced queries
  • Manage locking options and transactions to ensure data concurrency and recoverability
  • Create views of data
  • Design and create stored procedures
  • Design and create triggers
  • Use distributed data

Grade Basis: L
Credit Hours: 3

Prerequisites: