Beginning SQL Server 2005 for Developers

From Novice to Professional

  • Authors
  • Robin Dewson

Table of contents

  1. Front Matter
    Pages i-xxiii
  2. Pages 95-118
  3. Pages 119-151
  4. Pages 245-308
  5. Pages 309-333
  6. Pages 335-357
  7. Pages 359-401
  8. Pages 403-426
  9. Pages 427-450
  10. Back Matter
    Pages 473-508

About this book


Purchase this book and you'll get the free, fully searchable eBook—a $25 value! (Details are printed inside the book.)

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. You'll learn to use SQL for querying, inserting, updating, and deleting data. You'll also learn how to back up and restore databases for basic administration in SQL Server. Further, you'll cover how to build a complete database, from the fundamentals of relational database design to table and index creation.

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


Microsoft SQL Server SQL SQL Server 2000 SQL Server 2005 SQL programming T-SQL Transact-SQL database design relational database reporting

Bibliographic information

Industry Sectors
Materials & Steel
Chemical Manufacturing
Finance, Business & Banking
IT & Software
Consumer Packaged Goods
Energy, Utilities & Environment