Microsoft SQL Server 2005 Express Edition For Dummies

Be the first to write a review

Overview

  • Delivers the know-how that novice database developers, enthusiasts, and independent software vendors need in order to use the SSE database
  • Written in the typical nonintimidating For Dummies style, the book's emphasis is on installing SSE and using it to create simple database applications with other tools in Microsoft's Express product line
  • Covers how to use SQL Server Express Manager, an easy-to-use ...
See more details below
Paperback (BK&CD-ROM)
$22.19
BN.com price
(Save 26%)$29.99 List Price
Pick Up In Store

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (33) from $1.99   
  • New (8) from $10.96   
  • Used (25) from $1.99   
Sending request ...

More About This Book

Overview

  • Delivers the know-how that novice database developers, enthusiasts, and independent software vendors need in order to use the SSE database
  • Written in the typical nonintimidating For Dummies style, the book's emphasis is on installing SSE and using it to create simple database applications with other tools in Microsoft's Express product line
  • Covers how to use SQL Server Express Manager, an easy-to-use management tool that comes with SSE, and the Application XCopy feature, which provides SSE with the ability to treat databases like files
  • Addresses topics unique to SSE and not covered in standard SQL Server books, including network and security features, migrating and connecting from Access and MSDE to SSE, and migrating from SSE to the full-blown SQL Server database
  • The CD-ROM contains SQL Server Express trial version and the Web site has the code from applications featured in the book

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Read More Show Less

Product Details

  • ISBN-13: 9780764599279
  • Publisher: Wiley
  • Publication date: 7/31/2006
  • Series: For Dummies Series
  • Edition description: BK&CD-ROM
  • Edition number: 1
  • Pages: 408
  • Product dimensions: 7.50 (w) x 9.25 (h) x 0.84 (d)

Meet the Author

Robert D. Schneider has more than 15 years of experience developing and delivering sophisticated software solutions worldwide. He has provided database optimization, distributed computing, and other technical expertise to a wide variety of enterprises in the financial, technology, and government sectors. Clients have included Chase Manhattan Bank, VISA, HP, SWIFT, and the governments of the United States, Brazil, and Malaysia.
He is the author of Optimizing Informix Applications, Microsoft SQL Server: Planning and Building a High Performance Database, and MySQL Database Design and Tuning. He has also written numerous articles on technical and professional services topics. He can be reached at Robert.Schneider@Think88.com.
Read More Show Less

Table of Contents

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.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
Sort by: Showing all of 2 Customer Reviews

  • Anonymous

    Posted Tue Aug 01 00:00:00 EDT 2006

    Simple and Helpful

    I downloaded this software for free and I thought I could teach it to myself but realized I would need some help. This book is just what the doctor ordered. The author does a great job explaining everything in a very clear style with lots of examples. Soon the confusion was replaced with understanding, and I was able to develop my application quickly and correctly. I certainly give it two big thumbs up!

    1 out of 1 people found this review helpful.

    Was this review helpful? Yes  NoThank you for your feedback.   Report this reviewThank you, this review has been flagged.

  • Anonymous

    Posted Mon Apr 19 00:00:00 EDT 2010

    No text was provided for this review.

Sort by: Showing all of 2 Customer Reviews
If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)