Developing a Logical Data Model

Define entities 

Design entity keys

Design attribute domain integrity

Implementing the Physical Database

Create and alter databases

Create and alter database objects

Alter database objects to support replication and partitioned views

Troubleshoot failed object creation

Retrieving and Modifying Data

Import and export data

Manipulate heterogeneous data

Retrieve, filter, group, summarize, and modify data by using Transact-SQL

Manage result sets by using cursors and Transact-SQL

Extract data in XML format

Programming Business Logic

Manage data manipulation by using stored procedures, transactions, triggers, user-defined functions, and views

Enforce procedural business logic by using stored procedures, transactions, triggers, user-defined functions, and views

Troubleshoot and optimize programming objects

Tuning and Optimizing Data Access

Analyze the query execution plan

Capture, analyze, and replay SQL Profiler traces

Create and implement indexing strategies

Improve index use by using the Index Tuning Wizard

Monitor and troubleshoot database activity by using SQL Profiler

Designing a Database Security Plan

Control data access by using stored procedures, triggers, user-defined functions, and views

Define object-level security including column-level permissions by using GRANT, REVOKE, and DENY

Create and manage application roles