Beginning SQL Server 2008 Express for Developers: From Novice to Professional / Edition 1

Paperback (Print)
Buy New
Buy New from BN.com
$27.50
Buy Used
Buy Used from BN.com
$23.52
(Save 41%)
Item is in good condition but packaging may have signs of shelf wear/aging or torn packaging.
Condition: Used – Good details
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 95%)
Other sellers (Paperback)
  • All (23) from $1.99   
  • New (9) from $25.27   
  • Used (14) from $1.99   

Overview

Beginning SQL Server 2008 Express for Developers: From Novice to Professional takes a developer, and even a database administrator, from knowing nothing about SQL Server 2008 Express Edition to being ready to design and build a fully functioning system that is secure, reliable, maintainable, and robust. The Express Edition of SQL Server is a free resource commonly used by students, developers of small systems, and those transferring skills from other databases. This book focuses on the features within the Express Edition and therefore will not confuse readers with coverage of features found only in the Development Edition. By the end of the book, readers will be ready to move on to Accelerated SQL Server 2008 as well as other books within the Apress SQL Server lineup such as Pro SQL Server 2008 Reporting Services.

  • Covers using the free Express Edition of SQL Server
  • Describes creating a database from scratch and builds on this
  • Provides an understanding of SQL Server Express 2008, allowing you to build future solutions for you and your business


What you’ll learn

  • Learn what features exist within SQL Server 2008 Express Edition and how to install and upgrade the product and set up security.
  • Design and create a database.
  • Build database objects, such as tables and stored procedures, graphically as well as programmatically.
  • Work with data—inserting, updating, deleting, and retrieving—using simple and complex queries, programs, and data views.
  • Generate reports from data.
  • Implement a solid database maintenance strategy that includes backing up and restoring your data when necessary.
  • Take advantage of advanced Transact–SQL techniques to get the most out of your data.
  • Ensure good performance by building the right indexes, defining the right relationships between tables, and joining tables in the most optimal manner.


Who this book is for

Anyone interested in working with SQL Server as a database, and particularly those who wish for a no–cost database platform that plays well in the .NET environment. Ideal for those starting out in IT or who have to prior database experience.

Read More Show Less

Product Details

  • ISBN-13: 9781430210900
  • Publisher: Apress
  • Publication date: 11/14/2008
  • Edition number: 1
  • Pages: 536
  • Sales rank: 1,405,880
  • Product dimensions: 6.90 (w) x 9.10 (h) x 1.30 (d)

Meet 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.
Read More Show Less

Table of Contents


Ch. 1 SQL Server 2008 Express Overview and Installation 1 Ch. 2 SQL Server Management Studio Express 23 Ch. 3 Database Design and Creation 53 Ch. 4 Security and Compliance 99 Ch. 5 Defining Tables 131 Ch. 6 Creating Indexes and Database Diagramming 167 Ch. 7 Database Backup and Recovery 201 Ch. 8 Inserting Data and Transactions 249 Ch. 9 Selecting, Updating, and Deleting Data 277 Ch. 10 Building a View 321 Ch. 11 Stored Procedures and Functions 349 Ch. 12 T-Sql 423 Ch. 13 Advanced T-SQL 423 Ch. 14 Triggers 453 Ch. 15 SQL Server 2008 Reporting Services 479 Index 499
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)