Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes (Sams Teach Yourself)

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes (Sams Teach Yourself)

Publisher: Sams
Number Of Pages: 368
Publication Date: 2007-08-02
Sales Rank: 158793
ISBN / ASIN: 0672328674
EAN: 9780672328671
Binding: Paperback
Manufacturer: Sams
Studio: Sams
Average Rating: 5

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through 10-minute lessons, you¡¯ll learn everything you need to know to take advantage of Microsoft SQL Server¡¯s T-SQL language.

This handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, subqueries, full text-based searches, functions and stored procedures, cursors, triggers, table constraints, XML, and much more.

You¡¯ll learn what you need to know methodically, systematically, and simply¨Cin highly focused lessons designed to make you immediately and effortlessly productive.

Tips point out shortcuts and solutions

Cautions help you avoid common pitfalls

Notes explain additional concepts, and provide additional information

10 minutes is all you need to learn how to¡­

Use T-SQL in the Microsoft SQL Server environment
Construct complex T-SQL statements using multiple clauses and operators
Filter data so you get the information you need quickly
Retrieve, sort, and format database contents
Join two or more related tables
Make SQL Server work for you with globalization and localization
Create subqueries to pinpoint your data
Automate your workload with triggers
Create and alter database tables
Work with views, stored procedures, and more
Register your book at www.samspublishing.com/register to download examples and source code from this book.

Review:

THE book for all SQL Server T-SQL developers - a MUST have book - Review of Database Administrator SQLAuthority.com

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes (Sams Teach Yourself)
by Ben Forta

Short Review:
If T-SQL (Transact-Structured Query Language) is foreign tongue to you, after reading this book, you will speak T-SQL. This book is SQL Server version of best-selling book Sams Teach Yourself SQL in 10 Minutes. This book teaches what a SQL developer must know methodically, systematically, and exactly. Anybody who are new to SQL Server and wants to learn most of T-SQL which can be implemented in short time in their application - BUY this book immediately.

Detail Review:
This is the one book I was awaiting eagerly. I claim that I am very experience Database Administrator and Database Developer, however, I have learned something new from this book of acclaimed author Ben Forta.

This book is focused on T-SQL only. It begins with simple data retrieval and continues to develop complex topics. It addresses various topics that are enough to get some work done with SQL Server as well explains concept in depth. SQL Server 2005 is a very complex, feature rich product. This book does a wonderful job of explaining the various features with out going to too many details that majority of the users will not need anyway. This book covers all of the important aspects of SQL Server 2005 without clouding the information with tons of examples that are not for every user.

Author has divided the book into short comprehensible chapters along with to the point examples and explanations of the concepts. If you see "Table of Contents" of this book, you will find that this book covers many areas. I will talk about few of my personal favorite chapters of this book here to demonstrate, what this book does is best at.

Chapter 5: Sorting Retrieved Data
If you want to sort in descending order on multiple columns, be sure each column has its own DESC keyword.
When you are sorting textual data, is A the same as a? And does a come before B or after Z? In dictionary sort order, A is treated the same as a. If you need an alternate sort order, you can not accomplish it with a simple ORDER BY clause.
It is not required, and it is perfectly legal to sort data by a column that is not retrieved.

Chapter 10: Using Data Manipulation Functions
It is far safer to always use a full four digit year so that SQL Server does not have to make any assumptions for you.
When comparing dates, always use DATEDIFF(), and do not make assumptions about how dates are stored.

Chapter 15: Creating Advanced Joins
It is worth noting that table aliases are only used during query execution. Unlike column aliases, table aliases are never returned to the client.
Self joins are often used to replace statements using subqueries that retrieve data from the same table as the outer statement. Sometimes these joins execute far more quickly than do subqueries.

Chapter 22: Programming with T-SQL
This is my most favorite chapter. Experienced programmers will find this chapter most interesting.

To discover the secret of SQL, this is the book you need to read, extremely well written, easy to follow and most importantly to the point. This has got to be the smallest SQL book in existence with highest amount of quality content. A really MUST have book.

Rating: 5 stars

In Summary, A MUST read.

Pinal Dave
Principal Database Administrator
(http://www.SQLAuthority.com)

http://rapidshare.com/files/57637666/Sams_.Teach.Yourself.Microsoft.SQL.Server._2007_.BBL._0672328674_.pdf.7z

http://rapidshare.com/files/57824009/Teach.Yourself.Msft.SQL.Server.T-SQL.in.10.Minutes.Aug.2007.rar