Wrox's SQL Server 2005 Express Edition Starter Kit

By Rajesh George and Lance Delano

You'll learn the basics of working with SSE databases, and see how the Visual Basic(r) 2005 Express Edition programming environment is tailored to work well with SSE. Step-by-step examples cover major scenarios that you're likely to face, from installation and development to debugging and deployment. Plus, the CD-ROM features both VB Express and SSE so you can get started designing your databases right away. What you will learn from this book How to create simple, single table applications without writing a single line of code Making the transition from SSE to a higher-level version of SQL Server The benefits of using XML in your database How to deploy your applications using Xcopy How to secure your database applications How to move your database to a multi-user scenario Who this book is for This book is for database or programming novices who want to create and deploy database applications. It is also useful for experienced developers and independent software vendors who intend to develop applications for SSE. Wrox Starter Kits give you a CD-ROM with the software development tools you need to get started as well as structured tutorials that walk you through all the techniques you need to begin programming right away.

• Format: Paperback
• Language: English
• ISBN: 0764589237
• ISBN13: 9780764589232
• Release Date: January 2006
• Publisher: Wrox
• Length: 384 Pages
• Weight: 1.35 lbs.
• Dimensions: 9.2" x 0.8" x 7.4"

Customer Reviews

SQL Server specific book

I use MSDE at work the last few years and has recently moved to SQL Server express. My biggest gripe about MSDE was that there was no book covering MSDE - all the books with MSDE in its title was covering other editions of SQL Server. I deployed MSDE with my application and the MSDE books were not very helpful. I like this book because it focusses on SQL Server express. I like the sections specific to sql server express like setup and deployment and recommend this for those who use sql server express with VB.

Good beginner book

I am used to Access, and this book was wonderful to get introduced to and work with SQL Server. Step by step instructions on using sql with Visual Basic helped me a lot. The user interface provided was similar to my usage of access for basic scenarios; ofcourse access ui is more powerful than visual basic's. I would recommend it for a beginning user.

A Beginners Book that doesn't cover SQL.

Among other things, Microsoft really likes to change the names of its products. For some years the Access database supplied as part of the Microsoft Office suite has come with two database engines. Originally supplied with the Jet database, Microsoft then began shipping it with a stripped down version of SQL Server, the latest name of which was Microsoft SQL Server Desktop Engine (MSDE). SQL Server 2005 Express Edition (SSE) is MSDE brought up to date using SQL Server 2005 as the code base rather than SQL Server 2000. Perhaps the most important feature added is the graphical user interface that allows the creation of tables, defining relationships between tables and other simple database applications. The one point that I would have liked to see in this book is more information, perhaps even a chapter on SQL. Especially in the section on migrating from the Jet database in Access to SSE some comments on the differences between the two SQL's would be very helpful. For instance, in Access SQL (Jet Engine) you can have JOINs in UPDATE and DELETE statements. In T-SQL you can't. In T-SQL you can have a subquery in the SET clause of UPDATE statements, in the Jet engine you cannot. Finding all these differences is difficult. I'd like to see them in the migrating chapter. Still, this book is intended for the beginner who is going to use Microsoft's GUI approach for everything, and not SQL. For that purpose it is excellent.

Great introduction

This book is a great book about SQL Server Express and a great introduction to other versions of SQL Server. In fact, it describes every nuance of SQL Server Express from creating tables, indexes and views to deploying and multi-user scenarios. It fills the gaps of the MSDN about SQL Server Express.

WONDERFUL

This book is amazing! It told me everthing I would want to know about SQL server express.