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.
Auflage
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Illustrationen
Maße
Höhe: 23.7 cm
Breite: 18.8 cm
Dicke: 23 mm
Gewicht
ISBN-13
978-0-7645-8923-2 (9780764589232)
Schweitzer Klassifikation
Rajesh George is one of the founders of the SQL Server Express project within Microsoft, and has been involved in many of the key design decisions. He worked as a program manager on the SQL Server team responsible for various functionalities in SQL Server Express, MSDE, and SQL Data Access layers. He has spoken at several conferences and has authored the SQL Server Express Overview white paper on Microsoft.com. With prior software development experience in the Windows team at Microsoft as well as companies such as Nortel Networks and Netscape, he is currently a development manager at Amazon.com. Rajesh holds a Masters in Computer Science from Mississippi State University and MBA from University of Washington. You can reach him directly at contactgeorger@yahoo.com.
Lance Delano is a lead program manager in Visual Studio. Lance has an extensive background in database tools including database design and query tools. He is heavily involved in the customer research, proposals, specification, and program management of SQL Server 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.
