SQL Server 2008 for business intelligence
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.
Course availability
Interested in attending this course?
To register your interest submit the expression of interest form
To enroll in this short course:
- you must submit an Application Form [PDF 70kb] to secure a place. Submission of an application form is confirmation of your intent to enroll and make a reservation. Your credit card will be charge 7-14 days prior to the scheduled commencement date. Or
- for online payment please click here (open external site). Payment will be directly debited from your credit card
Download Spring 2012 Timetable (pdf, 73kb)
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
Course fee
$800, $0 gst
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
Outline
This course has a particular emphasis on real world applications and skills.
The major topics covered are:
- 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 2008 relational 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 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.
