 See larger picture | Mastering Microsoft SQL Server 2005 Express Edition (Mastering)
by
Mike Gunderloy and Susan Sales Harkins
- SybexList Price: $39.99
Price at Amazon.com: $26.39
(Save
34%)
 Availability: Usually ships in 24 hours
Shipping rates and policies |
- Average Customer Review:
Based on
6
reviews.
- Amazon.com Sales Rank: 78338
|
Product Description 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 Troubleshootng
Discover Practical Solutions to a Database Administrator's Needs
Reduce Complexity and Build Simple Data-Driven Applications
Featured Customer Reviews  Absolutely Outstanding book!,
June 04, 2008
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.Excellent companion book,
February 18, 2008 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 information to get you up and running in the first place. Literally, the installation instructions for SQL Server Express are esoteric, and there's a couple of missing pieces of information, without which you're going nowhere. But a little digging around on the Net will have you running fairly quickly.
Overall, a great little book for the price.FREE SQL - ideal for personal, educational and small business applications,
September 12, 2007 .
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.
 Not "a must have" book ,
August 14, 2007
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, this book is not a "must have book"
Good book on sql server,
June 14, 2007 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 the basics about normalizing a database schema, then chances are some tutorials on the internet will help you better).
Sections on backups, locks, internal workings of sql server, smo objects for custom management apps, logs, etc are all well written and helpful.
A few performance metrics for various typical approaches would have been appreciated, the type of things you have to dig through white papers for.
You might also be interested in these items...
|
|