Synopses & Reviews
A Comprehensive Guide to Microsoft's New Express Edition of its Bestselling Database Server
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
Synopsis
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.
Synopsis
Reduce Complexity and Build Simple Data-Driven Applications
About the Author
Mike Gunderloy has been developing software for over 25 years, during which time he has gained expertise across a wide variety of Microsoft technologies. His books include Mastering SQL Server 2005; Mastering Visual C#®; ADO and ADO.NET Programming; and Coder to Developer.
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.
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.