Product DescriptionA 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 Troubleshootng
Discover Practical Solutions to a Database Administrator's Needs
Reduce Complexity and Build Simple Data-Driven Applications
Customer Reviews
Average Rating:
Rating: - Absolutely Outstanding book!
I have been creating applications that use Access for the last few years, so it has been awhile since I used SQL Server.
With this book I got up to speed on client/server databases, permissions, stored procedures, triggers, T-SQL. It should be the start for anyone who is interested in this "free!" new SQL Server.
I found it very helpful, well written, succinct.
Rating: - Excellent companion book
Microsoft realeased a free version of SQL Server to compete with mySQL and it's actually quite excellent, especially given its price tag. This book makes the book claim to have you 'mastering' SQL Server, but of course no single book could do that. Instead, it provides a very comprehensive tour-de-force of all the features, bells and whistles, and relies on you - dear, Internet-connected reader - to research areas of particular interest to you.
The biggest flaw is that there's not enough ... Read More
Rating: - FREE SQL - ideal for personal, educational and small business applications
.
Microsoft has developed a FREE, yes that is FREE, SQL application that is actually rather good.
This book will get you up and running on SQL; database concepts and design; trouble shooting your databases as well as introducing you to Visual Basic Express...another FREE app from Microsoft
It isn't as robust as SQL Server, but is far better than Access.
Rating: - Not "a must have" book
I have bought this book for my teaching purposes targeting a "new starter" group. Introductory chapters are good. It has abundant representative pictures. But as the topics progres the book becomes having a little problematic. If you think to buy this book as a self study guide, it is maybe better to look for another one.
On the other hand, SQL Server Express Edition does not have so much book-style resources. This may force the reader to buy this book (as in my case!)
But as a last opinion, ... Read More
Rating: - Good book on sql server
I give this book five stars not because the entire book is great, but because chances are there will be a few parts that 'serve' you well - which is most likely why you buy this book. One or two of these gems (such as adding Encryption to a connection string to automatically encrypt all data moving from sql server onto the network) will be worth the price of the book many times.
The intro on things like normalizing is weak and chances are you will not learn anything here (if you do not know ... Read More
- Absolutely Outstanding book!
- Not "a must have" book 
