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
-
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)
Resources (Presentations and Hands On Labs)
-
Lecture Notes -
FOR ATTENDEES ONLY
Acknowledgements
Adam Cogan
Jatin Valabjee
Eric Phan