* This step-by-step guide for database programming novices examines Microsoft SSE 2005, a low-cost version of SQL Server 2005 designed to win over users of such free databases as MySQL and Microsoft Jet
* Begins with SSE fundamentals, including installation, creating the first database, tables, and queries, and then moves on to cover topics not featured in any other publication, such as application Xcopy deployment, unattended set up and deployment, and unique redistribution scenarios
* Step-by-step samples cover all the major scenarios the reader will face, from installation and development to debugging and deployment
* Ideal for the hobbyists who are downloading SQL Express for the first time as well as advanced users such as independent software vendors intending to distribute their applications along with SQL Express 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.