Microsoft IT Academy: Clinic 10164: Essential SQL Server 2008 for Developers

Online

The entirety of the offering is 12 hours but it is designed to be modular, allowing the user to skip to the tracks which are most relevant to them. this clinic will help you understand how to build enterprise-class applications which deeply exploit the rich data types, programming models and new development paradigms in SQL Server 2008.

• All current Cambridge University members (departments and colleges)
• Further details regarding eligibility criteria are available

• Real-world SQL Server 2000/2005 application development experience
• Basic operational familiarity with SQL Server Management Studio
• Real-world .NET Framework development experience
• Basic operational familiarity with Visual Studio

This clinic covers the following topics:

• TSQL Improvements and Data Types
• Beyond Relational
• SQLCLR: .NET Code In SQL Server
• Service Broker and Messaging
• SQL Server and Visual Studio
• Client Programmability
• ADO.NET Entity Framework
• HTTP Programming and SQL Server
• Occasionally Connected Systems

At the end of the course, students will be able to:

• Learn all the essential elements of SQL Server 2008 development in an interactive instructor-led format
• Learn how to exploit the unique features of SQL Server 2008 in your applications
• Deep and intensive 200-300 level technical training custom-designed for professional software developers
• Courseware developed by Bob Beauchemin and Simon Sabin of www.sqlskills.com, pre-eminent experts in SQL Server application development
• Get hands-on experience with SQL Server 2008 application development (not available in all locations)

Self-taught online

To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Macromedia Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

• The following software must be running on your computer in order to access this course with Screen Reader Software:
• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled

How to Enrol

• Email us: training@ucs.cam.ac.uk
• Telephone courses: (01223 3)34662

Important Information:

• To view this course you will need a Microsoft Live ID or Hotmail email account and to view the materials you will need to login and access the courses with Microsoft’s Explorer web browser (other browser systems may experience problems).