Teach Yourself Transact-SQL in 21 Days

Book 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. /p>

Reviews From AMAZON.COM

Challenging and a Wealth of Information

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.

Excellent tutorial and reference

As a programmer with over 10 years experience I have found this book to be comprehensive and concise. There are many useful examples many of which have helped me solve problems on the job.

Lowell Mauer explains things very well.

This is my main reference book it has paid for itself many times over. I highly recommend it.