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. 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. 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.
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
This course has a particular emphasis 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 2008 relational database
| Course Times |
Every Tuesday, 6pm-9pm |
| Course Location |
City - Broadway |
Requirements *
* Systems will be provided during the
demonstrations that have all necessary software
installed.
|
-
USB Key so you can back up your solution to
take home from the labs
-
We supply a VMWare image on DVD which is
running Windows XP Pro, Visual Studio .NET
2008 and SQL Server 2008
- DVD ROM
- Pentium 4 with 1GB RAM or more
-
VMWare player (Free from
VMWare Player Home
). You are welcome to install VS.NET 2008 and
SQL Server 2008 but we don't provide any
support - support is provided for the VMWare
image.
|
Instructions for Students: How to log in
-
From the "Session Menu" on the login screen, choose
the "Windows XP.NET" session
-
Type in your username and password. Your vmware image
(session) will start automatically. (You can also
start it manually by running the command vmware from a
terminal window)
Acknowledgements
Adam Cogan
Jatin Valabjee
Eric Phan
Justin King
Adam Stephensen