Course resources for students

Welcome! This page will be updated with the latest course materials, as you progress through the sessions.

Part Session Hands-on Lab Slides Resources
A 1: SQL Server 2005 Management Studio
  1. ServerProperties.sql
  2. DatabaseProperties.sql
  3. GroupBy.sql
  4. Logins.sql
  5. DBUsers.sql
  6. RolesAndSchemas.sql
  7. Schemas.sql
  8. NewTable.sql
  9. Permission.sql
  10. UserDemo1.sql
  11. UserDemo2.sql
  2: T-SQL Enhancements  
  3: High Availability
  4: CLR Integration
  5: Full Text Search ZIP files
B 1: SSIS and Creating a Data Warehouse Data Warehouse Creation Script
2: OLAP - Creating Cubes and Cube Issues SSIS Package for Populating Warehouse
3: Reporting Services
  1. Query Text for Report
4: Alternative Cube Browsers  
5: Data Mining AppendixA.zip

 

Acknowledgements