Beginning SQL Server 2005 for Developers: From Novice to Professional (Paperback)

Robin Dewson

  • 出版商: Apress
  • 出版日期: 2006-02-02
  • 定價: $1,500
  • 售價: 2.0$299
  • 語言: 英文
  • 頁數: 536
  • 裝訂: Paperback
  • ISBN: 1590595882
  • ISBN-13: 9781590595886
  • 相關分類: MSSQLSQL
  • 立即出貨(限量) (庫存=4)




SQL Server 2005 will increase your programming options, productivity, analysis, and database management. If you have some basic knowledge of relational databases and want to start a career as a developer using SQL Server, then this book is your ideal first step. It explains the core jobs and roles for developing a database in both SQL Server 2000 and 2005.

This book features practical steps to help you overcome issues youre likely to encounter. Youll learn to use SQL for querying, inserting, updating, and deleting data. Youll also learn how to back up and restore databases for basic administration in SQL Server. Further, youll cover how to build a complete database, from the fundamentals of relational database design to table and index creation.

Additionally, youll start to program in T-SQL, SQL Servers implementation (and extension) of the SQL programming language, and youll come away with effective programming techniques using stored procedures and triggers.



SQL Server 2005將增加您的編程選項、生產力、分析和數據庫管理。如果您對關聯數據庫有一些基本知識,並希望以SQL Server開發人員的身份開始職業生涯,那麼這本書是您理想的第一步。它解釋了在SQL Server 2000和2005中開發數據庫的核心工作和角色。

本書提供實用的步驟,幫助您克服可能遇到的問題。您將學習使用SQL進行查詢、插入、更新和刪除數據。您還將學習如何在SQL Server中進行基本管理的數據庫備份和還原。此外,您還將學習如何構建完整的數據庫,從關聯數據庫設計的基礎到表和索引的創建。

此外,您還將開始使用T-SQL進行編程,T-SQL是SQL編程語言的SQL Server實現(和擴展),並且您將學習使用存儲過程和觸發器的有效編程技巧。