Home » Training » Courses » SQL Server for Developers
SQL Server 2008 R2 for Developers
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
| Course Times |
Every Tuesday, 6pm-9pm |
| Course Location |
City campus - Building 10 |
Requirements *
* Systems will be provided during the demonstrations that have all necessary software installed. |
- 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
- DVD ROM
- Pentium 4 with 1GB RAM or more
- 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.
|
Session Dates
|
Session
|
Topic
|
Presenter
|
| 1 - Tuesday 09/08/2011 |
SQL Server 2008 Management Studio |
Adam Stephensen and Eric Phan |
| 2 - Tuesday 16/08/2011 |
T-SQL Enhancements |
Adam Stephensen and Eric Phan |
| 3 -Tuesday 23/08/2011 |
High Availability |
Adam Stephensen and Eric Phan |
| 4 - Tuesday 30/08/2011 |
CLR Integration |
Adam Stephensen and Eric Phan |
| 5 - Tuesday 06/09/2011 |
Full-Text Search |
Adam Stephensen and Eric Phan |
|
Session
|
Topic
|
Presenter
|
| 1 - Tuesday 20/09/2011 |
SQL Server Integration Services (SSIS) and creating a Data Warehouse |
Eric Phan |
| 2 - Tuesday 27/09/2011 |
Analysis Services (OLAP)Creating a Cube + Cube Issues |
Eric Phan |
| 3 - Tuesday 04/10/2011 |
Reporting Services |
Eric Phan |
| 4 - Tuesday 11/10/2011 |
The Best 3rd Party Cube Browsers |
Eric Phan |
| 5 - Tuesday 18/10/2011 |
Data Mining |
Eric Phan |
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
Lecture Notes
Previous Year's Courses
2008
2007
Acknowledgements
Adam Cogan
Jatin Valabjee
Eric Phan
Justin King
Adam Stephensen