|
Microsoft SQL Server 2008 T-SQL Fundamentals (PRO-Developer) |  | Author: Itzik Ben-gan
Publisher: Microsoft Press
Category: Book
List Price: $49.99
Buy New: $27.48
as of 7/30/2010 03:46 CDT details
You Save: $22.51 (45%)
New (28) Used (14) from $20.00
Seller: new_books_today
Rating:  15 reviews
Sales Rank: 11867
Media: Paperback
Edition: 1
Pages: 416
Number Of Items: 1
Shipping Weight (lbs): 1.9
Dimensions (in): 9 x 7.3 x 1.4
ISBN: 0735626014
Dewey Decimal Number: 005
EAN: 9780735626010
ASIN: 0735626014
Publication Date: October 22, 2008
Availability: Usually ships in 1-2 business days
| |
| Features:
| • | ISBN13: 9780735626010 | | • | Condition: New | | • | Notes: BUY WITH CONFIDENCE, Over one million books sold! 98% Positive feedback. Compare our books, prices and service to the competition. 100% Satisfaction Guaranteed |
|
| Similar Items:
| |
| Editorial Reviews:
Product Description
Master the foundations of T-SQL with the right balance of conceptual and practical content. Get hands-on guidance—including exercises and code samples—that show you how to develop code to query and modify data. You’ll gain a solid understanding of the T-SQL language and good programming practices, and learn to write more efficient and powerful queries. Discover how to: - Apply T-SQL fundamentals, create tables, and define data integrity
- Understand logical query processing
- Query multiple tables using joins and subqueries
- Simplify code and improve maintainability with table expressions
- Explore pivoting techniques and how to handle grouping sets
- Write code that modifies data
- Isolate inconsistent data and address deadlock and blocking scenarios
|
| Customer Reviews:
Showing reviews 1-5 of 15
 Awesome for advanced T-SQL users, and intimidating for a novice. May 4, 2010
T. Lee (Colorado, USA)
2 out of 2 found this review helpful
DON'T buy this book if you're a T-SQL beginner. The name made me think the book would be geared toward basic/foundational concepts. This is absolutely not the case, however I'm very excited about having this as a terrific mid to advanced level reference down the road.
I've been a SQL System Administrator for many years, but never needed to understand the queries, just how to protect, backup and recover the databases. Thank goodness my husband was able to translate for me! For this reason I give it a 1.5 star rating for new users but a 4.5 rating for T-SQL administrators. Once I was able to understand what he was trying to say, and reference the [&] website to break the queries into manageable bites, the lights came on.
I have now purchased a few other T-SQL books and without a doubt, this unique reference will become my master. However I couldn't do this without taking the first lessons in more introductory material. Can't wait to be a guru and actually understand this beast of a book!
 Superb Learning and Resource Book December 10, 2009
S. Gallardy
1 out of 1 found this review helpful
This book is an absolute 5.
The information is given in a way that makes it easy for anyone to understand with great sample problems at the end of each chapter. I found myself continually reading it and couldn't put it down, which for a technical book is unheard of!
There were many places where I thought I had known how different areas worked and then I read this book. This is a must have not only as a learning tool but as a reference for those once in a while situations when you get to use new or otherwise novelty features of SQL Server's T-SQL.
If you had any doubt whether or not to purchase this book, I would highly encourage you to do so!
The nitty gritty December 9, 2009
Wallace P. Middleton (Richmond, VA)
Pleased to find the other reviews were correct in that this book really fills in the gap and gets into nitty gritty nuances of querying... way beyond the basics. Only a 1/4 of way through now, but learning new aspects/features of sql with every read.
 Quirky Terms all around September 17, 2009
TP_FAN (New York, NY USA)
5 out of 14 found this review helpful
I am not new to T-SQL, got this book for picking up some missing parts of the language that I am not familiar with
Frankly, I dont like the presentation/writing style of this book, for
1. Guess english is not authors first language.
2. This book uses quite some quirky terms( invented by authors himself) that haven't been used elsewhere but this book, such as "Logical Precedence Among rows". If you google "Logical Precedence", all the pages will refer to things about this guy..What the hell?? these awkward terms make some of the simple ideas more difficult to get.
3. Basically, T-SQL is based on ANSI SQL, and SQL itself is based on relational algebra as well as semantics of your business requirements. This book talks too much about syntax details of in microscope level, while too little on how to interpret the business demands in elegant T-SQL. i.e. how to map it into algebra equation.
This book separates join and intersection things into 2 chapters, which might not seem to be necessary for my part.
Hardly can say this book is enjoyable to read, but its OK for a T-SQL supplement.
Lives up to the title - best book I've found on SQL Fundamentals September 13, 2009
T. Walters (Colorado, USA)
2 out of 2 found this review helpful
I'm not a SQL programmer or DBA. I use SQL to query databases and write reports in SSRS (Microsoft SQL Server Reporting Services). I was looking for a book that would explain SQL fundamentals in a user-friendly manner and this is it. Mr. Itzik Ben-Gan writes like a teacher, not a technician. He gives you the technical details followed by real life explanation, with code and results; that a non-tech can understand. This book gives you the foundation you need to expand your SQL knowledge.
Should you buy it if you are using SQL 2005? Yes, even though 2008 is in the title, Mr. Ben-Gan covers both SQL versions, explaining differences between the versions.
Showing reviews 1-5 of 15
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. Copyright 2009, SQL Server 2008 Books. All Rights Reserved.
In association with Amazon.com | |
