Name: SQL Server Advanced Data Types: Json, XML, and Beyond
Brand: Apress
SKU: 188274072
Price: 473 HKD
Availability: InStock

SQL Server Advanced Data Types

Json, XML, and Beyond

By Carter, Peter A.

Rating

Format

Paperback, 392 pages

Published

United States, 1 August 2018

Chapter 1. SQL Server Data Types

1) Exact Numbers

2) Approximate Numbers

3) Character Strings

4) Binary Strings

5) Date and Time Types

6) Other Data Types

Chapter 2. Data Storage and Optimization

1) SQL Server Storage Structures

2) Row and Page Compression

3) Sparse Columns

4) In-Memory Optimized Tables

Chapter 3. Understanding XML

1) Understanding XML Markup

2) Understanding XSD Schemas

3) XML Usage Scenarios

Chapter 4. Constructing XML with T-SQL

1) FOR XML RAW

2) FOR XML AUTO

3) FOR XML PATH

4) FOR XML EXPLICIT

Chapter 5. Querying and Shredding XML

1) Querying XML with XQuery

2) Shredding XML

3) Using Schemas

Chapter 6. XML Indexes

1) Primary XML Indexes

2) Secondary XML Indexes

Chapter 7. Understanding JSON

1) Understanding the JSON format

2) JSON Usage Scenarios

Chapter 8. Working with the JSON Data Type

1) FOR JSON

2) Querying JSON Data

3) Indexing JSON Data

Chapter 9. Understanding Spatial Data

1) Understanding Spatial Data Types

2) Spatial Data Usage Scenarios

3) Spatial Data Standards

Chapter 10. Working with Spatial Data Types

1) Using the Geometry Data Type

2) Using the Geography Data Type

3) Indexing Spatial Data

Chapter 11. Working with Hierarchical Data and HierarchyID

1) Hierarchical Data Usage Scenarios

2) Modelling Traditional Hierarchies

3) Working With the HierarchyID Data Type

4) Using HierarchyID Methods

Chapter 12. User Defined Types

1) Creating Data Types

2) Importing Data Types Into SQL Server

Our Price

HK$473

Elsewhere

HK$544.15

Save HK$71.15 (13%)

Ships from USA Estimated delivery date: 12th May - 20th May from USA

Free Shipping Worldwide

Buy together with Securing SQL Server at a great price!

Buy Together

HK$969

Elsewhere Price

HK$1,017.15

You Save HK$48.15 (5%)

Product Description

Chapter 1. SQL Server Data Types

1) Exact Numbers

2) Approximate Numbers

3) Character Strings

4) Binary Strings

5) Date and Time Types

6) Other Data Types

Chapter 2. Data Storage and Optimization

1) SQL Server Storage Structures

2) Row and Page Compression

3) Sparse Columns

4) In-Memory Optimized Tables

Chapter 3. Understanding XML

1) Understanding XML Markup

2) Understanding XSD Schemas

3) XML Usage Scenarios

Chapter 4. Constructing XML with T-SQL

1) FOR XML RAW

2) FOR XML AUTO

3) FOR XML PATH

4) FOR XML EXPLICIT

Chapter 5. Querying and Shredding XML

1) Querying XML with XQuery

2) Shredding XML

3) Using Schemas

Chapter 6. XML Indexes

1) Primary XML Indexes

2) Secondary XML Indexes

Chapter 7. Understanding JSON

1) Understanding the JSON format

2) JSON Usage Scenarios

Chapter 8. Working with the JSON Data Type

1) FOR JSON

2) Querying JSON Data

3) Indexing JSON Data

Chapter 9. Understanding Spatial Data

1) Understanding Spatial Data Types

2) Spatial Data Usage Scenarios

3) Spatial Data Standards

Chapter 10. Working with Spatial Data Types

1) Using the Geometry Data Type

2) Using the Geography Data Type

3) Indexing Spatial Data

Chapter 11. Working with Hierarchical Data and HierarchyID

1) Hierarchical Data Usage Scenarios

2) Modelling Traditional Hierarchies

3) Working With the HierarchyID Data Type

4) Using HierarchyID Methods

Chapter 12. User Defined Types

1) Creating Data Types

2) Importing Data Types Into SQL Server

EAN

9781484239001

ISBN

1484239008

Writer

Carter, Peter A.

Publisher

Apress

Other Information

Illustrated

Dimensions

23.4 x 15.6 x 2.1 centimeters (0.62 kg)

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.

About the Author

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

About the Author