XML data type is available from SQL Server 2005, and XML support is even enhanced in SQL Server 2008. However, there are not many DBAs and database developers using all of the XML possibilities in SQL Server. One of the obstacles for broader usage might be XQuery, the XML query language, which is not well known in the relational community. In this session, we are going to explain basic XQuery structures and data types. After that, we are going to move to slightly more advanced topics, like using FLWOR expressions. We are going to show how you can iterate through XML nodes and even join two or more XML instances, and finally how you can design the returned XML instance.
Solid Quality Mentors
Dejan Sarka focuses on development of database & business intelligence applications. Besides projects, he spends about half of the time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or coauthor of eight books about databases and SQL Server. Dejan Sarka also developed two courses for Solid Quality Learning - Data Modeling Essentials and Data Mining with SQL Server 2008.
Register Now for PASS Summit 2010!