Lead Faculty: Dr. Mudasser Fraz Wyne
Prerequisite
DAT 610
Course Description
This course teaches the skills for implementing and maintaining databases using Structured Query Language (SQL) commands, including Data Design Language and Data Manipulation Language commands. Topics include creating databases using Transact-SQL and Data Transformation Services (DTS) to manipulate data; programming business logic using stored procedures, triggers, user-defined functions, and views; optimizing database performance by using SQL Profiler and the Index Tuning Wizard; and implementing security.