or
Sign in to turn on 1-Click ordering.
or
Amazon Prime free trial required. Sign up when you check out. Learn more
More Buying Choices
Have one to sell? Sell yours here
or
Get a £5.55 Amazon.co.uk Gift Card
Sams Teach Yourself Transact-SQL in 21 Days
 
See larger image 
Share your own customer images
Publisher: learn how customers can search inside this book.
Tell the Publisher!
I’d like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Sams Teach Yourself Transact-SQL in 21 Days [Paperback]

Lowell Mauer (Author)
4.7 out of 5 stars  See all reviews (18 customer reviews)
RRP: £28.99
Price: £24.64 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £4.35 (15%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.
Only 2 left in stock--order soon (more on the way).
Want guaranteed delivery by Thursday, May 31? Choose Express delivery at checkout. See Details

Formats

 Amazon Price New from Used from
Paperback £24.64   -- --
Trade In this Item for up to £5.55
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in Sams Teach Yourself Transact-SQL in 21 Days for an Amazon.co.uk gift card of up to £5.55, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.

Frequently Bought Together

Sams Teach Yourself Transact-SQL in 21 Days + Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes + Microsoft SQL Server 2008 For Dummies
Price For All Three: £45.97

Show availability and delivery details

Buy the selected items together

Product details

  • Paperback: 640 pages
  • Publisher: Sams; 2 edition (8 Mar 2001)
  • Language English
  • ISBN-10: 0672319675
  • ISBN-13: 978-0672319679
  • Product Dimensions: 21.7 x 18.6 x 3.7 cm
  • Average Customer Review: 4.7 out of 5 stars  See all reviews (18 customer reviews)
  • Amazon Bestsellers Rank: 141,886 in Books (See Top 100 in Books)

    •  Would you like to update product info or give feedback on images?

  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.
David Solomon
David Solomon
Bennett Wm McEwan
Bennett Wm McEwan
Lowell Mauer
Lowell Mauer

Product Description

Product Description

Sams Teach Yourself Transact-SQL in 21 Days, 2E will teach programmers how to develop Transact-SQL queries. There will be a focus on providing methods for improving productivity without a reducing performance. Specifically, the reader will:Learn Transact-SQL syntax Learn how to add, delete, and modifying data using Transact-SQL Understand coding standards Review variations from ANSI-standard SQL Be presented with basic server operations. Recognize performance issues with queries. This book will also include:Constructs such as CUBE, ROLLUP, CASE, and JOIN. Techniques to solve complex problems How the server uses indexes Methods to write (correctly) stored procedures and triggers. Templates of procedures and triggers (reference) Advanced Topics such as: Outer and self joins Temporary tables Sub-queries.

From the Author

This book is for programmers who are new to SQL.
Most SQL books are aimed at administrators. _TY T-SQL_ is for programmers who need some SQL background, or people completely new to programming. (By the way, the interview listed below is NOT my coauthor.) --This text refers to an out of print or unavailable edition of this title.
See all Product Description

Suggested Tags from Similar Products

 (What's this?)
Be the first one to add a relevant tag (keyword that's strongly related to this product)
 
(4)
(2)
(2)
(2)
(1)
(1)
(1)
(1)
(1)
(1)

Your tags: Add your first tag
 
See most popular tags

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

What Other Items Do Customers Buy After Viewing This Item?

› Explore similar items

Customer Reviews

Most Helpful Customer Reviews
6 of 6 people found the following review helpful
Format:Paperback
As with all of the Sams 21 Days volumes, this book provides an excellent tutorial that can be worked through in manageable chunks, as well as acting as a useful reference once the reader is up-to-speed with the subject matter. A good balance of topics is provided - with plenty of information on database design and the use of SQL Server, as well as the fundamentals of the SQL language.

Some minor inconsistencies appear within the text, that may irritate the perfectionists among us. In some cases, it is obvious that chapters or sections have been moved around within this second edition, whilst remnants of the first edition have been retained - for example Day 12 starts by "reminding" the reader of what has already been covered, even though none of the topics stated is even mentioned until Day 13. My biggest criticism, however, is the authors' failure to distinguish which aspects of the language are part of the standard ANSI SQL, and which are Microsoft extensions.

In summary, a good tutorial and useful reference, with a few irritations that could have been sorted by more careful proof reading!

Comment | 
Was this review helpful to you?
2 of 2 people found the following review helpful
By A Customer
Format:Paperback
The authors have quite clearly put every effort into producing a book that teaches.

Some authors seem to write books in such a way as to deter people from learning; they almost seem to delight in delivering a complex topic in an equally complex fashion. Thankfully McEwan and Soloman are different.

If you don't become a competent T-SQL programmer after reading this book you never will.

Comment | 
Was this review helpful to you?
2 of 2 people found the following review helpful
Brilliant! 15 Aug 1999
By A Customer
Format:Paperback
I bought this book to brush up on my SQL before I begin studying for the SQL Server 7 exam. It is excellently written - easy to understand and progressively teaches you T-SQL, functions, triggers, stored procedures, etc.

It also offers plenty of SQL Server tips and advice - making you aware of available system tables and performance issues. Basically this book is perfect for anyone who just wants to learn T-SQL, but is also suitable for anyone who is going to be building DBs on SQL Server, or is going to administer it.

I highly recommend it.

One thing to note: the book uses a SQL Server 6.5 sample database for the exercises and examples. It would be very beneficial if you have access to a server. The authors supply an on-line SQL Server if you haven't got access to your own server but I haven't tried it.

Comment | 
Was this review helpful to you?
Most Recent Customer Reviews
Excellent book!!! Good for beginner
Although I think this book is excellent, I am not rating it 5 stars because nothing is perfect. As a first timer in TSQL, I bought this book and have learned a lot from it. Read more
Published on 15 May 2007 by OceanBoy
Excellent no nonsense guide
I had tried tried several books and online sources to help me get to grips with TSQL, as I am currently studying for my MCP. Read more
Published on 25 May 2001 by stephen@srburrows.20m.com
An Excellent Introduction
I can't recommend this book highly enough for those starting out in T-SQL. I read this book as a novice database programmer and with a little patience was soon writing complex... Read more
Published on 26 Sep 2000 by niall.gorman@virgin.net
An excellently written book for all levels.
Having a short space of time to familiarise myself and get up to speed with Transact-SQL, I found this book to be ideal. Read more
Published on 5 July 2000
wish all books were like this
i work using SQL 7 server and wanted to know more about T-SQL cos of my interest in database programming . Read more
Published on 23 Oct 1999
Brilliant!
I want to start learning SQL Server 7, but I thought I should brush up on my SQL first (I haven't done any for several years). Read more
Published on 12 Aug 1999
Great for any level
I read it cover to cover, which I never do, especially for technical books. It started with the basics and finished with the fun stuff. It has greatly improved my productivity. Read more
Published on 24 May 1999
Excellent refrence for any one new to SQL server.
This is an excellent beginner level book for anyone new to SQL Server or anyone who has a need to learn Transact SQL. The examples where very helpful and easy to understand.
Published on 13 May 1999
Literally a step by step instruction of T-SQL.
If you are a neophyte and in need of help in T-Sql, this is the book for you.
Published on 5 May 1999
decent place to start, but.....
This book is good for the absolute beginner to TSQL (or SQL). But there are several glaring omissions in this book. How can you leave out ALTER TABLE in a SQL book? Read more
Published on 12 Feb 1999
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   

Listmania!

Create a Listmania! list

Look for similar items by category

Look for similar items by subject





















i.e., each product must be in subject 1 AND subject 2 AND ...

Feedback


Amazon.co.uk Privacy Statement Amazon.co.uk Delivery Information Amazon.co.uk Returns & Exchanges