Database Architecture

hi
i am haveing 1.5 years exp in asp.net(c#),i want to improve my knowlege in Database Architecture (datmodeling,uml,normalization,etc..).could anyone suggest me course or any booksPerhaps Pro SQL Server 2005 Database Design and Optimization by Louis Davidson|||

If you are trying to get a grounding in data modeling, I'd recommend starting with entity-relationship models. These are the classic models used in transactional systems. You'll need to learn basic methodologies as well as the first 4 normal forms (1NF, 2NF, 3NF, Boyce-Codd NF aka BCNF aka 3.5NF). I've found Graeme Simsion's Data Modeling Essentials to be a good starting point for this. In addition, you may want to check out books by Joe Celko (though his stuff can be a bit more advanced).

Once you get a solid footing in entity-relationship (E-R) modeling, you may want to look into dimensional modeling. This is foundation of data warehousing. Ralph Kimball's Data Warehousing Toolkit is considered the Bible on this topic. (His class, Dimensional Modeling In-Depth, which follows this book is also top-notch.)

Good luck,

Bryan Smith