The student will use Transact SQL and Data Transformation Services to manipulate data and extract data in XML format. Programming business logic using stored procedures, transactions, triggers, user-defined functions and views also are covered. The student will learn to optimize database performance by using SQL Profiler and the Index Tuning Wizard. Security management will be covered from the viewpoint of data access, object-level security and application rolls. (Special Fee: $66.00).
Prerequisites: CGS 2545C