Mastering MS SQL Server 2005 Express Edition

Mike Gunderloy is one of the world's foremost database developers. He has written VB Developer's Guide to ADO and SQL Server In Record Time for Sybex, and contributed to Access Developer's Handbook (in several versions), all from Sybex.

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(r) Express

Using SQL Server Management Studio Express

Sharing data between multiple servers

Monitoring and optimizing SQL Server Express

Featured on CD

CD includes Microsoft(r) SQL Server Express and Visual Basic(r) Express!

Leverage the Experience of Experts through Real-World Examples

Increase Your Own Productivity with an Entire Chapter on Troubleshooting

Discover Practical Solutions to a Database Administrator''s Needs

Reduce Complexity and Build Simple Data-Driven Applications

ISBN: 81-265-0894-9
Published by: Wiley India