SQL Express currently does not ship with any sample databases to help keep the size down, we'll be making these formally available on the web in the future but the folks over at ASP.Net have a nice tutorial that includes using the pubs database, so they have a page that shows you how to download and install pubs.

Its here.

 

-Euan Garden

Product Unit Manager

SQL Server Tools