The
- Designing databases at both the conceptual and logical levels
- Programing the database
- Database performance tuning and optimization
- Designing a Database Strategy
- Designing Database Tables
- Designing Programming Objects
- Designing a Transaction and Concurrency Strategy
- Designing an XML Strategy
- Designing Queries for Performance
- Designing a Database for Optimal Performance
- Writing transact SQL queries
- Troubleshooting programming objects, for example, stored procedures, triggers, user-defined functions (UDFs), user-defined types (UDTs), and queries
- Implementing databases at the physical level
- Designing and troubleshooting the data access layer of the application
>






