Author(s) : Rajesh George, Lance Delano
Publisher : Wrox
Year : Jan 2006
ISBN 10 : 0764589237
ISBN 13 : 9780764589232
Language : English
Pages : 384
File type : PDF
Size : 6.5 MB (book + source code)
This book focuses on using SQL Server 2005 Express Edition (SSE) to design and build your desktop and web applications. In addition to the tools supplied with SSE, Visual Basic Express 2005 and Web Express 2005 are used to for application development. The features that are unique to SSE such as Xcopy, User Instances, and deployment are also covered in detail. The Microsoft SQL Server Books Online focuses primarily on other editions of SQL Server, and the details specific to its free edition is often lost. You can use this book not only to jump start your database application development, but also as a reference on SSE features.
This book assumes you have very little background with either databases or programming. You may never have created a single application of any kind. No prior programming experience is required, but you should have an aptitude for working with software and a desire to learn. If you have a desire to learn and an interest in storing information in a database—and in creating drop-dead simple applications to work with the data—this book has a lot to offer. The step-by-step samples cover all the major scenarios SSE is designed for, from installation and development to debugging and deployment.
Alternatively, if you are a more experienced developer, you may find this book useful because it describes a number of new features that are unique to SSE that make working with SSE much easier than with its predecessor, MSDE. You get an insight into the SSE design and architecture from the authors who are intimately involved in the creation of many of these features. In addition, you will find useful information about the various deployment and programmatic features that are not properly documented.
There are four major areas in this book. The first part is a basic introduction to SQL Server, VB Express, and some basics of working with databases. Next, you move into richer application development topics. In the third part, you will learn some of the details of setting up and distributing SSE in scenarios that are more sophisticated. Finally, there is a section on developing multi-user applications.
TABLE OF CONTENT:
Chapter 01 - Getting Started with SQL Server 2005 Express Edition
Chapter 02 - Database Basics with SQL Server Management Studio Express Edition
Chapter 03 - Creating a Simple Database Application
Chapter 04 - Developing a Rich Client Database Application
Chapter 05 - Developing a Rich Web Database Application
Chapter 06 - Understanding Xcopy Deployment and User Instance Model
Chapter 07 - Using XML in Your Database Application
Chapter 08 - Debugging Database Applications
Chapter 09 - Understanding SQL Server Express Setup
Chapter 10 - Deploying Your Application
Chapter 11 - Migrating from Microsoft Desktop Engine (MSDE)
Chapter 12 - Migrating from Jet and Microsoft Access to MSDE and SSE
Chapter 13 - Securing Your Multi-User Database Application
Chapter 14 - Upgrading from SSE to Other SQL Server 2005 Editions
Chapter 15 - Building Robust Multi-User Database Applications
ot
Download from Mihd
http://FastFreeFileHosting.com/file/262/sqls2k5expedsk-rar.html