Itzik Ben-Gan es cofundador de SolidQ, una empresa de educación técnica, y MVP de Microsoft SQL Server. Reconocido a nivel mundial por sus eventos de formación y escritos, se especializa en consultas, optimización y programación T-SQL. Su experiencia se centra en técnicas avanzadas para lograr el máximo rendimiento de las bases de datos. Los cursos y libros de Ben-Gan son muy valorados por su profundidad y aplicación práctica.
Students will master the fundamentals of Transact-SQL--and develop their own code for querying and modifying data in Microsoft SQL Server 2016. Led by a SQL Server expert, readers learn the concepts behind T-SQL querying and programming, and then apply their knowledge with exercises in each chapter. Once students understand the logic behind T-SQL, they'll quickly learn how to write effective code.
Tackle the toughest set-based querying and query tuning problems—guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals—and gain practical approaches and advanced techniques to optimize your code’s performance.Discover how to:- Move from procedural programming to the language of sets and logic- Optimize query tuning with a top-down methodology- Assess algorithmic complexity to predict performance- Compare data-aggregation techniques, including new grouping sets- Manage data modification—insert, delete, update, merge—for performance- Write more efficient queries against partitioned tables- Work with graphs, trees, hierarchies, and recursive queries- Plus—Use pure-logic puzzles to sharpen your problem-solving skills
Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of this programming language—solving complex problems with real-world solutions. Discover how All the book’s code samples will be available for download from the companion Web site.
Provides information on the architecture of the T-SQL programming language.
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.
Led by a T-SQL expert, readers learn how to perform calculations against sets of rows in a database--in a flexible, clear, and efficient manner and find practical uses for various T-SQL window functions for common business tasks.
Take a detailed look at the internal architecture of T-SQL--and unveil the power of set-based querying--with comprehensive reference and advice from the experts. Database developers and administrators get best practices, sample databases, and code to master the intricacies of the programming language--solving complex problems with real-world solutions. Discover how to: Understand logical and physical query processing Apply a methodology to optimize query tuning Solve relational division problems Use CTEs and ranking functions to simplify and optimize solutions Aggregate data with various techniques, including tiebreakers, pivoting, histograms, and grouping factors Use the TOP option in a query to modify data Query specialized data structures with recursive logic, materialized path, or nested sets solutions PLUS--Improve your logic and get to the heart of querying problems with logic puzzles Get code and database samples on the Web
Accompanying CD includes practice tests, an e-version of the book, and source code and sample data.
Эта книга - подробное руководство по применению оконных функций в SQL Server, а также в стандарте SQL, в том числе по использованию элементов, которые пока не реализованы в SQL Server. Здесь описаны принципы работы с окнами в SQL Server и работа различных оконных функций (ранжирования, аналитики, агрегирования и смещения), а также функции упорядоченных наборов. Подробно освещен вопрос оптимизации оконных функций в SQL Server 2012 для достижения максимальной производительности. Отдельная глава посвящена тщательному анализу примеров практического применения оконных функций. Книга состоит из пяти глав; адресована разработчикам для SQL Server и администраторам баз данных, а также всем, кому необходимо создавать запросы и разрабатывать код с использованием T-SQL. Подробнее: http://www.labirint.ru/books/372984/
