Sams Teach Yourself Transact-SQL in 21 Days

by David Solomon (Author), Ben Mcewan (Author)

• Used

  Paperback
  1997

  $6.20

  Sams Teach Yourself Transact-SQL in 21 Days provides you with the skills you need to write flexible and effective applications. The techniques included in the book allow you to maximize the performance of SQL Server by optimizing your new or existing queries. The syntax and examples can be used with either Microsoft or Sybase SQL Server. Whether you are a programmer or a database administrator, Sams Teach Yourself Transact-SQL in 21 Days shows you how to write effective Transact-SQL queries that provide efficient results and decrease the performance demands on your server.

• Used

  Paperback
  2001

  $3.47

  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.