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

Sams Teach Yourself Transact-SQL in 21 Days (2nd Edition)
Автор
 
Год
 
Страниц
 
640
ISBN
 
0672319675
Издатель
 
Sams
Категория
 
SQL

Содержание:

В мире камня. Книга юного геолога

Описание:

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.

Похожие книги

Sams Teach Yourself Microsoft SQL Server 7 in 21 DaysSams Teach Yourself Microsoft SQL Server 7 in 21 Days
Автор: Richard Waymire, Rick Sawtell
Год: 1998
How to Teach SpeakingHow to Teach Speaking
Автор: Scott Thornbury
Год: 2009
More Chemistry Basics - Stop faking It! PB169X9More Chemistry Basics - Stop faking It! PB169X9
Автор: William C. Robertson, Michael S. Kralik, Ann Culter
Год: 2010