SQL Server 2008 for Business Intelligence

Dates: Every Tuesday from 14/09/10 to 12/10/10
Times: 6:00-9:00pm
Duration: 15 hrs (3hrs x 5 weeks)
Fees: $800
Venue: City - Broadway

This is one of the first academic course in the world to teach students on SQL SERVER 2008 for Business Intelligence. SQL Server 2005 blurs the lines between relational and multidimensional databases. Data may be stored in the relational database, in the multidimensional database, or the new Proactive Cache feature. One key feature of SQL SERVER 2005 is that Analysis Services 2005 does not contain a metadata repository.

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.

Microsoft SQL Server 2008 Business Intelligence components supports the development and use of business intelligence in enterprises of all sizes. It can be used by employees and external parties, not just management and analysts. To this end, SQL Server 2008 is complete, integrated, easy to use, publishes data as web services, delivers excellent performance on commodity hardware and contains many new features that can be used to develop innovative analytical applications

Interested in attending this course?

To register your interest submit the http://forms.uts.edu.au/web/index.cfm expression of interest form.

To enrol in this short course, you must submit an http://www.feit.uts.edu.au/courses/short/index.html application form to pay for and secure a place.

Who Should Attend?

The target audience for this course is:

  • Developers who have completed the SQL Server 2008 for Developers course.
  • New developers with previous programming experience in VB, C, .NET or other modern languages wishing to upgrade their skills
  • Intermediate programmers who want to design and build Windows and Web based applications using SQL Server 2008
  • Programmers who are evaluating Microsoft SQL Server 2008 tools

Prerequisites

  • SQL Server 2008 for Developers
  • Previous programming experience in VB, C, .NET or another modern language.

Course Details

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

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 participants can take official Microsoft exams 70-305, 70-306, 70-315 or 70-316 to earn credit towards a Microsoft Certified Applications Developer (MCAD) or Microsoft Certified Solution Developer (MCSD) certification.

Text

No formal texts are required however the following text 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 and Visual Studio 2008 is loaded in a laboratory environment
  • Participants 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. This will allow participants to trial practical, real-world examples of SQL Server 2008 software solutions.

Acknowledgements

Adam Cogan
Eric Phan