Book: Introducing Microsoft SQL Server 2005 for Developers
1. SQL Server Management Studio and T-SQL
2. XML
3. Microsoft .Net framework integration
4. User-defined data types
5. Client -side ADO-NET
6. Security
7. Data transformation services
8. SQL server management objects
9. Native HTTP SOAP
10. Notification services
11. SQL Server service broker
12. Reporting Services
Knowledge of SQL server 2000 environment both in Development and Administration areas.
Familiarity with SQL server 2005 Development Features