If you have attended any Microsoft Official Curriculum (MOC) Course recently, then you can find all the demo and exercise files by following this link:

http://www.microsoft.com/learning/companionmoc

This is a link to files used by the customised course in Lincoln.

http://www.systecs.co.uk/Files/Allfiles.zip

http://www.systecs.co.uk/Files/20464-6.zip

I have been teaching a number of Querying courses recently. Delegates seem to fall into 2 groups.

• Office workers who need to access data
• IT specialists

The Microsoft Querying course (20461) is excellent for those from an IT background, particularly those with some programming experience. Recently I have taught some  of theses courses and there have been delegates who are really just administrative staff but need to get data from SQL server. They have usually struggled on this course. There is far too much material for a week. Don’t get me wrong, the examples and exercises in this course are excellent, but for some people they are too much for an initial entry in SQL server.

Much better to do a 2 day basic querying course, or a customised version of 20461 with just some of the first few modules.