Home » 2010 » May » 5 » Designing Effective Database Systems by Rebecca M. Riordan
8:02 AM
Designing Effective Database Systems by Rebecca M. Riordan
Designing Effective Database Systems by Rebecca M. Riordan consists all core skills needed for any developer in database design and development. This book teaches easily how to design an effective, high-performance database to solve it. The book starts with the principles of relational design, making them accessible to every professional developer and then introduction to dimensional database modeling with practical insight for designing important analytical applications.
This book will teach you to
Understand relational database models, structures, relationships, and data integrity principles
Define database system goals, criteria, scope, and work processes
Construct accurate conceptual models: relationships, entities, domain analysis, and normalization
Build efficient, secure database schema
Master the elements of online analytical processing (OLAP) design: fact tables, dimension tables, snowflaking, and more
Architect and construct easy, efficient interfaces for querying and reporting
Learn from practice examples based on Microsoft’s Northwind sample database
Download Designing Effective Database Systems by Rebecca M. Riordan