Skip Navigation LinksHome > events > 2006SQL > SQL Server 2005 for Developers and BI

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 Homework!
  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