I think that one of good exercises is reviewing the AdventureWorks database which is sample SQL server2005 + . It gives you a lot of idea about how a real database is shaped