SQL Server Advanced Data Types (eBook)
XV, 392 Seiten
Apress (Verlag)
978-1-4842-3901-8 (ISBN)
- 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
?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.
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 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
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.
Chapter 1. SQL Server Data TypesChapter 2. Understanding XMLChapter 3. Constructing XML with T-SQLChapter 4. Querying and Shredding XMLChapter 5. XML IndexesChapter 6. Understanding JSONChapter 7. Constructing JSON from T-SQLChapter 8. Shredding JSON DataChapter 9. Working with the JSON Data TypeChapter 10. Understanding Spatial DataChapter 11. Working with Spatial DataChapter 12. Working with Hierarchical Data with HierarchyID
| Erscheint lt. Verlag | 23.8.2018 |
|---|---|
| Zusatzinfo | XV, 392 p. 103 illus. |
| Verlagsort | Berkeley |
| Sprache | englisch |
| Themenwelt | Informatik ► Datenbanken ► SQL Server |
| Schlagworte | CLR • Data storage and optimization • Geometry Data Type • Hierarchical data • HierarchyID • JSON • Page compression • Row compression • Spatial Data • User Defined Types • XML • XML Indexes • XQuery • XSD Schemas |
| ISBN-10 | 1-4842-3901-6 / 1484239016 |
| ISBN-13 | 978-1-4842-3901-8 / 9781484239018 |
| Informationen gemäß Produktsicherheitsverordnung (GPSR) | |
| Haben Sie eine Frage zum Produkt? |
PDF (Wasserzeichen)Größe: 7,4 MB
DRM: Digitales Wasserzeichen
Dieses eBook enthält ein digitales Wasserzeichen und ist damit für Sie personalisiert. Bei einer missbräuchlichen Weitergabe des eBooks an Dritte ist eine Rückverfolgung an die Quelle möglich.
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen dafür einen PDF-Viewer - z.B. den Adobe Reader oder Adobe Digital Editions.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen dafür einen PDF-Viewer - z.B. die kostenlose Adobe Digital Editions-App.
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich
