Sams Teach Yourself Transact-SQL in 21 Days (2nd Edition) [Paperback]

Lowell Mauer (Author)

Book Description

ISBN-10: 0672319675 | ISBN-13: 978-0672319679 | Publication Date: March 18, 2001 | Edition: 2

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.

Editorial Reviews

From the Publisher

Based on the best-selling Teach Yourself series, this comprehensive book provides readers with the techniques they need to not only write flexible and effective applications that produce efficient results but also decrease the performance demands on the server. In no time, users will master methods that will improve productivity and maximize performance. - Explores topics such as coding standards, the CASE function, bitmaps, and more

- Q&A sections, exercises, and week-at-a glance previews make learning a breeze

- A support site for the book will be set up on the Sams Web site-providing access to a SQL Server, HTML interface that accepts full SQL queries, hands-on learning of Transact-SQL for those that do not have access to a SQL Server, and more --This text refers to an alternate Paperback edition.

From the Back Cover

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.

See all Editorial Reviews

Product Details

• Paperback: 640 pages
• Publisher: Sams; 2 edition (March 18, 2001)
• Language: English
• ISBN-10: 0672319675
• ISBN-13: 978-0672319679
• Product Dimensions: 8.6 x 7.3 x 1.4 inches
• Shipping Weight: 2.4 pounds (View shipping rates and policies)
• Average Customer Review: 3.2 out of 5 stars  See all reviews (32 customer reviews)
• Amazon Best Sellers Rank: #427,568 in Books (See Top 100 in Books)
  • #72 in Books > Computers & Technology > Databases > Relational Databases

Customer Reviews

Most Helpful Customer Reviews

10 of 10 people found the following review helpful:

3.0 out of 5 stars decent place to start, but....., February 11, 1999

By A Customer

This review is from: Teach Yourself Transact-SQL in 21 Days (Teach Yourself Series) (Paperback)

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? I am still miffed by that. If you are serious about SQL, do not use this book as a "reference"; rather, use it as an introduction. And it is an excellent INTRODUCTION, suited to the complete novice. But after you graduate from this book, go buy "Inside Microsoft SQL Server 6.5" by Ron Soukup - which is the best book I have read on the subject (if you're using MS SQL server, that is..)

All in all, "Teach yourself tsql" is worth the money - but as you learn more you will say to yourself, "Why wasn't that in the book?"

8 of 8 people found the following review helpful:

4.0 out of 5 stars Challenging and a Wealth of Information, April 24, 2004

By 

Phil Moran (Jewett City, CT) - See all my reviews

This review is from: Sams Teach Yourself Transact-SQL in 21 Days (2nd Edition) (Paperback)

I knew only how to pass a SELECT * statement before obtaining this book. I have since taken a job writing code from what I learned from this book. Not only is their a wealth of information, but the exercises challenge the reader to think "outside the box" and create code using the information learned in the chapter. I would have given this book 5 stars but sections like views were a bit weak. After reading this book definitely pick up The Guru's Guide to Transact SQL.

7 of 7 people found the following review helpful:

5.0 out of 5 stars GREAT for the layperson! :-), January 25, 2002

By 

William L. Coppernoll (Indianapolis, IN United States) - See all my reviews
(REAL NAME)   

This review is from: Sams Teach Yourself Transact-SQL in 21 Days (2nd Edition) (Paperback)

As a relatively new database administrator with no SQL experience, this book was EXACTLY what I needed. It is written in an easy-to-read and easily comprehended style. It takes me everywhere I need to go with confidence that the code I now write will perform the necessary functions...and perform them efficiently and effectively. Thank you, Sam!