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