Everyday Computing Advanced Computing The Internet At Home Health, Mind & Body Making & Managing Money Sports & Leisure Travel Beyond The Classroom
Certification
Databases
Networking
Programming
Win a Trip to New York City to see Monty Python's SPAMALOT!
Microsoft SQL Server 2005 Express Edition For Dummies

Microsoft SQL Server 2005 Express Edition For Dummies


By Robert D. Schneider

ISBN: 978-0-7645-9927-9
Format: Paper
Pages: 408 Pages
Pub. Date: July 2006

E-mail a Friend About This Book
Price: $24.99
Description
Author Information
Table of Contents
Read Excerpt: Chapter (PDF)
Read Excerpt: Index (PDF)
Source Code
Introduction.

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.

Related Articles
Where Does SQL Server Express 2005 Work Best?
Getting Down to Business with SQL Server 2005 Express
A Few SQL Server 2005 Express Troubleshooting Tips
Discovering Everything that GoldMine Can Do
How Goldmine 8.0 Differs from Goldmine 6.0
Related Titles
Access 2007 For Dummies
ACT! 2007 For Dummies
Bioinformatics For Dummies, 2nd Edition
FileMaker Pro Design & Scripting For Dummies
GoldMine 8 For Dummies