In SQL 2000 and previous there was Northwind which was your dummy database that you could use if you need to do database stuff, but didn’t have a database. Well with the release of SQL 2005 they came out with a new Database called AdventureWorks. Problem is it doesn’t come with SQL Express so you have to find it. Well I finally found the link and am sharing it with you all.
Download: AdventureWorks Database
Edit: I just figured out it got moved yet again to Code Plex
Edit: here is the exact link to get it. Finally actually found it.
http://www.codeplex.com/MSFTDBProdSamples/