Prepare for Microsoft Exam 70-761-and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, Exam Ref focu…
Effectively query and modify data using Transact-SQL Master T-SQL fundamentals and write robust code for Microsoft SQL Server and Azure SQL Database. Itzik Ben-Gan explains key T-SQL concepts and helps you apply your knowledge with hands-on exercise…
This book explores the powerful capabilities of T-SQL and helps you to exploit them to the max. The book tackles advanced areas in T-SQL such as joins, subqueries, stores procedures, triggers, user-defined functions, indexed views, cascading actions…
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. In T-SQL Window F…
T-SQL insiders help you tackle your toughest queries and query-tuning problems Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL's internal architecture and offer…
Direct from Microsoft, this bundle contains the following two study guides at a $15 discount:Exam Ref 70-761 Querying Data with Transact-SQL, 9781509304332,offers professional-level preparation that helps candidates maximize their exam performance a…
Apply powerful window functions in T-SQL--and increase the performance and speed of your queries Optimize your queries--and obtain simple and elegant solutions to a variety of problems--using window functions in Transact-SQL. Led by T-SQL expert It…
