Design and implement a Structured Query Language (SQL) Server database. Create and maintain database objects and implement database integrity. Use Transact-SQL to query a SQL Server database and manage and manipulate data stored in that database. Manage a SQL Server database by setting appropriate security settings. Perform maintenance and optimization of a SQL Server database.
Prerequisite: "C" grade or higher or "Pass" in CIS 140 or 240 or equivalent.
Recommended Preparation: None
3 UNITS : 2 hours lecture, 3 hours laboratory