Microsoft SQL Server 2008: T-SQL Fundamentals

by Mathew R. Kaser

This essential reference is designed for database developers and administrators who need to write queries and develop code using Transact-SQL (T-SQL), the Microsoft implementation of the standard SQL language. Guided by SQL Server guru Itzik Ben-Gan, you'll walk through the steps for writing queries, including retrieving and modifying data, with an overview of programmable objects supported by SQL Server 2008. Rather than focusing just on the syntactical elements of T-SQL, however, this book explains the logic behind the language - helping you develop a true, core understanding of the elements and how to use them. You will learn to think in terms of sets, and follow real-world best practices for T-SQL programming. To complement the learning experience, the book provides exercises to practice and apply what you've learned. And you'll examine recommended solutions to compare with your own work. The entire book's code samples will be available for download from the companion Web site.

Genres: Reference, Programming

Paperback

First published October 21, 2008

Reviews

[Marcus · Rating 5 out of 5]

I use SQL on daily basis, but my official training in this technology is a bit dated. I selected this book for a private refresher course and it turned out to be exactly what I was looking for. Lot of information in this volume was already familiar to me, but a lot of blanks were also filled. Furthermore, I also learned a lot of new stuff specific to SQL Server 2005/2008.

[Mark · Rating 2 out of 5]

Good for what it needed to be for me: a refresher on SQL.

[Volodymyr · Rating 4 out of 5]

Good introductory book to T-SQL, some advanced topics are revealed in other books, like "inside t-sql querying"