|
|
|
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. |
|
|
|
|
|
Appendix A: Upgrading to SQL Server 2005. |
|
|
|
Appendix B: Migrating to SQL Server 2005 Express. |
|
|
|
|
|
Appendix D: About the CD-ROM. |
|
|
|
|