Skip to main content
SpringerLink
Log in
Apress

Beginning SQL Server 2005 for Developers

From Novice to Professional

  • Book
  • © 2006

Overview

Authors:
  1. Robin Dewson
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • The only truly Beginning level book on the market that is tailored to the needs of aspiring developers with little or no experience. Assumes no prior SQL Server knowledge

  • Explores the new 2005 features fully but also suitable for SQL Server 2000 users

  • The book provides everything an aspiring developer needs to start building SQL Server database applications

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 49.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (14 chapters)

  1. Front Matter

    Pages i-xxiii
    Download chapter 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
    Download chapter PDF
Back to top

Keywords

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.

About the author

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.

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation