COMPLETED: See the current UTS course.

SQL Server 2008 for Developers

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

SQL Server 2008 for Business Intelligence

Dates: Every Tuesday from 16/09/08 to 14/10/08
Times: 6:00-9:00pm
Duration: 15 hrs (3hrs x 5 weeks)
Fees: $800
Venue: UTS, City campus - Jones St, Building 10
 

With easy access via public transport and on-campus car parking, UTS' convenient location in the heart of Sydney is ideal for our evening or weekend classes.

To participate, please complete an http://it.uts.edu.au/course/shortcourse/shortcourses_apply.pdf application form and fax it to 9514-1844.

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

For more information, have a look at the http://www.feit.uts.edu.au/courses/short/index.html UTS 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
05-08-2008		 18:00 - 21:00 SQL Server 2008 Management Studio Sergei Tchernykh, Ian Bennett
2 Tuesday
12-08-2008		 18:00 - 21:00 T-SQL Enhancements Cameron Townshend
3 Tuesday
19-08-2008		 18:00 - 21:00 High Availability Eric Phan
4 Tuesday
26-08-2008		 18:00 - 21:00 CLR Integration Eric Phan
5 Tuesday
02-09-2008		 18:00 - 21:00 Full-Text Search Cameron Townshend

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

Session Date Time Topic Presenters

1

 Tuesday
16-09-2008		 18:00 - 21:00 SQL Server Integration Services (SSIS) and creating a Data Warehouse Cameron Townshend
2 Tuesday
23-09-2008		 18:00 - 21:00 Analysis Services (OLAP)Creating a Cube + Cube Issues Eric Phan
3 Tuesday
30-09-2008		 18:00 - 21:00 Reporting Services Eric Phan
4 Tuesday
07-10-2008		 18:00 - 21:00 The Best 3rd Party Cube Browsers Eric Phan
5 Tuesday
14-10-2008		 18:00 - 21:00 Data Mining Eric Phan
 

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

  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)

Resources (Presentations and Hands On Labs)

  • Lecture Notes - FOR ATTENDEES ONLY

Acknowledgements

Adam Cogan
Jatin Valabjee
Eric Phan