This Course will provide attendees the opportunity to take advantage of the new features provided by SQL Server 2005 so that they can design, build, query and develop enterprise SQL Server 2005 databases and servers.

This is a practical course and latest SQL Server 2005 course developed by Microsoft. SQL Server 2005 provides .NET integration and XML support as well as a wealth of programming enhancements. The improved security is a feature of this release.

Course Content

• Enhancements to T-SQL in SQL Server 2005
• New XML Features in SQL Server 2005
• SQL Server 2005 Service Broker
• SQL Server 2005 Native HTTP Support
• SQL Server 2005 Notification Services
• NET CLR Integration in SQL Server 2005
• Developing Client Applications for SQL Server 2005
• Introduction to SQL Server Integration Services
• SSIS for DBAs: Using SQL Server Management Studio
• A Guided tour of Business Intelligence Development Studio
• Introduction to Control Flow
• Advanced Control Flow
• Introduction to Data Flow
• Variables and Configurations
• Debugging, Error Handling and Logging
• Advanced Data Flow
• Extending SSIS through Custom Code – An Introduction to Custom Components and Scripting