SQL Server 2012 Data Design and Retrieval

by Mike Hotek

What you need to get the job done.The latest book from the best-selling SQL Server author Mike Hotek. SQL Server 2012 Data Design and Retrieval is your reference for building databases and querying data. This book takes you on a tour from the basics through the advanced details delivering a reference which you can employ in solving the real-world problems faced every day by database professionals. Each topic is reinforced with detailed exercises taken from real customer implementations.We take you on a tour starting with creating tables, through loading/retrieving data, and into the internal storage structures to explain why SQL Server behaves the way it does. We take off from that point to continue through processor architectures to explain why every design choice you make really matters to the performance of your applications. Along the way, you learn how to go beyond storing and retrieving simple data to employ transactions, hierarchies, full-text search, XML, spatial data, indexes, partitioning, and window functions in the design of your applications. This book is also a great starting point for the 70-461 Querying Microsoft SQL Server 2012 certification exam.

925 pages, Kindle Edition

First published March 29, 2013