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
.