Mastering Microsoft SQL Server 2005 Express Edition (Paperback)

Description

SQL Server 2005 Express Edition is a scaled-back version of Microsoft's best-selling database manager, offered as part of the new Visual Studio 2005 Express Edition. It contains new, simplified management tools and development environment, and is provided free of charge--in part to compete with open-source solutions, such as the popular MySQL. It lacks the bells and whistles of the full version, but works as a solution for small-to-medium-size businesses, data-driven web sites, and educational institutions.

 

Table of Contents

Introduction.

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.