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

By Lowell Mauer

Book Overview

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. This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0672319675
• ISBN13: 9780672319679
• Release Date: March 2001
• Publisher: Sams Publishing
• Length: 620 Pages
• Weight: 2.35 lbs.
• Dimensions: 1.4" x 7.3" x 8.6"

Customer Reviews

GREAT for the layperson! :-)

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!

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. I read the book in about 10 days.

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.

A must for beginners

I had a previous background on Oracle, and was about to head a C/S project based o MSSQL Server. Firt I tried "SQL Server 6.5 Programming - Unleashed" (I had SQL background, didn't I?). Ugh! I found T-SQL was far depart from Oracle (mainly PL/SQL). So I looked for something syntax oriented. "Teachyourself..." was the final answer to shed light on MSSQL implementation of SQL scripting (IMHO, the worst implementation I...

Excellent!

Unlike other MS-SQLServer books that mix DB Adminstrative chores with client application programming, this is a very unique book that focuses specifically on Transact-SQL that every DB application programmer working with MS-SQLServer should know. Armed with this effective book, my colleaque was able to bring herself up to speed within a mere 5-day 3-hr-7-chapter-per-day coaching and tutorial sessions. The material and presentation...