Beginning SQL Server 2005 Express for Developers: From Novice to Professional (Expert's Voice in .Net) (Paperback)

by Robin Dewson (Author)
Key Phrases: database diagram tool, encrypted views, varchar value, Query Editor, Object Explorer, Server Management Studio Express (more...)

Editorial Reviews

Product Description

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 www.fat-belly.com.

Product Details

• Paperback: 464 pages
• Publisher: Apress (May 4, 2009)
• Language: English
• ISBN-10: 1590597206
• ISBN-13: 978-1590597200
• Product Dimensions: 9.1 x 7 x 1.1 inches
• Shipping Weight: 1.4 pounds (View shipping rates and policies)
• Average Customer Review: 5.0 out of 5 stars See all reviews (2 customer reviews)
• Amazon.com Sales Rank: #125,701 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #38 in	Books > Computers & Internet > Databases > Beginning & Introductory
  #42 in	Books > Computers & Internet > Programming > Software Design, Testing & Engineering > Structured Design

Customer Reviews

Most Helpful Customer Reviews

7 of 7 people found the following review helpful:

5.0 out of 5 stars A very good way to learn SQL Server 2005 Express, October 15, 2007

By	Albert T. Williams (Belle Mead, NJ USA) - See all my reviews (REAL NAME)

This is an excellent book for learning SQL Server 2005 Express. I started learning MS Access in 2003 when my wife asked me to develop a database for her to use at work. At the time I knew only the words "relational database". Over 99% of what I needed to know to develop that contact and resource management database to its fully featured capability came from multiple books.

The expectations have changed over time and now I need to use SQL Server 2005 Express as a back end with Access as the front end for that database. Knowing nothing about SQL Server 2005, I needed a very good book to help bring me up to speed. I found that in Robin Dewson's "Beginning SQL Server 2005 Express."

From the installation of SQL Server 2005 Express through an explanation of Triggers and Reporting Services, there is a clear and concise explanation of each aspect with the opportunity to Try It Out. I needed to know all of what he presents and I was especially interested in Installation, Security, and Database Backup, Recovery, and Maintenance. The Installation chapter explains very carefully and clearly authentication mode, service accounts, user instances, etc. The Security chapter clearly explains logins, server roles, database roles, and schemas. The Database Backup, Recovery, and Maintenance chapter is also clear and carefully written with information on types of backups, detaching and attaching a database, and transaction logs.

The Chapter headings are:
1. SQL Server 2005 Express Overview and Installation
2. SQL Server Management Studio Express
3. Database Design and Creation
4. Security
5. Defining Tables
6. Creating Indexes and Database Diagramming
7. Database Backup, Recovery, and Maintenance
8. Working with the Data
9. Building a View
10. Stored Procedures
11. T-SQL Essentials
12. Advanced T-SQL
13. Triggers
14. Reporting Services

Robin Dewson is a very good teacher with the gift of knowing how to present a concept and then build concept on concept. He also provides helpful tips on things to do and not to do.

6 of 6 people found the following review helpful:

5.0 out of 5 stars A good way to learn the inner workings of SQL Server, October 31, 2007

By	James Hoisington "jim..." (Dallas, TX USA) - See all my reviews (REAL NAME)

I have been querying SQL Server databases for six years using .Net. This book took me inside SQL Server and showed me how to manage tables, relations, stored proceedures, indexes and triggers.

The book achieves great mix of instruction and best practices. At times, I found myself wanting to know more but the book is already over 400 pages.