SQL Server 2008 for Business Intelligence

AUTUMN Semester Dates: Every Tuesday from 07/04/09 to 5/05/09
SPRING Semester Dates: Every Tuesday from 16/9/08 to 14/10/08
Times: 6:00-9:00pm
Duration: 15 hrs (3hrs x 5 weeks)
Fees: $800
Venue: City campus - Building 10

Expressions and Enrolment

If you are interested in this course, please submit an Expression of Interest form to register your interest. Please note if you wish to enroll into this short course, you must also submit an Application Form [PDF 114k] to pay for and secure a place. Submission of an application form is confirmation of your intent to enroll and terms and conditions will apply.

Page Index
Background Information
Who Should Attend
Course Objectives
Course Outline

Background Information

Microsoft SQL Server 2008 is a complete business intelligence (BI) platform that provides the features, tools, and functionality to build both classic and innovative kinds of analytical applications.

A key goal of the SQL Server 2008 Business Intelligence components is to support the development and use of business intelligence in enterprises of all sizes, and to all employees - not just management and analysts, but also operational and external constituents. To this end, SQL Server 2008 is complete, integrated, easy to use, publishes data as web services, delivers great performance on commodity hardware, and contains scores of new features that you can use to develop innovative analytical applications.

Who Should Attend

The target audience for this course is:

  • Developers who have completed the SQL Server 2008 for Developers.
  • New developers with previous programming experience in VB, C, .NET or another modern language wanting to upgrade their skills
  • Intermediate programmers who will design and build Windows and Web based applications using SQL Server 2008
  • Programmers who are evaluating Microsoft SQL Server 2008 tools Course Objectives

Course Objectives

On completion of this course, students should have the skills to:

  • Use the Business Intelligence Development Studio to develop BI database objects
  • Use SQL Server Management Studio to operate and maintain BI database objects
  • Use Business Intelligence Development Studio for designing and debugging BI applications
  • Understand that SQL Server 2008 provides many options to deviate from generic database design, by eliminating or virtualizing different components

Course Outline

This course has a particular emphasisis on real world applications and skills. Topics covered include:

  • SQL Server Management Studio
  • SQL Server Business Intelligence Development Studio
  • Other BI tools such as DTS, Analysis Services OLAP, Analysis Services Data Mining and Reporting Services
  • SQL Server 2008relational database.

Assessment

Although there will be a number of hands-on exercises during the course, there is no formal assessment. Currently there is no certification for SQL Server 2008 however students can take official Microsoft exams 70-305, 70-306, 70-315 or 70-316 to earn credit towards a MCAD or MCSD certification.

Assumed Knowledge

Previous programming experience in VB, C, .NET or another modern language.

Prerequisites

SQL Server 2008 for Developers

Text

No formal texts are required however the following might prove useful.
Accelerated SQL Server 2008, by Rob Walters, Michael Coles, Robin Dewson, Fabio Claudio Ferracchiata, Jan D. Narkiewicz, and Robert Rae (April 2008).

Laboratory Equipment

Linux or Unix lab SQL Server 2008, Visual Studio 2008
Students will have access to a fully functional version of the software, and will be provided with up-to-date versions of the hands-on-labs and other presentation materials. Students will discover and try out practical, real-world examples of SQL Server 2008 software solutions.


For more information contact Dr Elaine Lawrence