“When information is exchanged in XML format, there needs to be an agreement between the sender and receiver about the structure and content of the XML document. An XSD (XML Schema Definition Language) Schema can be used to enforce this contract and validate the XML data being exchanged.”

Jacob Sebastian, author.

Download the eBook (To download the eBook you need to be a member of Simple Talk, the download link will take you to the registration page).

Table of Contents

• Chapter 01: Introduction to XML Schema
• Chapter 02: Start Writing the First Schema
• Chapter 03: LAB: Order Processing Application for North Pole Corporation
• Chapter 04: Understanding Schema Components
• Chapter 05: Understanding Element Declarations
• Chapter 06: Understanding Attribute Declarations
• Chapter 07: XSD Primitive Data Types
• Chapter 08: Simple Types
• Chapter 09: XSD Built-in Derived Data Types
• Chapter 10: Complex Types
• Chapter 11: Complex Type Derivation
• Chapter 12: XSD Regular Expression Language
• Chapter 13: Advanced Schema Concepts
• Chapter 14: SQL Server Schema Collections and Metadata

Why read this book?

Today, a lot of applications exchange information in XML format. As such, there needs to be an agreement between the sender and receiver about the structure and content of the XML document. An XSD (XML Schema Definition Language) Schema can be used to enforce this contract and validate the XML data being exchanged. With SQL Server 2005 came the new native XML data type, and with it support for a subset of XSD. SQL Server stores XML schemas as ‘XML Schema Collections’, representing SQL Server objects, such as tables, views or stored procedures. Based on an XSD schema, you can create an XML Schema Collection that can be used to validate an XML data type, variable or column. An XML variable or column that is associated with an XML Schema Collection is known as TYPED XML. SQL Server validates a TYPED XML value against the rules defined in the schema collection. INSERT or UPDATE operations will succeed only if the value being inserted or updated is valid as per the rules defined in the Schema Collection.

This book will help you learn and use XML Schema collections in SQL Server. Prior knowledge of XSD is not required to start with this book, although any experience with XSD will make your learning process easier. This book starts with the basics of XML schemas and then walks you through everything you need to know, with examples and labs, in order to build powerful XML schemas in SQL Server.

If you have any question on the topics discussed in this book or on XSD in general, feel free to write to me at jacob@beyondrelational.com.

Book Details

• Paperback: 467 pages
• Publisher: Red Gate Books