Select the technology area:
SharePoint | SQL Server |
Visual Studio
- Writing Queries for Microsoft SQL Server
- Microsoft SQL Server System Administration Essentials
- Microsoft SQL Server Business Intelligence Launchpad - NEW!
- Integrating Microsoft SQL Server Business Intelligence with MOSS - NEW!
Writing Queries for Microsoft SQL Server
The goal of this course is to provide students with the technical skills and knowledge to write Transact-SQL statements for Microsoft SQL Server. Upon completion, students will be able to retrieve and modify data from SQL Server and understand how to perform these operations whilst maximising query performance.
Download course outline
342Kb PDF 
Microsoft SQL Server System Administration Essentials
The goal of this course is to provide students with the technical skills required to administer Microsoft SQL Server. Upon completion students will be able to install, configure and troubleshoot the client-server database management system of Microsoft SQL Server.
Download course outline
427Kb PDF
Microsoft SQL Server Business Intelligence Launchpad
This one-day hands on course is designed to show attendees how Microsoft SQL Server 2008 can be used to solve different types of business intelligence problems, from data warehousing to real-time operational reporting and analytics. Attendees will learn how to use the SQL Server BI toolset to collect data from heterogeneous data sources and then display the data in a meaningful format to assist in making business decisions and then measure and monitor the results.
Download course outline 286Kb PDF
Integrating Microsoft SQL Server Business Intelligence with MOSS
This one-day hands on course demonstrates how to integrate Microsoft SQL Server Business Intelligence and Reporting with Microsoft Office SharePoint Server 2007 (MOSS) without having to engage in any custom development. The course is designed to teach attendee’s and provide them with the hands-on experience with creating dashboard sites and creating and displaying lists of Key Performance Indicators (KPIs).
Download course outline 264Kb PDF