Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes |  | Author: Ben Forta
Publisher: Sams
List Price: $19.99
Buy New: $11.52
as of 11/22/2009 04:56 CST details
You Save: $8.47 (42%)
New (27) Used (15) from $10.00
Seller: pbshop
Rating:  6 reviews
Sales Rank: 151572
Media: Paperback
Edition: 1
Pages: 368
Number Of Items: 1
Shipping Weight (lbs): 0.9
Dimensions (in): 8.1 x 5.4 x 0.9
ISBN: 0672328674
Dewey Decimal Number: 005.2768
EAN: 9780672328671
ASIN: 0672328674
Publication Date: August 12, 2007
Availability: Usually ships in 1-2 business days
| |
| Also Available In:
|
| Similar Items:
| |
| Editorial Reviews:
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.
|
| Customer Reviews:
Showing reviews 1-5 of 6
 Great book March 13, 2009
Samuel J. Sharper (Silver Spring, MD US)
0 out of 1 found this review helpful
I'm new to T-SQL and this book has been a great help in getting me to up and running with some of the basic T-SQL statements. In addition to this book, I have a MS-Press Designing & Implementing SQL Server 2005. The Sam's book got me up to par to handle the more difficult design and implementation book.
 The Guy's A Spy January 24, 2009
Bruce Kirkpatrick (the worktable on my boat)
5 out of 7 found this review helpful
There is a quick way to tell when a writer really isn't up to snuff on SQL Server. They will use ANSI 89 syntax. That's exactly what this writer does throughout the book. SQL Server has used ANSI 92 and later syntax forever. SQL Server can deal with the clunkier '89 syntax for backwards compatability, but anyone who teaches SQL Server with it should be avoided. One reason the older syntax is so prevalent in books is that Oracle relied on it until quite recently. Those writers coming from the Oracle world are less likely to use the more up to date, intuitive and flexible syntax native to SQL Server. Here is a quick and easy way for anyone to tell if the writer knows their SQL Server stuff. Search the book for table join examples. If the syntax looks like: ... FROM Table1, Table2 WHERE This = That ... BAD NEWS. If the syntax looks like: ... FROM Table1 INNER JOIN Table2 ON This = That ... GOOD NEWS. Guess what you will find in this book.
Bruce Kirkpatrick
MCSA, MCSE, MCSD, MCDBA, MCT, etc, etc
Highly Recommended July 20, 2008
Lawrence D. Erickson (San Diego, CA USA)
0 out of 1 found this review helpful
Read this book if you are new to Microsoft SQL Server. This book is well written and gets right to the main points of T-SQL. I especially liked the later chapters on Views, Stored Procedures, XML, and programming with T-SQL. This is one of my top 10 computer books and I always keep this book close at hand for reference. Use another book if you are looking for the hard core nitty gritty details of SQL Server. I hope Ben Forta writes a "Sams Teach Yourself" book on for other SQL server features like SQL Server Integration Services or SQL Server Reporting Services.
The perfect companion for learning T-SQL June 19, 2008
Daniel P. Kirk
3 out of 4 found this review helpful
This is a great book for any newbie to T-SQL. There are lots of examples and each of those is accompanied by an explanation, without assuming that you already knew something (a pet peeve of mine for many how-to books). The chapters are broken up well and each leads into the next seamlessly. It is not the ultimate reference guide, but if you are looking to learn and understand how T-SQL works, then this is the book for you.
Excellent book for learning T-SQL November 28, 2007
K. Forward
13 out of 14 found this review helpful
I am brand new to SQL Server and have been reading a handful of large SQL Server for beginners type books, but I kept getting hung up on all the T-SQL commands. No book seemed to explain it clearly, or they'd suddenly introduce a series of mind-numbing code without explanation - assuming you knew it. Fortunately for me, I stumbled on this gem of a book. It is well laid out, concise, and there is no filler. It starts with the absolute basics and works on up through to more complex T-SQL scripts (stored procedures, cursors, triggers etc.), but by the time you get there - you're more confident with this stuff. I'd highly recommend this book if you want to learn T-SQL.
Showing reviews 1-5 of 6
|
|
|
|
