MasteringTM Microsoft SQL ServerTM 2005 Express Edition EXPRESS EDITION

Microsoft's SQL Server 2005 Express Edition is the perfect fit if you're a small business owner, trainer, or student who doesn't need all the bells and whistles of the full version of SQL Server 2005. In this comprehensive guide written by two SQL Server experts, you'll find step–by–step explanations and simplified management tools for

using SQL Server Express in smaller–scale but still mission–critical situations. With a focus on practical tasks, the book thoroughly

covers both database administration and development, smoothly moving you from beginner to advanced subjects.

Coverage Includes

• Understanding basic database concepts
• Getting to know database types: file server, client server, relational and more
• Learning Structured Query Language (SQL) and SQL Server's Transact–SQL
• Creating efficient and useful databases
• Writing queries and stored procedures to explore your data
• Automating the administration of your databases
• Developing database applications with Visual Basic® Express
• Using SQL Server Management Studio Express
• Sharing data between multiple servers
• Monitoring and optimizing SQL Server Express

Featured on CD
CD includes Microsoft® SQL Server Express and Visual Basic® Express!

Leverage the Experience of Experts through Real–World Examples

Increase Your Own Productivity with an Entire Chapter on Troubleshootng

Discover Practical Solutions to a Database Administrator's Needs

Reduce Complexity and Build Simple Data–Driven Applications

PART I: INTRODUCING SQL SERVER EXPRESS.

Chapter 1. Introduction to SQL Server Express.

Chapter 2. Overview of Database Concepts.

Chapter 3. Overview of SQL Server Express.

Chapter 4. Database Design and Normalization.

PART II: TRANSACT–SQL.

Chapter 5. Transact–SQL Overview and Basics.

Chapter 6. Select Queries.

Chapter 7. Action Queries.

Chapter 8. Topics in Advanced Transact–SQL. 

PART III: DIGGING INTO SQL SERVER EXPRESS.

Chapter 9. Using Management Studio Express.

Chapter 10. Databases.

Chapter 11. Tables.

Chapter 12. Indexing.

Chapter 13. Views.

Chapter 14. Stored Procedures.

Chapter 15. Using Triggers.

PART IV: ADMINISTERING SQL SERVER EXPRESS.

Chapter 16. Basic Administrative Tasks.

Chapter 17. Security and SQL Server Express.

PART V: DEVELOPING APPLICATIONS WITH SQL SERVER EXPRESS.

Chapter 18. Working with Visual Basic Express.

Chapter 19. Accessing Data Using ADO.NET.

Chapter 20. Automating SQL Server Express Using SMO and RMO.

PART VI: ADVANCED SQL SERVER EXPRESS ADMINISTRATION.

Chapter 21. Locking.

Chapter 22. Monitoring anad Optimizing SQL Server Express.

Chapter 23. Replication.

Chapter 24. Service Broker.

Chapter 25. Troubleshooting.

Appendix: Transact–SQL Reference.

Index.

Susan Sales Harkins is the bestselling author of several database books, including Mastering Dreamweaver® MX Databases. She was formerly an editor–in–chief at The Cobb Group.