By Rebecca M. Riordan
“Riordan covers middle talents for any developer—database layout and development—in an ideal volume of element. This e-book might be on each specialist developer’s interpreting list.”
—Duncan Mackenzie, developer, Microsoft (MSDN)
“Designing a database isn't a trivial topic. Riordan brings adventure and transparent causes to a basic a part of software program development.”
—Patrick Birch, database and technical writing consultant
“If you purchase just one booklet on database layout, make it this one. Riordan has a expertise for explaining technical matters in easy language, with out over simplifying.”
—Brendan Reynolds, developer, Dataset IT platforms and Microsoft entry MVP
“A publication that would expertly advisor you in how you can increase a database for a shopper— and the way to do it correct the 1st time!”
—Kenneth D. Snell, Ph.D., entry developer and Microsoft entry MVP
“Riordan has produced a different publication that brings jointly a proper, but common sense, method of relational database design...and then is going extra! Many database designers will locate sizeable worth within the steps to constructing sensible information warehouse designs. while you're looking a framework for designing transactional databases, or are looking to step out into the realm of analytical databases, Riordan’s ebook excels at bridging either worlds.”
—Paul Irvine, vice chairman, engineering, through Training
“Riordan takes a fancy topic and makes it effortless. If you’re over your head on a database layout venture, this ebook might help bail you out!”
—Mike Gunderloy, contributing editor, Application improvement Trends
“This ebook covers a variety of database layout and knowledge modeling themes in a well-organized, effortless to appreciate format.”
—Amy Sticksel, Sticksel information platforms, Inc.
“In Designing potent Database Systems, Riordan’s variety, wit, and a focus to element are outstanding.”
—Sandra Daigle, Microsoft entry MVP
The software program Developer’s step by step advisor to Database Design
World-renowned specialist Rebecca M. Riordan has written the definitive database layout publication for operating builders who aren’t database specialists. regardless of how messy or advanced your facts problem, Designing powerful Database Systems exhibits you the way to layout a good, high-performance database to resolve it.
Riordan starts through completely demystifying the rules of relational layout, making them available to each specialist developer. subsequent, she deals the field’s clearest creation to dimensional database modeling—practical perception for designing today’s more and more very important analytical functions.
One job at a time, the writer illuminates each side of database research and layout for either conventional databases and the dimensional databases used for facts warehousing, displaying the best way to keep away from universal architectural pitfalls that complicate improvement and decrease extensibility. The booklet concludes with entire, professional advice on designing databases for max usability.
This booklet will train you to
- Understand relational database versions, buildings, relationships, and knowledge integrity principles
- Define database procedure objectives, standards, scope, and paintings processes
- Construct actual conceptual types: relationships, entities, area research, and normalization
- Build effective, safe database schema
- Master the weather of on-line analytical processing (OLAP) layout: truth tables, size tables, snowflaking, and more
- Architect and build effortless, effective interfaces for querying and reporting
- Learn from perform examples in accordance with Microsoft’s Northwind pattern database
Riordan has helped hundreds of thousands of pros grasp database layout and improvement, incomes Microsoft’s coveted MVP honor for her unprecedented contributions. no one is extra certified that can assist you grasp database layout and observe it on your real-world environment.