Внимание!!! AdBlock блокирует показ некоторых скриншотов. Пожалуйста, все вопросы к разработчкикам
Автор
Сообщение
Galfimbul
Microsoft SQL Server 2008 T-SQL Fundamentals
Год: October 22, 2008 Автор: Itzik Ben-Gan Издательство: Microsoft Press ISBN: 0735626014 Язык: Английский Формат: CHM Качество: Изначально компьютерное (eBook) Количество страниц: 688
Описание: This essential reference is designed for database developers and administrators who need to write queries and develop code using Transact-SQL (T-SQL), the Microsoft implementation of the standard SQL language. Guided by SQL Server guru Itzik Ben-Gan, you'll walk through the steps for writing queries, including retrieving and modifying data, with an overview of programmable objects supported by SQL Server 2008. Rather than focusing just on the syntactical elements of T-SQL, however, this book explains the logic behind the language - helping you develop a true, core understanding of the elements and how to use them. You will learn to think in terms of sets, and follow real-world best practices for T-SQL programming. To complement the learning experience, the book provides exercises to practice and apply what you've learned. And you'll examine recommended solutions to compare with your own work. The entire book's code samples will be available for download from the companion Web site.
Chapter 1, "Background to T-SQL Querying and Programming," provides a theoretical background about SQL, set theory, and predicate logic; examines the relational model and more; describes SQL Server's architecture; and explains how to create tables and define data integrity.
Chapter 2, "Single-Table Queries," covers various aspects of querying a single table using the SELECT statement.
Chapter 3, "Joins," covers querying multiple tables using joins, including cross joins, inner joins, and outer joins.
Chapter 4, "Subqueries," covers queries within queries, otherwise known as subqueries.
Chapter 5, "Table Expressions," covers derived tables, CTEs, views, inline table-valued functions, and the APPLY operator.
Chapter 6, "Set Operations," covers the set operations UNION, INTERSECT, and EXCEPT.
Chapter 7, "Pivot, Unpivot, and Grouping Sets," covers data-rotation techniques and working with grouping sets.
Chapter 9, "Transactions and Concurrency," covers concurrency of user connections that work with the same data simultaneously; it covers concepts including transactions, locks, blocking, isolation levels, and deadlocks.
Chapter 10, "Programmable Objects," provides an overview to the T-SQL programming capabilities in SQL Server.
Внимание! AdBlock блокирует показ скриншотов, все вопросы к разработчикам )))
