Skip to main content

Wrox's SQL Server 2005 Express Edition Starter Kit

Wrox's SQL Server 2005 Express Edition Starter Kit

Rajesh George, Lance Delano

ISBN: 978-0-471-78511-8

Jan 2006

360 pages

Select type: E-Book

Product not available for purchase

Description

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.

Introduction.

PART I: INTRODUCTION AND CONCEPTS.

1. Getting Started with SQL Server 2005 Express Edition.

2. Database Basics with SQL Server Express.

3. Creating a Simple Database Application.

PART II: RICH DATABASE APPLICATIONS DEVELOPMENT WITH SQL SERVER EXPRESS.

4. Developing a Rich Client Database Application.

5. Developing a Rich Web Database Application.

6. Understanding Xcopy Deployment.

7. Using XML in Your Database Application.

8. Debugging Database Applications.

PART III: SETUP AND DEPLOYMENT.

9. Understanding SQL Server Express Setup.

10. Deploying Your Application.

11. Migrating from MSDE.

12. Migrating from Jet and Microsoft Access to MSDE and SSE.

PART IV: DEVELOPING MULTI-USER APPLICATIONS.

13. Securing Your Multi-user Database Application.

14. Upgrading from SSE to Other SQL Server 2005 Editions.

15. Building Robust Multi-user Data Applications.

Appendix: Answers to Exercises.

Code Downloads
Code downloads for this title are available here.
Downloadable Code
This file contains all the downloadable code for this title. The content is stored in a ZIP format archive. If you are unable to open ZIP files, you can download a free version of Winzip.
Download
ChapterPageDetailsDatePrint Run
28Error in Text
ROW:6
COLUMN:Range/Size
10^38+1 to 10^38-1

should be:
-10^38+1 to 10^38-1
06/08/07

37Error in Text
Tryout section, 4th paragraph, last row:
DELETE * FROM Inventory WHERE ID=1

should be :
DELETE FROM Inventory WHERE ID=1
08/11/08

38Error in Text
The second sentence of the 5th paragraph reads, "Also there is some performance degradation during upgrades and deletes because ..."

upgrades

should be:

updates
03/17/2008

41Errors in Text
In CREATE VIEW InventoryPublisherView AS
(SELECT * FROM Inventory AS I FULL OUTER JOIN Publisher AS P ON I.ID=P.InventoryID)

Column name in Publisher table reads:
ID

Should read:
PubID

AND

The first highlighted code reads:
USE testDB GO CREATE VIEW InventoryPublisherView AS (SELECT * FROM Inventory AS I FULL OUTER JOIN Publisher AS P ON I.ID=P.InventoryID)

Should read:
USE testDB GO CREATE VIEW InventoryPublisherView AS (SELECT I.ID, I.name, I.type, I.quantity, P.pubName FROM Inventory AS I FULL OUTER JOIN Publisher AS P ON I.ID=P.InventoryID)
04/14/2006

72Error in Code
Line missing:
There should be a line with BindingSource.Position and BindingSource.Find.
11/20/06