Microsoft® SQL Server 2005 Express Edition For Dummies®

Part I: Welcome to SQL Server 2005 Express.

Chapter 1: SQL Server 2005 Express Overview.

Chapter 2: Downloading and Installing SQL Server 2005 Express on Your Computer.

Chapter 3: Setting Up SQL Server Express.

Part II: Administering a SQL Server 2005 Express System.

Chapter 4: Putting SQL Server 2005 Express to Work.

Chapter 5: Maintaining a SQL Server 2005 Express System.

Chapter 6: Distributing Your Data with Replication.

Part III: Adding and Accessing a SQL Server 2005 Express Database.

Chapter 7: Planning Your Database.

Chapter 8: Creating Databases, Tables, and Relationships.

Chapter 9: Talking to a SQL Server.

Chapter 10: Transact-SQL: Beyond the Basics.

Part IV: Keeping Your Data Safe from Harm.

Chapter 11: Securing Your Data.

Chapter 12: Keeping It Together: Using Transactions to Maintain Data Integrity.

Chapter 13: Preventing Data Loss.

Part V: Putting the Tools to Work: Programming with SQL Server 2005 Express.

Chapter 14: Using Stored Procedures and Functions.

Chapter 15: Understanding Triggers.

Chapter 16: Going Beyond Transact-SQL: Using the SQL Common Language Runtime (SQLCLR).

Chapter 17: Sorry, I’ll Try That Again: Adding Error Handling to Your Code.

Chapter 18: Full-Text Searching and Reporting Services.

Part VI: Creating SQL Server 2005 Express Applications.

Chapter 19: Building a Simple Desktop Application with Visual Basic Express.

Chapter 20: Building a Simple Web Application with Visual Web Developer Express.

Chapter 21: Using XML with SQL Server 2005 Express.

Part VII: The Part of Tens.

Chapter 22: Ten Sources of Information on SQL Server 2005 Express.

Chapter 23: Ten SQL Server 2005 Express Troubleshooting Tips.

Part VIII: Appendixes.

Appendix A: Upgrading to SQL Server 2005.

Appendix B: Migrating to SQL Server 2005 Express.

Appendix C: Glossary.

Appendix D: About the CD-ROM.

Index.