Wrox’s SQL Server 2005: express edition starter kit

Rajesh George, Lance Delano9780764589232, 0-7645-8923-7

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.

---

Table of contents :
Cover……Page 1
Contents……Page 12
Acknowledgments……Page 18
What This Book Covers……Page 20
How This Book Is Structured……Page 21
What’s on the CD-ROM?……Page 23
Source Code……Page 24
p2p.wrox.com……Page 25
Introducing SQL Server 2005 Express Edition……Page 28
Features and Benefits of SSE……Page 31
SSE User Scenarios……Page 32
Visual Basic or C#……Page 39
Installing SSE and Visual Basic Express……Page 40
Exercises……Page 43
Basic Database Concepts……Page 44
Introduction to SQL Server Management Studio Express Edition……Page 47
Using Transact-SQL (T-SQL) with Query Editor……Page 52
Exercises……Page 67
Creating a Simple Database Application……Page 68
Creating Your First Application……Page 69
Exercises……Page 81
Designing Your Database in VB Express……Page 84
Creating a Master-Detail Form……Page 88
Working Directly with Components……Page 94
Printing……Page 102
Summary……Page 103
Exercises……Page 104
Developing a Rich Web Database Application……Page 106
Creating a Web Application Using Web Express……Page 107
Master Pages……Page 108
Adding a Database……Page 110
Filtering Data……Page 113
Inserting Data……Page 116
Working with Master Detail……Page 118
Help with More Complex Queries……Page 121
Summary……Page 123
Exercises……Page 124
Introduction to Xcopy……Page 126
Getting Deeper into User Instances……Page 131
Summary……Page 141
Exercises……Page 142
Using XML in Your Database Application……Page 144
Creating an XML Schema Definition……Page 145
Creating a Schema Collection in SSE……Page 149
Creating a Column with an XML Data Type……Page 151
Populating an XML Column with Data……Page 153
Querying an XML Column……Page 155
Exercises……Page 157
Debugging Database Applications……Page 158
Basic Verification……Page 159
Tracing Output……Page 160
VB Express Debugger……Page 162
Assertions……Page 165
T-SQL Debugging……Page 166
SQL CLR Debugging……Page 168
Exercises……Page 169
Installing SSE with the Setup Graphical User Interface……Page 172
Post-Installation Verification……Page 187
Silently Installing SSE……Page 188
Adding or Removing SSE 2005 Features……Page 196
Uninstalling SSE……Page 200
Summary……Page 202
Exercises……Page 203
Deploying Your Application……Page 204
Deploying Your Application……Page 205
Updating Your Application……Page 208
Publishing Your Web Application……Page 213
Exercises……Page 216
Understanding Microsoft Desktop Engine (MSDE)……Page 218
Upgrading MSDE to SSE……Page 229
Summary……Page 243
Exercises……Page 244
Introduction to Microsoft Access and Jet……Page 246
Comparing SSE, MSDE, and Jet……Page 248
Introduction to Access Project Development with MSDE……Page 253
Migrating from Jet to MSDE or SSE……Page 260
Summary……Page 270
Exercises……Page 271
Introduction to SSE Security……Page 274
SSE Security Model……Page 289
Exercises……Page 297
Introducing SQL Server 2005 Editions……Page 298
Reasons to Upgrade from SSE……Page 300
Features Offered by SQL Server 2005 Editions……Page 301
Upgrading from SSE to Editions of SQL Server 2005……Page 305
Summary……Page 317
Exercises……Page 318
Choosing and Creating Primary Keys……Page 320
Creating Alternate Keys……Page 329
Creating Constraints……Page 330
Views……Page 331
Table-Valued Functions……Page 333
Transactions……Page 335
Moving Your SSE Application to a Server……Page 337
Summary……Page 339
Exercises……Page 340
Exercise Answers……Page 342
Index……Page 364