Microsoft SQL Server 2005 Express Edition For Dummies [Paperback]

Robert D. Schneider (Author)

List Price:	CDN$ 35.99
Price:	CDN$ 25.47 & this item ships for FREE with Super Saver Shipping. Details
You Save:	CDN$ 10.52 (29%)
	o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o

In Stock.
Ships from and sold by Amazon.ca. Gift-wrap available.

Only 1 left in stock--order soon (more on the way).

Want it delivered Monday, February 13? Choose One-Day Shipping at checkout.

Product Details

Paperback: 408 pages
Publisher: For Dummies; 1 edition (July 14 2006)
Language: English
ISBN-10: 0764599275
ISBN-13: 978-0764599279
Product Dimensions: 23.3 x 18.6 x 2.5 cm
Shipping Weight: 431 g
Amazon Bestsellers Rank: #399,783 in Books (See Top 100 in Books)

Would you like to update product info or give feedback on images?

See Complete Table of Contents

Product Description

Delivers the know-how that novice database developers, enthusiasts, and independent software vendors need in order to use the SSE database
Written in the typical nonintimidating For Dummies style, the book's emphasis is on installing SSE and using it to create simple database applications with other tools in Microsoft's Express product line
Covers how to use SQL Server Express Manager, an easy-to-use management tool that comes with SSE, and the Application XCopy feature, which provides SSE with the ability to treat databases like files
Addresses topics unique to SSE and not covered in standard SQL Server books, including network and security features, migrating and connecting from Access and MSDE to SSE, and migrating from SSE to the full-blown SQL Server database
The CD-ROM contains SQL Server Express trial version and the Web site has the code from applications featured in the book

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

From the Back Cover

Find code for sample applications on the companion Web site

Get up and running in no time with this streamlined version of SQL Server

SQL Server Express with Advanced Services is new, cool, inexpensive, and now — thanks to this book — easy to handle! This friendly guide helps you migrate data from other databases, use SQL Server Management Studio Express, protect your information, even create applications and putter with a little programming.

Discover how to

Use SQL Server Management Studio Express
Migrate data from Access and MSDE
Create custom reports using Advanced Services
Formulate and run queries
Maintain data integrity with transactions
Employ XML to send data to Web applications

See all Product Description

Inside This Book (Learn More)

First Sentence
From the developer's or user's perspective, SQL Server 2005 Express strikes a nice balance between price (free) and performance (powerful). Read the first page

Explore More
Concordance

Tag this product

(What's this?)

Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items.

Customer Reviews

There are no customer reviews yet on Amazon Canada

5 star:		(0)
4 star:		(0)
3 star:		(0)
2 star:		(0)
1 star:		(0)

Share your experience with this product with others

Create your own review

Most Helpful Customer Reviews on Amazon.com ^(beta)

Amazon.com: 3.0 out of 5 stars (6 customer reviews)

11 of 11 people found the following review helpful:

5.0 out of 5 stars Really helped me understand this product!!, July 29 2006

By Rory "Rory" - Published on Amazon.com

This review is from: Microsoft SQL Server 2005 Express Edition For Dummies (Paperback)

I downloaded SQL Server for free from microsoft but needed some guidance to help me use the product to its full potential. In searching amazon I came across this book and decided to take a chance. Wow! It gave me a great broad overview of the product without bogging me down in too many details -- great simple writing style, really easy to follow.

In a few days, I was up and running with the software. I'm planning on writing an application using Visual Basic and this book has a great tutorial on using it this way. I would highly recommond this book to anyone who needs to learn how to use SQL Server.

6 of 7 people found the following review helpful:

1.0 out of 5 stars We're Dummies, Not Stupid, July 8 2007

By I. Kolak - Published on Amazon.com

This review is from: Microsoft SQL Server 2005 Express Edition For Dummies (Paperback)

The first 100 pages were read before starting to learn anything of real value. Please don't write for the sake of increasing the page volume of a book. Our time is valuable too.

Trying to be funny and telling us SQL Server 2005 Express is Free over and over again, chapter after chaper, is ... well ... simply not funny. We're dummies, not stupid.

You covered T-SQL relatively well. However, the heart and soul of SQL Server 2005 Express is Stored Procedures, Triggers and SQLCLR - but you barely even scratched the surface. A few pages here and there is not simply enough. So I still feel like a dummy.

6 of 7 people found the following review helpful:

5.0 out of 5 stars A Lot of Good Points about this Book, Aug 26 2006

By John Matlock "Gunny" - Published on Amazon.com

This review is from: Microsoft SQL Server 2005 Express Edition For Dummies (Paperback)

There's a whole bunch to like, in my opinion, about this book and only one point that I think is pretty weak.

First off, what's there to like. Probably most important is that SQL Server Express is available and it's an extremely powerful software system and it's FREE, a very good price. Second is the book which is written in the typical 'For Dummies' style, with an occasional joke thrown in, that makes it pretty easy to read and yet is doing its job of educating you about the subject. And third, there's a CD-ROM supplied with the book that contains SQL Server Express as well as a lot of ancillary but useful programs to go with it. Yes, you can download SQL Server from the Microsoft web site, but having a CD is a lot easier and faster.

The weak point. There's a chapter on migrating from Microsoft Access to SQL Server that primarily talks about upgrading the tables from Access format to SQL Server format using one of the utilities provided. What's missing is a discussion on the differences in Access SQL (based on the 1989 standard) and SQL Server SQL (based on the 1992 standard). If you've used SQL to talk to Access on your previous system, you're in for a bit of a challenge to get it to talk to SQL Server.

› Go to Amazon.com to see all 6 reviews 3.0 out of 5 stars