Microsoft SQL Server 2008 T-SQL Fundamentals (PRO-Developer) | 
 enlarge | Author: Itzik Ben-gan
Publisher: Microsoft Press
Category: Book
List Price: $49.99
Buy New: $26.76
You Save: $23.23 (46%)
New (36) Used (6) from $25.97
Rating:  2 reviews
Sales Rank: 89613
Media: Paperback
Number Of Items: 1
Pages: 688
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
Condition: All orders ship same business day via standard shipping (USPS Media Mail) if received by 1 PM CST.
| |
| Similar Items:
|
| Editorial Reviews:
Product Description
This book walks you through your first steps in T-SQL (also known as Transact-SQL), which is Microsoft SQL Server s dialect of the standard ANSI-SQL language. You ll learn the theory behind T-SQL querying and programming, how to develop T-SQL code to query and modify data, and get an overview of programmable objects. Although this book is intended for beginners, it is not merely a step-by-step book. It goes beyond the syntactical elements of T-SQL and explains the logic behind the language and its elements. Many aspects of SQL are unique to the language, and are very different from other programming languages. This book helps you adopt the right state of mind and gain a true understanding of the language elements. You learn how to think in terms of sets and follow good SQL programming practices. The book is not version-specific; it does, however, cover language elements that were introduced in recent versions of SQL Server, including SQL Server 2008. To complement the learning experience, the book provides exercises that enable you to practice what you ve learned. The book starts with a theoretical background to T-SQL querying and programming (Chapter 1) laying the foundations for the rest of the book, and also coverage of creating tables and defining data integrity. The book moves on to various aspects of querying and modifying data (Chapters 2 through 8), then to a discussion of concurrency and transactions (Chapter 9), and finally provides an overview of programmable objects (Chapter 10). This book features a companion Web site that makes available to you all the code used in the book, the errata, additional resources, and more.
|
| Customer Reviews:
Not just syntax, but the theory behind it December 15, 2008
2 out of 2 found this review helpful
I'm half way through this book and I am totally impressed. The author not only explains T-SQL syntax very systematically, but also explains enough of the theory behind it to help you understand why. This makes it much easier to optimize your syntax and avoid logical bugs in your code. This is not an introductory level SQL book, but it's not a book for experts either. I have been writing SQL for years and I have learned a great deal from this book already. I highly recommend this book if you are looking to take your SQL skills from basic/intermediate to a more advanced level.
Excellent book - clear focus and ordered presentation December 4, 2008
3 out of 3 found this review helpful
I have worked with T-SQL for about 11 years, but nevertheless immediately pre-ordered this "Fundamentals" book when I saw a blog post about it - for three reasons: (a) I wanted to fill in any missing gaps in my understanding of the language, (b) I wanted to learn what was new with the 2008 offering, and (c) I have heard Itzik Ben-gan speak and read his blog for sometime and always find his presentations to be excellent. I was not disappointed.
For me, this has been one of those rare reads, where I can see where the topic is going but it is never dull because I either learn something new about the subject or the presentation clarifies what I already knew. I especially like how the book continually reinforces how T-SQL is built on set theory and predicate logic.
Great read and reference. I highly recommend it.
Kudos to the author.
|
|
|
