• Duration
    • 3 hrs x 5 weeks
  • Fees
    • $850
  • 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

    1. From the "Session Menu" on the login screen, choose the "Windows XP.NET" session
    2. 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