-
UTS Sydney
-
Course has finished for the semester. It will be
run again in 2014
This is one of the first academic courses in the world
to teach students on SQL Server 2012 for Business
Intelligence. SQL Server 2012 blurs the lines between
relational and multi-dimensional databases. Business
Intelligence is about the move from storing data to
retrieving information from your database systems.
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 2012 provides many options
to deviate from generic database design, by
eliminating or virtualizing different components
-
Evaluate different end user tools to explore data
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
- PowerPivot
- SQL Server 2012 relational database.
Prerequisites
| Course Times |
Every Tuesday, 6pm-9pm |
| Course Location |
UTS Broadway campus - room TBC |
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
- DVD ROM
- Pentium 4 with 1GB RAM or more
-
VMWare player (Free from
VMWare Player Home
). You are welcome to install VS.NET 2012
and SQL Server 2012 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