NT 285 - Microsoft SQL Database Implementation

Institution:

Phillips Community College of the University of Arkansas

Subject:

Description:

5 hrs., 5 credits The course focuses on instructing students how to use SQL Server 2005 product features and tools related to implementing a database. Topics covered include using SQL Enterprise Manager and SQL Query Analyzer to create databases and database files, create data types and tables, plan, create and optimize indexes, implement data integrity with constraints, triggers and schemas, implementing views, stored procedures and functions, managing database code and using the Service broker to build a messagebased solution. Transact-SQL is covered in detail throughout the semester.

Credits:

5.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.pccua.edu

Phone Number:

(870) 338-6474

Regional Accreditation:

North Central 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.