Skip to main content
SpringerLink
Log in
Apress

Beginning SQL Server 2005 Express for Developers

From Novice to Professional

  • Book
  • © 2007

Overview

Authors:
  1. Robin Dewson
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Comprehensive, clear, and authoritative, by an established SQL Server author

  • Ideal for any SQL Server Express user, regardless of prior experience

  • Highly readable yet technically thorough

  • 3535 Accesses

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 29.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 39.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-xx
    Download chapter PDF

  2. SQL Server 2005 Express Overview and Installation

    Pages 1-20

  3. SQL Server Management Studio Express

    Pages 21-44

  4. Database Design and Creation

    Pages 45-84

  5. Security

    Pages 85-103

  6. Defining Tables

    Pages 105-135

  7. Creating Indexes and Database Diagramming

    Pages 137-165

  8. Database Backup, Recovery, and Maintenance

    Pages 167-208

  9. Working with the Data

    Pages 209-265

  10. Building a View

    Pages 267-289

  11. Stored Procedures

    Pages 291-311

  12. T-SQL Essentials

    Pages 313-350

  13. Advanced T-SQL

    Pages 351-371

  14. Triggers

    Pages 373-393

  15. SQL Server 2005 Reporting Services

    Pages 395-414

  16. Back Matter

    Pages 415-436
    Download chapter PDF
Back to top

Keywords

About this book

Assuming neither database nor programming background, Beginning SQL Server 2005 Express for Developers introduces all the fundamental database administration and SQL programming features of SQL Server 2005 Express Edition, the free relational database management system from Microsoft that provides a major subset of full SQL Server 2005 functionality.

This book is a comprehensive guide that covers installing and configuring SQL Server 2005 Express, creating, backing up, and restoring databases, creating tables, then querying and manipulating them with T-SQL, coding stored procedures and triggers, and using Reporting Services to deliver information to end users. Detailed, clear, and highly readable, this book will make you a competent and confident database administrator and programmer.

  • This is the clearest and most comprehensive introduction to SQL Server 2005 Express.
  • The book assumes no prior experience with databases, SQL, or programming.
  • Youll learn about both database administration and T-SQL programming.
  • The book covers SQL Server Management Studio and Reporting Services.

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