Sams Teach Yourself Transact-SQL in 21 Days Book

Editorial ReviewsProduct DescriptionSams 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 PublisherBased 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. See all Editorial Reviews