ITSE 2333 - Implementing A Database On Ms Sqlserver

Institution:

Northwest Vista College

Subject:

Description:

Prerequisites:ITSE 2309 and ITSC 1307 Corequisites: None Fees:Laboratory Skills development in the implementation of a database solution using Microsoft SQL Server client/server database management system. 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. Create and manage files, file groups, databases, tables, and transaction logs; enforce data integrity using constraints, defaults and rules; and create and maintain indexes. Write queries to retrieve and modify data using joins and sub-queries; write queries that summarize data; manage locking options and transactions to ensure data concurrency and recoverability; and create views of data. Design and create stored procedures; design and create triggers; and use distributed data. (CIP 110802)

Credits:

3.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Multiple

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.alamo.edu/nvc/

Phone Number:

(210) 486-4000

Regional Accreditation:

Southern Association of Colleges and Schools

Calendar System:

Semester

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.