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