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