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.
- 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.