| | |  | Manager's Guides to Computing | Home » » » Microsoft Sams Teach Yourself SQL Server 2005 Express in 24 Hours | | | | | | | Description: | | Written with clarity and a down-to-earth approach, Sams Teach Yourself SQL Server 2005 Express in 24 Hours covers the basics of Microsoft's latest version of SQL Server. Expert author Alison Balter takes you from basic concepts to an intermediate level in 24 one-hour lessons. You will learn all of the basic tasks necessary for the administration of SQL Server 2005. You will also learn how to write and fully utilize: - SQL Server stored procedures
- Functions
- Triggers using T-SQL, VB.NET, and C#
You will also learn how to output SQL Server data to reports and the Internet. Sams Teach Yourself SQL Server 2005 Express in 24 Hours is a well-organized, authoritative introduction that will quickly have you up and running with SQL Server 2005. | | | Product Details: | | | Author:
| Alison Balter | | Paperback:
| 456 pages | | Publisher:
| Sams | | Publication Date:
| June 26, 2006 | | Language:
| English | | ISBN:
| 0672327414 | | Product Length:
| 8.96 inches | | Product Width:
| 7.36 inches | | Product Height:
| 1.05 inches | | Product Weight:
| 1.62 pounds | | Package Length:
| 9.06 inches | | Package Width:
| 6.93 inches | | Package Height:
| 1.1 inches | | Package Weight:
| 1.54 pounds | | Average Customer Rating:
|  based on 11 reviews |
| | | | Customer Reviews: | |
Average Customer Review:
 ( 11 customer reviews )
Write an online review and share your thoughts with other customers.
Most Helpful Customer Reviews
8 of 9 found the following review helpful:
 Excellent Reference Book from experience IT personSep 03, 2006
By Douglas Mackay
I was not going to write a review- this is my first. I have read Ms Balter's SQL Server 2005 Exp & can say I found many fine examples of fundamental SQL action queries to triggers, T-SQL coding, database security to writing VB.NET and ADO for creating stored procedures. I have read other books - Murach's Introduction to VB.NET and Murach's SQL for SQL SERVER etc. This book is worth the price of those others. In my opinion and experience it is a good "fundamental and introductory" SQL 2005 book. The 1 problem I had was finding the T-SQL and VB.NET source code.
7 of 8 found the following review helpful:
 Great Hands-on Introductory BookJan 23, 2007
By Gary G. Frank
I wanted a book that taught me how to use SQL Server Express so that I could use the free version of Microsoft's database for small projects. I did get that, and I also got hands-on training that gave concise information about SQL Server 2005 in general. The major topics were all covered, including database concepts, how to create and administer a database, the SQL statements to access it, and Stored Procedures. The point of this book is to present just enough material so that you have an overall understanding of SQL Server 2005 Express and how to code and administer it. It provides small exercises that allow you to test out and "own" the material as you move along. It gets you up-to-speed. Then after reading this book, a person can pick up other books such as "Murach's SQL Server 2005 for developers" in order to get more detail about these topics. It really helped me to get jump-started on both SQL Server 2005 Express and SQL Server 2005.
The CD that came with the book contains SQL Server Managment Studio Express, which is Microsoft's free tool to administer the database, and Visual [...] Express. I installed them on the machine at the customer site, and it was all that I needed to get the project completed. This book is what you need when you want to get a basic understanding of SQL Server 2005 and learn enough to do productive work with it.
3 of 3 found the following review helpful:
 Don't bother looking at this book.Oct 25, 2007
By Val
"the cookie fairy"
I would not recommend this book to anyone. It pontificates in a grandiose manner, assuming you'll be impressed by the big words even though they say nothing. If you are looking for a tutorial, this book does not walk you through the processes and sometimes even leads you astray without explaining or helping you through the errors. It doesn't even tell you when you're working in a different database or where to go to get that database so you can continue to follow along. It's not even useful as a reference book. It will tell you a command and if the command requires a code, it just says you need a code. When we did an internet search to find out more about the code, it was explained in one line. Would it have made the book too long to add one more sentence? As someone new to SQL, I found this book to be a complete waste of money and time.
I agree with all the poor ratings listed here - I had not read them before because I bought the book as part of a group at work where we would all be learning together. We are all programmers in other disciplines and most dropped out of the class because this book is so bad. It's funny how some of the good ratings here have to explain how you get around the problems so you can learn from the book - DOES THAT TELL YOU SOMETHING???
3 of 3 found the following review helpful:
 something's gone awry with this oneAug 28, 2007
By theskeptic
"theskeptic"
I agree with the previous reviewer who said that this book does not reflect typical SAMS quality. I'm reading Ben Forta's "MySQL Crash Course" (also by SAMS) at the same time, and the difference is night and day. The first 100 pages of this "Teach Yourself" book do not even employ any actual databases... it's all just dry abstract instruction: "If you want to do this... then do this... if you want to do this... then do this..." Besides being unreadable from sheer bone dryness, without any examples it's almost impossible to figure out why or when you'd want to do any of these things. These first 100 pages literally read like they were copied out of Microsoft's online-help. In Chapter 6 the author first introduces a sample database (Northwind), so I'm hoping things will improve somewhat, but I'm not too optimistic with this one.
3 of 3 found the following review helpful:
Diappointing TextJun 21, 2007
By Wildcard51
I have had great experiences with Sams books in the past, but this book is an exception. This book struggled to find an identity from the very beginning.
First off there were numerous mistakes throughtout the book. Some were minor like telling the audience to click modify when it should have actually been design. Others are not so minor. In one chapter the author unexpectidly switches to a different database for her examples. This would have been fine, except the author never tells the audience where to find the database or even mentions that she has switched databases (the database is available on Microsoft's website, but this is never mentioned).
The other main gripe I had with this book is the lack of details in important areas. The author would sometimes only devote a paragraph to something very important. Othertimes, the author would spend 15 pages explaining something that could have been done in 3.
A very poor book overall.
See all 11 customer reviews on Amazon.com
| | |
|
