SQL Server Advanced Data Types: JSON, XML, and Beyond by Peter A. Carter (Englis

Description: SQL Server Advanced Data Types by Peter A. Carter Tagline: Taking full advantage of SQL Servers ever-growing support for modern data FORMAT Paperback LANGUAGE English CONDITION Brand New Publisher Description Deliver advanced functionality faster and cheaper by exploiting SQL Servers 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.Widely 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 thats available from your organizations SQL Server database investment. SQL Server Advanced Data Types 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.The 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.What Youll LearnUnderstand the implementation of basic data types and why using the correct type is so importantWork with XML data through the XML data typeConstruct XML data from relational result setsStore and manipulate JSON data using the JSON data typeModel and analyze spatial data for geographic information systemsDefine hierarchies and query them efficiently through the HierarchyID typeWho This Book Is ForSQL Server developers and application developers who need to store and access complex data structures Back Cover Deliver advanced functionality faster and cheaper by exploiting SQL Servers 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. Widely 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 thats available from your organizations SQL Server database investment. SQL Server Advanced Data Types explores each of the complex data types supplied within SQL Server. Common usage scenarios for each complex 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. The 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. What Youll Learn: Understand the implementation of basic data types and why using the correct type is so important Work with XML data through the XML data type Construct XML data from relational result sets Store and manipulate JSON data using the JSON data type Model and analyze spatial data for geographic information systems Define hierarchies and query them efficiently through the HierarchyID type Author Biography Peter Carter is a SQL Server expert with over a decade of experience in developing, administering, and architecting SQL Server platforms and data-tier applications. He was awarded an MCC by Microsoft in 2011. He has MCTS, MCITP, MCSA, and MCSE certifications in SQL Server from version 2005 onward. Peter has written a number of books across a variety of SQL Server topics, including security, high availability, and automation. Table of Contents 1. SQL Server Data Types.- 2. Understanding XML.- 3. Constructing XML with T-SQL.- 4. Querying and Shredding XML.- 5. XML Indexes.- 6. Understanding JSON.- 7. Constructing JSON from T-SQL.- 8. Shredding JSON Data.- 9. Working with the JSON Data Type.- 10. Understanding Spatial Data.- 11. Working with Spatial Data.- 12. Working with Hierarchical Data with HierarchyID. Feature Shows how non-relational data types can transform the way you store and interact with business critical data Introduces the growing amount of support within SQL Server for operations and data transformations that until now required third-party software and the associated licensing and development costs Presents what can be done inside the database engine with no additional costs or development time invested in outside software Description for Sales People Microsoft has been steadily adding support for advanced data types into their database engine, and many developers and database administrators are not fully aware of what these new types can provide in the way of optimization and speeding development time. This book introduces readers to the growing amount of support within SQL Server for operations and data transformations that until now required third-party software and all the associated licensing and development costs. Readers 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. Details ISBN1484239008 Publisher APress Year 2018 Edition 1st ISBN-10 1484239008 ISBN-13 9781484239001 Format Paperback Imprint APress Subtitle JSON, XML, and Beyond Place of Publication Berkley Country of Publication United States Author Peter A. Carter DEWEY 005.74 Pages 392 Publication Date 2018-08-24 Short Title SQL Server Advanced Data Types Language English DOI 10.1007/978-1-4842-3901-8 AU Release Date 2018-08-24 NZ Release Date 2018-08-24 US Release Date 2018-08-24 UK Release Date 2018-08-24 Illustrations 103 Illustrations, black and white; XV, 392 p. 103 illus. Edition Description 1st ed. Alternative 9781484245828 Audience Professional & Vocational We've got this At The Nile, if you're looking for it, we've got it. With fast shipping, low prices, friendly service and well over a million items - you're bound to find what you want, at a price you'll love! TheNile_Item_ID:137820948;

Price: 98.2 AUD

Location: Melbourne

End Time: 2024-11-05T01:56:24.000Z

Shipping Cost: 0 AUD