Product Description

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.

Product Details

• Amazon Sales Rank: #30276 in Books
• Published on: 2007-08-09
• Original language: English
• Number of items: 1
• Binding: Paperback
• 368 pages

From the Back Cover

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.

About the Author

Ben Forta is Adobe Systems’s Senior Technical Evangelist and has over 20 years of experience in the computer industry in product development, support, training, and product marketing. Ben is the author of the bestselling Sams Teach Yourself SQL in 10 Minutes (now in its third edition, and translated into more than a dozen languages), MySQL Crash Course, ColdFusion Web Application Construction Kit and Advanced ColdFusion Development (both published by Que), Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on Flash, Java, WAP, Windows 2000, and other subjects. He has extensive experience in database design and development, has implemented databases for several highly successful commercial software programs, and is a frequent lecturer and columnist on Internet and database technologies. Born in London, England, and educated in London, New York, and Los Angeles, Ben now lives in Oak Park, Michigan with his wife Marcy and their seven children. Ben welcomes your email at ben@forta.com, and invites you to visit his website at http://www.forta.com/.

Customer Reviews

Worth reading
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes
A great little book. It has Chapters on some of the new Xml and Full text Searching stuff that is good. It also has the standard stuff. It is products specific as the name suggests.
It covers what can be quite a heavy subject in a very readable way.

So it's simple.

SELECT [Book] WHERE [BookName] LIKE '%SQL Server T-SQL' AND Author = 'Ben Forta'

Great Read
If you have been dropped in at the deep end and need to learn T-SQL commands quick then this is the perfect book. Each chapter is 10 minutes long and is written in a very clear manner so you'll be learning in no time. Great book for those new to the subject or those who want to expand their knowledge.

Quick and uncomplicated reference
Exactly what I wanted - a short reference I can flick through and pick up the basics from to get me started on things like stored procedures and triggers. Nothing too involved or complicated. Although the description states, "Includes SQL Server 2005" like it was something new, I was able to use this basic grounding on SQL Server 2008 as well.