Sams Teach Yourself Transact-SQL in 21 Days

ebook Sams Teach Yourself

By Lowell Mauer

cover image of Sams Teach Yourself Transact-SQL in 21 Days

Sign up to save your library

With an OverDrive account, you can save your favorite libraries for at-a-glance information about availability. Find out more about OverDrive accounts.

   Not today

Find this title in Libby, the library reading app by OverDrive.

Download Libby on the App Store Download Libby on Google Play

Search for a digital library with this title

Title found at these libraries:

Loading...

Sams Teach Yourself Transact-SQL in 21 Days, Second Edition 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.
Sams Teach Yourself Transact-SQL in 21 Days