Up and Running on SQL Server 2008 + Business Intelligence

Dates: Every Tuesday from 23/02/10 to 23/03/10.
Spring: Every Tuesday from 3/08/10 to 31/08/10.
Times: 6:00-9:00pm
Duration: 15 hrs (3hrs x 5 weeks)
Fees: $800
Venue: UTS, City campus - Jones St, Building 10

To secure a place in this short course, please complete an application form.

Please phone 9514-1806 / 9514-1861 for further details or email shortcourses@it.uts.edu.au

For more information, have a look at the UTS Programming Short Courses website.

A practical course for the ICT Industry utilizing the latest SQL Server 2008 developed by Microsoft. SQL Server 2008 provides .NET integration and XML support as well as a wealth of programming enhancements. The improved security is a feature of this release. This course provides attendees with the knowledge necessary to take advantage of new features provided by SQL Server 2008. It provides a comprehensive overview of technologies, security, and design best practices with particular emphasis on hands-on skills.

On completion of this course, students should have the skills to:

Decide whether to migrate to SQL Server 2008
Develop and write code for SQL Server 2008
Implement Advanced Availability & Scalability features of SQL Server 2008
Implement Advanced indexing and Full-text search features
Design Service Oriented Architecture (SOA)
Design distributed applications using the Distributed Application Designer
Use SQL Server 2008 Reporting Services
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 2008 Architecture and Components
SQL Server Management Studio
Programming SQL Server 2008 with .NET
Enhancements to Transact-SQL
The XML Data Type and XQuery
SQL Server 2008 High Availability & Scalability features
Security Features & Improvements
ADO.NET 2.0
SQL Server Service Broker
Developing client applications
SQL Server Business Intelligence Development Studio
Other BI tools such as DTS, Analysis Services OLAP, Analysis Services Data Mining and Reporting Services

Session Dates

Part A: SQL Server 2008 for Developers

Session	Date	Time	Topic	Presenters
1	Tuesday 23-02-2010	18:00 - 21:00	SQL Server 2008 Management Studio	Andy Taslim, Jay Lin
2	Tuesday 02-03-2010	18:00 - 21:00	T-SQL Enhancements	Peter Gfader, Andy Taslim
3	Tuesday 09-03-2010	18:00 - 21:00	High Availability	Peter Gfader, Andy Taslim
4	Tuesday 16-03-2010	18:00 - 21:00	CLR Integration	Peter Gfader, Andy Taslim
5	Tuesday 23-03-2010	18:00 - 21:00	Full-Text Search	Peter Gfader, Andy Taslim

Part B: SQL Server 2008 for Business Intelligence (BI)

Session	Date	Time	Topic	Presenters
1	Tuesday 06-04-2010	18:00 - 21:00	SQL Server Integration Services (SSIS) and creating a Data Warehouse	Peter Gfader
2	Tuesday 13-04-2010	18:00 - 21:00	Analysis Services (OLAP)Creating a Cube + Cube Issues	Peter Gfader
3	Tuesday 20-04-2010	18:00 - 21:00	Reporting Services	Peter Gfader
4	Tuesday 27-04-2010	18:00 - 21:00	The Best 3rd Party Cube Browsers	Peter Gfader
5	Tuesday 04-05-2010	18:00 - 21:00	Data Mining	Peter Gfader

System Requirements*

* Systems will be provided during the demonstrations that have all necessary software installed.

Note:

Bring a 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
You need a DVD ROM
You need a Pentium 4 with 1GB RAM or more
You need 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)