Binding: Paperback Dewey Decimal Number: 005.2768 EAN: 9780471774228 ISBN: 0471774227 Label: For Dummies Manufacturer: For Dummies Number Of Items: 1 Number Of Pages: 416 Publication Date: April 02, 2007 Publisher: For Dummies Sales Rank: 145599 Studio: For Dummies
Product DescriptionCreate and modify databases and keep them secure
Get up to speed on using T-SQL to store and manipulate data
SQL Server 2005 improves an already great database management system. This book shows you how to put it to work in a hurry. You'll find out how to use the SQL Server Management Studio and the SQLCMD utility to write T-SQL code, retrieve data from single or multiple SQL Server tables, add data using the INSERT statement, and much more.
* Create queries to retrieve data *
Ensure SQL Server security *
Use Visual Studio(r) 2005 with SQL Server *
Create tables, views, and indexes *
Work with Common Language Runtime *
Query XML data
Customer Reviews
Average Rating:
Rating: - Not Good
The author seems like a senior expert, I respect that. However, this book doesn't cover some of the basic t-sql command in detail. When you see some commands that you have never seem them on the previous content, don't be surprised or think you miss something.
Rating: - Good for beginners
I have a few months experience with SQL Server but was able to glean enough from this book to put together the stored procedures, views and security measures I needed for my ASP.NET application in about 2 days. This definitely opens up the door for going in many different directions for someone who doesn't have any experience with T-SQL. Some of the latter chapters assume a moderate familiarity with SQL Server and don't presume to explain any of these concepts. Having come with minimal experience ... Read More
Rating: - Excellent-exactly what I had hoped for!
This book is excellent. I have not worked actively with databases in many years and was trying to learn more about SQL 2005 commands. The book is written in a very logical step-by-step way so you don't get lost or clobbered with a whole lot of lingo that makes you feel inept. Recommend this to anyone who is trying to get a good grip on the subject.