Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes by Ben Forta, Sams Publishing

by Ben Forta

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–in 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.

Genres: Reference, Programming

Unknown Binding

First published August 2, 2007

About the author

Ben Forta is an author and Senior Technical Evangelist for Adobe Systems, particularly ColdFusion and Flex, and the owner of EmTek Systems. He previously worked in a similar capacity for Macromedia and Allaire Corporation, the two previous owners of ColdFusion.

In addition to writing numerous technical books on ColdFusion, SQL, and Regular Expressions, Forta co-authored Adobe's official ColdFusion training materials and certification tests and lectures on application development around the world. Many of his books have been translated into over a dozen languages worldwide.

Before working for Allaire, he founded the website Car.com, which was later purchased by Auto-By-Tel. Born in London, England, Forta lives in Oak Park, Michigan with his wife and their children.

- from Wikipedia

Reviews

[Zaina · Rating 5 out of 5]

I took my time with this one. I still need to go back and reread pages or chapters but that’s due to lack of use of my newly gained learnings.
It’s a good intro and handy reference. Well organized. Not meant to be comprehensive so I’m giving it 5 stars because it it as advertised.

[Peter Kampjes · Rating 4 out of 5]

A really good introduction to T-SQL, although somewhat brief on some points, it gives you enough to get you started, and the lessons are simple enough to let you extract what you need to learn quickly.