{"product_id":"9781484239001","title":"SQL Server Advanced Data Types: JSON, XML, and Beyond","description":"\u003ch1\u003eSQL Server Advanced Data Types: JSON, XML, and Beyond\u003c\/h1\u003e \u003ch2\u003eCarter, Peter A.\u003c\/h2\u003e \u003cp\u003e\u003c\/p\u003e\u003cdiv\u003eDeliver advanced functionality faster and cheaper by exploiting SQL Server's ever-growing amount of built-in support for modern data formats. Learn about the growing support within SQL Server for operations and data transformations that have previously required third-party software and all the associated licensing and development costs. Benefit through a better understanding of what can be done inside the database engine with no additional costs or development time invested in outside software.\u003c\/div\u003e\u003cdiv\u003e\u003cbr\u003e\u003c\/div\u003e\u003cdiv\u003eWidely used types such as JSON and XML are well-supported by the database engine. The same is true of hierarchical data and even temporal data. Knowledge of these advanced types is crucial to unleashing the full power that's available from your organization's SQL Server database investment. \u003cbr\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003cbr\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ci\u003eSQL Server Advanced Data Types\u003c\/i\u003e explores each of the complex data types supplied within SQL Server. Common usage scenarios for eachcomplex data type are discussed, followed by a detailed discussion on how to work with each data type. Each chapter demystifies the complex data and you learn how to use the data types most efficiently.\u003c\/div\u003e\u003cdiv\u003e\u003cbr\u003e\u003c\/div\u003e\u003cdiv\u003eThe book offers a practical guide to working with complex data, using real-world examples to demonstrate how each data type can be leveraged. Performance considerations are also discussed, including the implementation of special indexes such as XML indexes and spatial indexes.\u003cbr\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003cbr\u003e\u003c\/div\u003e\u003cdiv\u003e\u003cdiv\u003e\u003cb\u003eWhat You'll Learn\u003c\/b\u003e\u003c\/div\u003e\u003c\/div\u003e\u003cdiv\u003e\u003cul\u003e\n\u003cli\u003eUnderstand the implementation of basic data types and why using the correct type is so important\u003c\/li\u003e\n\u003cli\u003eWork with XML data through the XML data type\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eConstruct XML data from relational result sets\u003c\/li\u003e\n\u003cli\u003eStore and manipulate JSON data using the JSON data type\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eModel and analyze spatial data for geographic information systems\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eDefine hierarchies and query them efficiently through the HierarchyID type\u003c\/li\u003e\n\u003c\/ul\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003cb\u003eWho This Book Is For\u003c\/b\u003e\u003cbr\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003cb\u003e\u003cbr\u003e\u003c\/b\u003e\u003c\/div\u003e\u003cdiv\u003eSQL Server developers and application developers who need to store and access complex data structures\u003c\/div\u003e \u003ch3\u003eDetails\u003c\/h3\u003e \u003cp\u003ePublished by: Apress\u003c\/p\u003e \u003cp\u003ePublication Date: 2018-08-24\u003c\/p\u003e \u003cp\u003eFormat: Paperback\u003c\/p\u003e \u003cp\u003eISBN-13: 9781484239001\u003c\/p\u003e \u003cp\u003eDOI: 10.1007\/978-1-4842-3901-8\u003c\/p\u003e \u003cp\u003eDimensions: 235cm x155cm\u003c\/p\u003e \u003cp\u003ePages: 392\u003c\/p\u003e ","brand":"Apress","offers":[{"title":"Default Title","offer_id":47707996684428,"sku":"9781484239001","price":58.49,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0710\/9545\/1788\/files\/9781484239001.jpg?v=1776781160","url":"https:\/\/fh90cf-fv.myshopify.com\/products\/9781484239001","provider":"Late Knight Books and Services, LLC","version":"1.0","type":"link"}