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
Read more »