SQL Server advanced data types : JSON, XML, and beyond /: JSON, XML, and beyond. (2018)

• Record Type: Book
• Further Information: Note: Peter A. Carter.
• Authors: Carter, Peter A
• Contents: Intro; Table of Contents; About the Author; About the Technical Reviewer; Introduction; Chapter 1: SQL Server Data Types; Numeric Data Types; Character Strings; Binary Data Types; Dates and Times; Miscellaneous Standard Data Types; Summary of Advanced Data Types; Why Is Using the Correct Data Type Important?; Summary; Chapter 2: Understanding XML; Understanding XML; Well-Formed XML; Understanding XSD Schemas; XML Usage Scenarios in SQL Server; Summary; Chapter 3: Constructing XML with T-SQL; Using FOR XML RAW; Using FOR XML AUTO; Using FOR XML PATH; Using FOR XML EXPLICIT; Summary Chapter 4: Querying and Shredding XMLQuerying XML; Using exist(); Using value( ); Using query( ); Using Relational Values in XQuery; FLWOR; Modifying XML Data; Shredding XML; Shredding XML with OPENXML( ); Shredding XML with Nodes; Using Schemas; Summary; Chapter 5: XML Indexes; Preparing the Environment; Clustered Indexes; Tables Without a Clustered Index; Tables with a Clustered Index; Clustering the Primary Key; Performance Considerations for Clustered Indexes; Creating a Clustered Index; Primary XML Indexes; Creating Primary XML Indexes; Secondary XML Indexes Creating Secondary XML IndexesPerformance Considerations for XML Indexes; Summary; Chapter 6: Understanding JSON; Understanding the JSON Format; JSON vs. XML; JSON Usage Scenarios; n-Tier Applications with Rest APIs; De-Normalizing Data; Config As Code; Analyzing the Log Data; Summary; Chapter 7: Constructing JSON from T-SQL; FOR JSON AUTO; Working with Root Nodes; Working with NULL Values; Using Column Aliases; Automatic Nesting; FOR JSON PATH; Summary; Chapter 8: Shredding JSON Data; OPENJSON() with Default Schema; Shredding a Column; Dynamic Shredding Based on Document Content OPENJSON( ) with Explicit SchemaOPENJSON( ) with Path Expressions; Shredding Data into Tables; Summary; Chapter 9: Working with the JSON Data Type; Querying JSON Data; Using ISJSON( ); Using JSON_VALUE( ); Using JSON_QUERY( ); Using JSON_MODIFY(); Indexing JSON Data; Summary; Chapter 10: Understanding Spatial Data; Understanding Spatial Data; Spatial Data Standards; Well-Known Text; Well-Known Binary; Spatial Reference Systems; SSMS and Spatial Data; Summary; Chapter 11: Working with Spatial Data; Constructing Spatial Data; Querying Spatial Data; Indexing Spatial Data Understanding Spatial IndexesCreating Spatial Indexes; Summary; Chapter 12: Working with Hierarchical Data and HierarchyID; Hierarchical Data Use Cases; Modeling Traditional Hierarchies; Modeling Hierarchies with HierarchyID; HierarchyID Methods; Working with HierarchyID Methods; Using ToString( ); Using Parse( ); Using GetRoot( ); Using GetLevel( ); Read( ) and Write( ); Using GetDescendant( ); Using GetReparentedValue( ); Using GetAncestor( ); Using IsDescendantOf( ); Indexing HierarchyID Columns; Summary; Index
• Publisher Details: United States : Apress
• Publication Date: 2018
• Copyright Date: 2018
• Extent: 1 online resource
• Subjects: 005.13/3; Computer science; Data types (Computer science); JSON (Document markup language); XML (Document markup language); COMPUTERS / Databases / General; Database management; Computers -- Database Management -- General; Databases; Electronic books
• Languages: English
• ISBNs: 9781484239018; 1484239016
• Related ISBNs: 9781484239001; 1484239008
• Notes: Note: Online resource; title from PDF title page (Ebsco, viewed August 30, 2018).
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.