Beginning SQL Server 2005 for Developers

1. Front Matter

   Pages i-xxiii

   PDF

2. SQL Server 2005 Overview and Installation

   Pages 1-24

3. SQL Server Management Studio

   Pages 25-51

4. Database Design and Creation

   Pages 53-94

5. Security

   Pages 95-118

6. Defining Tables

   Pages 119-151

7. Creating Indexes and Database Diagramming

   Pages 153-183

8. Database Backups, Recovery, and Maintenance

   Pages 185-243

9. Working with the Data

   Pages 245-308

10. Building a View

    Pages 309-333

11. Stored Procedures

    Pages 335-357

12. T-SQL Essentials

    Pages 359-401

13. Advanced T-SQL

    Pages 403-426

14. Triggers

    Pages 427-450

15. SQL Server 2005 Reporting Services

    Pages 451-472

16. Back Matter

    Pages 473-508

    PDF

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

Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years. He also has been developing a rugby-related website as well as maintaining his own site at Fat-Belly.com.

Policies and ethics