This is a full day course that focuses on learning XSD and XML Schema Collections. SQL Server supports a limited subset of the XSD specification. This session will examine all the XSD features supported in SQL Server 2005 and all the new features added in SQL Server 2008. Session 1: Getting started with XSD and XML Schema Collections
This is an introductory session where the participants will develop basic XSD skills. It focuses on helping the attendees to learn the basics of XSD and make them capable of creating and using XML Schema collections to validate their TYPED XML data. Session 2: Understanding Schema Components
This session will take the attendees deeper into the building blocks of XSD. A very detailed over view of simple types, complex types, attribute groups and modal groups is given in this session. This session examines the attributes of element and attribute declarations in detail. Session 3: XSD and Type Derivation
This session starts with understanding XSD primitive and derived data types. It further walks the attendees through creating and using user defined simple and complex types. Finally it demonstrates type derivation in XSD and helps the attendees to derive types from simple and complex types, having different content models and deriving by extension and restriction. Session 4: Advanced Schema Concepts
This session focuses on some of the advanced schema concepts. It starts with a detailed discussion on the regular expression language supported by XSD, which can be used to perform a variety of pattern restrictions. It further takes the attendees into detailed discussion on the attributes of schema element declaration, element and attribute wild card declarations, lax validation support added in SQL Server 2008, XML Schema Collection metadata and the limitations of the XSD implementation in SQL Server.