{"title":"Books by Itzik Ben-Gan","description":null,"products":[{"product_id":"9780138102104","title":"T-SQL Fundamentals","description":"\u003cp\u003e\u003cstrong\u003eQuery and modify data effectively with the latest T-SQL features\u003c\/strong\u003e\u003c\/p\u003e \u003cp\u003eMaster Transact-SQL's fundamentals, and write correct, robust code for querying and modifying data with modern Microsoft data technologies, including SQL Server 2022, Azure SQL Database, and Azure SQL Managed Instance. Long-time Microsoft Data Platform MVP Itzik Ben-Gan explains key T-SQL concepts, helping you apply your knowledge with hands-on exercises. Ben-Gan first introduces T-SQL's theory and underlying logic, illuminating it as both a language and a way of thinking. Next, he walks through core topics, including logical query processing, single table queries, joins, subqueries, table expressions, set operators, data analysis, data modifications, temporal tables, and transactions and concurrency. Building on this foundation, you'll enhance your coding capabilities, from programmatic constructs to the powerful new SQL Graph. Throughout, Ben-Gan presents reusable T-SQL sample code that works in cloud, on-premises, and hybrid environments.\u003c\/p\u003e \u003cp\u003e\u003cstrong\u003eMicrosoft Data Platform MVP Itzik Ben-Gan helps you:\u003c\/strong\u003e\u003c\/p\u003e \u003cul\u003e  \u003cli\u003eUnderstand why T-SQL works as it does, so you can write better code\u003c\/li\u003e  \u003cli\u003eReview relational theory elements and modern SQL Server architecture\u003c\/li\u003e  \u003cli\u003eCreate tables and defi ne data integrity\u003c\/li\u003e  \u003cli\u003eBuild single-table SELECT queries, multiple-table joins, and subqueries\u003c\/li\u003e  \u003cli\u003eUtilize derived tables, Common Table Expressions, views, inline table-valued functions, and APPLY\u003c\/li\u003e  \u003cli\u003eMake the most of UNION, INTERSECT, and EXCEPT set operators\u003c\/li\u003e  \u003cli\u003ePerform data analysis with window functions, pivoting, grouping sets, and time series\u003c\/li\u003e  \u003cli\u003eInsert, update, delete, and merge data\u003c\/li\u003e  \u003cli\u003eGet started with system-versioned temporal tables\u003c\/li\u003e  \u003cli\u003eUnderstand and apply transactions and concurrency, including concurrent user connections, locks, blocking, isolation levels, and more\u003c\/li\u003e  \u003cli\u003eUse SQL Graph to model, create, modify, and query graph-based data\u003c\/li\u003e  \u003cli\u003eExplore SQL Server programmable objects and programming capabilities\u003c\/li\u003e  \u003cli\u003eSet up your environment, install sample databases, and fi nd even more help\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003cstrong\u003eFor IT Professionals and Consultants\u003c\/strong\u003e\u003c\/p\u003e \u003cul\u003e  \u003cli\u003eFor T-SQL developers, DBAs, BI practitioners, data scientists, report writers, analysts, architects, and SQL Server power users\u003c\/li\u003e  \u003cli\u003eFor anyone else who needs to write queries or develop T-SQL code for SQL Server, Azure SQL Database, or Azure SQL Managed Instance\u003c\/li\u003e \u003c\/ul\u003e","brand":"Gardners","offers":[{"title":"Default Title","offer_id":56223945392501,"sku":"9780138102104","price":37.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0612\/7193\/3106\/files\/9780138102104_a351cefc-a68e-469e-a856-50303743b566.jpg?v=1786011692"},{"product_id":"9781509304332","title":"Exam Ref 70-761 Querying Data with Transact-SQL","description":"\u003cp\u003ePrepare 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 focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level.\u003c\/p\u003e\u003cp\u003eFocus on the expertise measured by these objectives:\u003c\/p\u003e\u003cp\u003eFilter, sort, join, aggregate, and modify data\u003c\/p\u003e\u003cp\u003eUse subqueries, table expressions, grouping sets, and pivoting\u003c\/p\u003e\u003cp\u003eQuery temporal and non-relational data, and output XML or JSON\u003c\/p\u003e\u003cp\u003eCreate views, user-defined functions, and stored procedures\u003c\/p\u003e\u003cp\u003eImplement error handling, transactions, data types, and nulls\u003c\/p\u003e\u003cp\u003eThis Microsoft Exam Ref:\u003c\/p\u003e\u003cp\u003eOrganizes its coverage by exam objectives\u003c\/p\u003e\u003cp\u003eFeatures strategic, what-if scenarios to challenge you\u003c\/p\u003e\u003cp\u003eAssumes you have experience working with SQL Server as a database administrator, system engineer, or developer\u003c\/p\u003e\u003cp\u003eIncludes downloadable sample database and code for SQL Server 2016 SP1 (or later) and Azure SQL Database\u003c\/p\u003e\u003cp\u003eQuerying Data with Transact-SQL\u003c\/p\u003e\u003cp\u003eAbout the Exam\u003c\/p\u003e\u003cp\u003eExam 70-761 focuses on the skills and knowledge necessary to manage and query data and to program databases\u003c\/p\u003e\u003cp\u003ewith Transact-SQL in SQL Server 2016.\u003c\/p\u003e\u003cp\u003eAbout Microsoft Certification\u003c\/p\u003e\u003cp\u003ePassing this exam earns you credit toward a Microsoft Certified Solutions Associate (MCSA) certification that demonstrates your mastery of essential skills for building and implementing on-premises and cloud-based databases across organizations. Exam 70-762 (Developing SQL Databases) is also required for MCSA: SQL 2016 Database Development certification.\u003c\/p\u003e\u003cp\u003eSee full details at: microsoft.com\/learning\u003c\/p\u003e","brand":"Gardners","offers":[{"title":"Default Title","offer_id":56301403570549,"sku":"9781509304332","price":29.49,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0612\/7193\/3106\/files\/9781509304332_ee55c3a1-6104-430a-a9b7-08b70414267b.jpg?v=1786022257"},{"product_id":"9780135861448","title":"T-SQL Window Functions","description":"\u003cp\u003e\u003cb\u003eUse window functions to write simpler, better, more efficient T-SQL queries \u003c\/b\u003e\u003c\/p\u003e\u003cp\u003eMost T-SQL developers recognize the value of window functions for data analysis calculations. But they can do far more, and recent optimizations make them even more powerful. In T-SQL Window Functions, renowned T-SQL expert Itzik Ben-Gan introduces breakthrough techniques for using them to handle many common T-SQL querying tasks with unprecedented elegance and power. Using extensive code examples, he guides you through window aggregate, ranking, distribution, offset, and ordered set functions. You’ll find a detailed section on optimization, plus an extensive collection of business solutions — including novel techniques available in no other book.\u003c\/p\u003e\u003cp\u003e\u003cb\u003eMicrosoft MVP Itzik Ben-Gan shows how to: \u003c\/b\u003e\u003c\/p\u003e\u003cp\u003eUse window functions to improve queries you previously built with predicates\u003c\/p\u003e\u003cp\u003eMaster essential SQL windowing concepts, and efficiently design window functions\u003c\/p\u003e\u003cp\u003eEffectively utilize partitioning, ordering, and framing\u003c\/p\u003e\u003cp\u003eGain practical in-depth insight into window aggregate, ranking, offset, and statistical functions\u003c\/p\u003e\u003cp\u003eUnderstand how the SQL standard supports ordered set functions, and find working solutions for functions not yet available in the language\u003c\/p\u003e\u003cp\u003ePreview advanced Row Pattern Recognition (RPR) data analysis techniques\u003c\/p\u003e\u003cp\u003eOptimize window functions in SQL Server and Azure SQL Database, making the most of indexing, parallelism, and more\u003c\/p\u003e\u003cp\u003eDiscover a full library of window function solutions for common business problems\u003c\/p\u003e\u003cp\u003e\u003cb\u003eAbout This Book \u003c\/b\u003e\u003c\/p\u003e\u003cp\u003eFor developers, DBAs, data analysts, data scientists, BI professionals, and power users familiar with T-SQL queries\u003c\/p\u003e\u003cp\u003eAddresses any edition of the SQL Server 2019 database engine or later, as well as Azure SQL Database\u003c\/p\u003e\u003cp\u003e\u003cb\u003eGet all code samples at: \u003c\/b\u003e\u003c\/p\u003e\u003cp\u003eMicrosoftPressStore.com\/TSQLWindowFunctions\/downloads\u003c\/p\u003e","brand":"Gardners","offers":[{"title":"Default Title","offer_id":56311561060725,"sku":"9780135861448","price":29.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0612\/7193\/3106\/files\/9780135861448_f609c8fd-336d-4b65-82f7-2d5f661bcde0.jpg?v=1786011544"}],"url":"https:\/\/backstory.london\/collections\/author-itzik-ben-gan.oembed","provider":"Backstory","version":"1.0","type":"link"}