Most T-SQL developers recognize the value of window functions for data analysis calculation. But window functions can do far more than that, and optimizations in recent versions of SQL Server have made them more powerful than ever.
Explore similar courses.
Starting with the background to T-SQL querying and programming, including: logical query processing, book-querying constructs (single table queries, joins, subqueries, table expressions, set operators, data analysis), data modifications, temporal tables, transactions and concurrency, SQL Graph (completely new to this edition), as well as programmatic T-SQL constructs
Updating both Inside Microsoft SQL Server 2008 T-SQL Querying (Microsoft Press, 2009) and parts of Inside Microsoft SQL Server 2008 T-SQL Programming (Microsoft Press, 2009), the book gives database developers and administrators a detailed look at the internal architecture of T-SQL and a comprehensive programming reference. Tackle the toughest set-based querying and query tuning problems--guided by an author team with in-depth, inside knowledge of T-SQL.
A former Google data scientist teaches you SQL - from the basics to advanced mastery of window functions
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.
Get the latest on new courses, sales, learning tips, site updates and community events.