SQL Server Advanced Data Types: JSON, XML, and Beyond

iebukes Apress 223 次浏览 没有评论
SQL Server Advanced Data Types: JSON, XML, and Beyond Front Cover

SQL Server Advanced Data Types: JSON, XML, and Beyond

by Peter A. Carter
  • Length: 392 pages
  • Edition: 1st ed.
  • Publisher: Apress
  • Publication Date: 2018-10-25
  • ISBN-10: 1484239008
  • ISBN-13: 9781484239001
  • Sales Rank: #1745346 (See Top 100 Books)
Description

Deliver 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.

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 that’s available from your organization’s 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 You’ll 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

Who This Book Is For 

SQL Server developers and application developers who need to store and access complex data structures

Table of Contents

Chapter 1: SQL Server Data Types
Chapter 2: Understanding XML
Chapter 3: Constructing XML with T-SQL
Chapter 4: Querying and  Shredding XML
Chapter 5: XML Indexes
Chapter 6: Understanding JSON
Chapter 7: Constructing JSON from T-SQL
Chapter 8: Shredding JSON Data
Chapter 9: Working with the  JSON Data Type
Chapter 10: Understanding Spatial Data
Chapter 11: Working with  Spatial Data
Chapter 12: Working with  Hierarchical Data and HierarchyID

下载地址:

SQL Server Advanced Data Types: JSON, XML, and Beyond

 

 亲,网盘文件已删,下载链接已失效


因为,我,失业了!于是我老家十八线小县城找了份掏下水道的工作。。。
 
为了生活
 
我决定将iebueks电子网站由免费改为赞助入群:
 
一年45元
 
从百度网盘群满之日算起。
 
这45元除了最新的英文IT电子书,还包括:

免费找书服务,中文英文皆可

国内出版社出版的中文电子书  
中文电子书
2022年公考资料
2022年公考资料
2023年考研学习资料
2023年考研学习资料
人人素材网各种视频素材模板以及中文字幕教程
人人素材网

入群指南


扫描下面二维码关注微信公众号获取资源

微信公众号二维码

发表评论

您的电子邮箱地址不会被公开。 必填项已用*标注

Go