Beginning SQL Server 2012 for Developers, 3/e (Paperback)

Robin Dewson

  • 出版商: Apress
  • 出版日期: 2012-04-25
  • 定價: $1,650
  • 售價: 6.0$990
  • 語言: 英文
  • 頁數: 720
  • 裝訂: Paperback
  • ISBN: 1430237503
  • ISBN-13: 9781430237501
  • 相關分類: MSSQLSQL
  • 立即出貨 (庫存=1)

買這商品的人也買了...

商品描述

Beginning SQL Server 2012 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 third edition, the book is enhanced to cover the very latest developments in SQL Server 2012.

Also new in the book is coverage of the no-cost Express Edition. Whether you have no knowledge of databases, or have knowledge of desktop databases such as Microsoft Access, or even come from another brand such as Oracle Database, Beginning SQL Server 2012 for Developers provides the insights to get up and running with SQL Server 2012.

Within the book, there are plenty of examples of tasks that developers routinely perform. You’ll learn to create tables and indexes, and 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.

Beginning SQL Server 2012 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 2012.

  • Takes you through the entire database application development lifecycle
  • Includes brand new coverage of SQL Server 2012 features
  • Introduces the freely-available Express Edition

What you’ll learn

  • How to install SQL Server 2012
  • How to build a database application from start to finish
  • How to create tables and indices to manage your data
  • How to write stored code to execute directly in the database server
  • How to back up, recover, and otherwise maintain your database
  • How to connect to your database from client languages such as C# and VB .NET

Who this book is for

Beginning SQL Server 2012 for Developers is ideal for developers starting out with SQL Server 2012. There is no prerequisite background in developing database applications. Developers from other platforms and those brand new to database programming alike will find in Beginning SQL Server 2012 for Developers an excellent introduction to using and programming Microsoft’s database platform.

Table of Contents

  1. Overview and Installation
  2. SQL Server Management Studio
  3. Database Design and Creation
  4. Security and Compliance
  5. Defining Tables
  6. Creating Indexes and Database Diagramming
  7. Database Backups and Recovery
  8. Database Maintenance
  9. Inserting and Deleting Data
  10. Selecting and Updating Data 
  11. Building a View
  12. Stored Procedures, Functions, and Security 
  13. Essentials for Effective Coding
  14. Advanced T-SQL
  15. Triggers
  16. Connecting from Client Code

商品描述(中文翻譯)

《Beginning SQL Server 2012 for Developers》是一本適合初學者的書籍,專為計劃在Windows平台上開發和部署應用程式使用Microsoft領先的SQL Server 2012資料庫系統的開發人員而設計。這本書的第三版已經更新,以涵蓋SQL Server 2012的最新發展。

這本書還新增了對免費的Express Edition的介紹。無論您對資料庫一無所知,還是對桌面資料庫(如Microsoft Access)有所了解,甚至來自其他品牌(如Oracle Database),《Beginning SQL Server 2012 for Developers》都提供了入門SQL Server 2012所需的洞察力。

在這本書中,有許多開發人員常常執行的任務示例。您將學習如何創建表格和索引,以及保護寶貴數據的最佳實踐。您將學習設計權衡,並了解如何做出明智的決策,以實現可擴展的資料庫和可維護的程式碼。

《Beginning SQL Server 2012 for Developers》將帶您完成整個資料庫開發過程,從安裝軟體到創建資料庫,再到編寫連接該資料庫並移動資料的程式碼。通過閱讀本書,您將能夠使用SQL Server 2012設計和創建堅固可靠的資料庫解決方案。

本書的內容包括:
- 帶您完成整個資料庫應用程式開發生命週期
- 全新涵蓋SQL Server 2012的功能
- 介紹免費提供的Express Edition

本書適合以下讀者:
《Beginning SQL Server 2012 for Developers》非常適合初學SQL Server 2012的開發人員。無需具備開發資料庫應用程式的背景知識。無論是來自其他平台的開發人員還是全新的資料庫程式設計初學者,都能在《Beginning SQL Server 2012 for Developers》中找到使用和編程Microsoft資料庫平台的優秀入門指南。

本書的目錄包括:
1. 概述和安裝
2. SQL Server Management Studio
3. 資料庫設計和創建
4. 安全性和合規性
5. 定義表格
6. 創建索引和資料庫圖表
7. 資料庫備份和恢復
8. 資料庫維護
9. 插入和刪除資料
10. 選擇和更新資料
11. 建立視圖
12. 儲存程序、函數和安全性
13. 有效編碼的基本要素
14. 高級T-SQL
15. 觸發器
16. 從客戶端程式碼連接