商品描述
Beginning SQL Server for Developers is the perfect book for developers new to SQL Server and planning to create and deploy applications against Microsoft’s market-leading database system for the Windows platform. Now in its fourth edition, the book is enhanced to cover the very latest developments in SQL Server, including the in-memory features that are introduced in SQL Server 2014.
Within the book, there are plenty of examples of tasks that developers routinely perform. You’ll learn to create tables and indexes, and be introduced to best practices for securing your valuable data. You’ll learn design tradeoffs and find out how to make sound decisions resulting in scalable databases and maintainable code.
SQL Server 2014 introduces in-memory tables and stored procedures. It's now possible to accelerate applications by creating tables (and their indexes) that reside entirely in memory, and never on disk. These new, in-memory structures differ from caching mechanisms of the past, and make possible the extraordinarily swift execution of certain types of queries such as are used in business intelligence applications. Beginning SQL Server for Developers helps you realize the promises of this new feature set while avoiding pitfalls that can occur when mixing in-memory tables and code with traditional, disk-based tables and code.
Beginning SQL Server for Developers takes you through the entire database development process, from installing the software to creating a database to writing the code to connect to that database and move data in and out. By the end of the book, you’ll be able to design and create solid and reliable database solutions using SQL Server.
- Takes you through the entire database application development lifecycle
- Includes brand new coverage of the in-memory features
- Introduces the freely-available Express Edition
商品描述(中文翻譯)
《Beginning SQL Server for Developers》是一本適合初學者的書籍，專為計劃在Windows平台上使用Microsoft領先的資料庫系統SQL Server開發和部署應用程序的開發人員而設計。這本書的第四版已經更新，包括了SQL Server的最新發展，包括在SQL Server 2014中引入的內存功能。
在這本書中，有很多開發人員常常執行的任務的示例。您將學習如何創建表和索引，並介紹保護寶貴數據的最佳實踐。您將學習設計權衡，並了解如何做出明智的決策，以實現可擴展的數據庫和可維護的代碼。
SQL Server 2014引入了內存表和存儲過程。現在可以通過創建完全存儲在內存中而不是磁盤上的表（及其索引）來加速應用程序。這些新的內存結構不同於過去的緩存機制，使得在商業智能應用程序中使用的某些類型的查詢能夠以非常快的速度執行。《Beginning SQL Server for Developers》幫助您實現這個新功能集的承諾，同時避免在內存表和代碼與傳統的基於磁盤的表和代碼混合時可能出現的問題。
《Beginning SQL Server for Developers》將帶您完成整個數據庫開發過程，從安裝軟件到創建數據庫，再到編寫連接該數據庫並移動數據的代碼。通過閱讀本書，您將能夠使用SQL Server設計和創建堅固可靠的數據庫解決方案。
本書還介紹了免費提供的Express Edition，並涵蓋了全新的內存功能。
