Microsoft IT Academy: Clinic 10260: Essential SQL Server 2008 For Developers

Online

This modular 12-hour course helps you exploit new business intelligence features in SQL Server 2008. This course provides you with the necessary skills to solve common BI development problems.

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

• Participants must have completed Introduction to Microsoft Business Intelligence or have similar real-world experience with the Microsoft BI platform
• Participants are encouraged to have developed OLAP cubes using SSAS
• Participants are encouraged to have written ETL packages with SSIS
• Participants are encouraged to have developed reporting and analytics solutions with SSRS

This clinic covers the following topics:

• Improving SQL Server 2008 Integration Services
• Creating flexible reports in SQL Server 2008 Reporting Using SSRS for supportability, scalability, and programmability
• SSAS design, performance, and management
• Data Mining in SQL Server 2008

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

• At the end of the course, students will be able to:
• Learn how to exploit the unique features of SQL Server 2008 in your applications.
• Learn all the essential elements of SQL Server 2008 development in an interactive format.

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).