{"product_id":"9781430236962","title":"Pro SQL Server 2012 Relational Database Design and Implementation","description":"\u003cp\u003e    Learn effective and scalable database design techniques in a SQL Server environment. \u003cem\u003ePro SQL Server 2012 Relational Database Design and Implementation\u003c\/em\u003e covers everything from design logic that business users will understand, all the way to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, \u003cstrong\u003eLouis Davidson\u003c\/strong\u003e shows how to “get it right” in SQL Server database design and lay a solid groundwork for the future use of valuable business data.\u003c\/p\u003e\u003cp\u003e  \u003c\/p\u003e\u003cul\u003e  \u003cli\u003eGives a solid foundation in best practices and relational theory \u003c\/li\u003e  \u003cli\u003eCovers the latest implementation features in SQL Server \u003c\/li\u003e  \u003cli\u003eTakes you from conceptual design to an effective, physical implementation \u003c\/li\u003e  \u003c\/ul\u003e           What you’ll learn\u003cul\u003e  \u003cli\u003eHow to develop conceptual models of client data using interviews and client documentation \u003c\/li\u003e  \u003cli\u003eHow to recognize and apply common database design patterns \u003c\/li\u003e  \u003cli\u003eHow to normalize data models to enhance scalability and the long term use of valuable data \u003c\/li\u003e  \u003cli\u003eHow to translate conceptual models into high–performing SQL Server databases \u003c\/li\u003e  \u003cli\u003eHow to secure and protect data integrity as part of meeting regulatory requirements \u003c\/li\u003e  \u003cli\u003eHow to create effective indexing to speed query performance \u003c\/li\u003e  \u003c\/ul\u003e  Who this book is for      \u003cp\u003e     \u003cem\u003ePro SQL Server 2012 Relational Database Design and Implementation\u003c\/em\u003e is designed for programmers of all types who want to use SQL Server 2012 to store data. Chapters on fundamental concepts, the language of database modeling, SQL implementation, and of course, the normalization process, lay a solid groundwork for readers who are just entering the field of database design. More advanced chapters serve the seasoned veteran by tackling the very latest in physical implementation features that SQL Server has to offer.         \u003c\/p\u003e     Table of Contents\u003col\u003e  \u003cli\u003eThe Fundamentals \u003c\/li\u003e  \u003cli\u003eIntroduction to Requirements \u003c\/li\u003e  \u003cli\u003eThe Language of Data Modeling \u003c\/li\u003e  \u003cli\u003eInitial Data Model Production \u003c\/li\u003e  \u003cli\u003eNormalization \u003c\/li\u003e  \u003cli\u003ePhysical Model Implementation Case Study \u003c\/li\u003e  \u003cli\u003eData Protection with Check Constraints and Triggers \u003c\/li\u003e  \u003cli\u003ePatterns and Anti-Patterns \u003c\/li\u003e  \u003cli\u003eTable structures and Indexing \u003c\/li\u003e  \u003cli\u003eCoding for Concurrency \u003c\/li\u003e  \u003cli\u003eReusable Standard Database Components \u003c\/li\u003e  \u003cli\u003eStandardized Data Models \u003c\/li\u003e  \u003cli\u003eConsidering Data Access Strategies \u003c\/li\u003e  \u003cli\u003eReporting Design \u003c\/li\u003e  \u003cli\u003eAppendix A \u003c\/li\u003e  \u003cli\u003eAppendix B \u003c\/li\u003e  \u003c\/ol\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47141779767536,"sku":"9781430236962","price":47.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781430236962_p0.jpg?v=1763751880","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781430236962","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}