{"product_id":"exam-ref-70-761-querying-data-with-transact-sql","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\u003e \u003c\/p\u003e \u003cp\u003eFocus on the expertise measured by these objectives:\u003c\/p\u003e \u003cp\u003e• Filter, sort, join, aggregate, and modify data\u003c\/p\u003e \u003cp\u003e• Use subqueries, table expressions, grouping sets, and pivoting\u003c\/p\u003e \u003cp\u003e• Query temporal and non-relational data, and output XML or JSON\u003c\/p\u003e \u003cp\u003e• Create views, user-defined functions, and stored procedures\u003c\/p\u003e \u003cp\u003e• Implement error handling, transactions, data types, and nulls\u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003eThis Microsoft Exam Ref:\u003c\/p\u003e \u003cp\u003e• Organizes its coverage by exam objectives\u003c\/p\u003e \u003cp\u003e• Features strategic, what-if scenarios to challenge you\u003c\/p\u003e \u003cp\u003e• Assumes you have experience working with SQL Server as a database administrator, system engineer, or developer\u003c\/p\u003e \u003cp\u003e• Includes downloadable sample database and code for SQL Server 2016 SP1 (or later) and Azure SQL Database\u003c\/p\u003e","brand":"Pearson Education","offers":[{"title":"Default Title","offer_id":46286597128430,"sku":"9781509304332","price":48.85,"currency_code":"AUD","in_stock":true}],"url":"https:\/\/bookland.com.au\/products\/exam-ref-70-761-querying-data-with-transact-sql","provider":"Book Land AU","version":"1.0","type":"link"}