Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance (28 April 2010)
- SQL Server versions 2000,2005 & 2008
- Database design and implementation
- Microsoft BI development (SSIS, SSAS, SSRS)
- ETL design and implementation
- Report design and implementation using SSRS
- Stored Procedure Development (TransactSQL and CLR)
- Programming using .NET framework (3.5, 2.0) using C# or VB.Net, LINQ
- Service oriented architectures and web services (e.g. WSDL, SOAP)
- SQLServer admin, setup, configuration, maintenance: e.g. backup strategy, transactional replication, data migration, upgrades etc.