Dates:
Every Tuesday from 29/08/06 to 26/09/06
Times:
6:00-9:00pm
Duration:
15 hrs (3hrs x 5 weeks)
Fees:
$800
Venue:
City campus - Jones St, Building 10, Level 3, Room 210
A practical course for the ICT Industry utilizing the
latest SQL Server 2005 developed by Microsoft. SQL Server 2005 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 2005. 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 2005
-
Develop and write code for SQL Server 2005
-
Implement Advanced Availability & Scalability features of SQL Server 2005
-
Implement Advanced indexing and Full-text search features
-
Design Service Oriented Architecture (SOA)
-
Design distributed applications using the Distributed Application Designer
-
Use SQL Server 2005 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 2005 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 2005 Architecture and Components
-
SQL Server Management Studio
-
Programming SQL Server 2005 with .NET
-
Enhancements to Transact-SQL
-
The XML Data Type and XQuery
-
SQL Server 2005 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 2005 for Developers
Session
|
Date
|
Time
|
Topic
|
Presenters
|
1
|
Tuesday
29-08-2006
|
18:00 - 21:00
|
SQL Server 2005 Management Studio
|
Tim Kremer, Andrew Weaver
|
2
|
Tuesday
05-09-2006
|
18:00 - 21:00
|
T-SQL Enhancements
|
Tim Kremer, Andrew Weaver
|
3
|
Tuesday
12-09-2006
|
18:00 - 21:00
|
High Availability
|
David Klein, Marten Ataalla
|
4
|
Tuesday
19-09-2006
|
18:00 - 21:00
|
CLR Integration
|
Adrian Foyn, David Klein
|
5
|
Tuesday
26-09-2006
|
18:00 - 21:00
|
Full-Text Search
|
Edward Forgacs
|
Part B: SQL Server 2005 for Business Intelligence (BI)
Session
|
Date
|
Time
|
Topic
|
Presenters
|
1
|
Tuesday
17-10-2006
|
18:00 - 21:00
|
SQL Server Integration Services (SSIS) and creating a Data Warehouse
|
Adam Cogan, David Klein
|
2
|
Tuesday
24-10-2006
|
18:00 - 21:00
|
Analysis Services (OLAP)Creating a Cube + Cube Issues
|
Geoff Orr, David Klein
|
3
|
Tuesday
31-10-2006
|
18:00 - 21:00
|
Reporting Services
|
Adam Cogan, David Klein
|
4
|
Tuesday
07-11-2006
|
18:00 - 21:00
|
The Best 3rd Party Cube Browsers
|
Adam Cogan, David Klein
|
5
|
Tuesday
14-11-2006
|
18:00 - 21:00
|
Data Mining
|
Adam Cogan, David Klein
|
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 2005 and SQL Server 2005
-
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 2005 and SQL Server 2005
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
.