SQL Server 2000 - XML-Enabled Applications Using SQL 2000

SQL Server 2000 - XML-Enabled Applications Using SQL 2000

Full Description

This course will give students a good understanding of how to use SQL 2000 in building and integrating applications that use or require a database and are enabled with XML. Course includes a primer for SQL and XML calls for SQL. Course also covers using HTTP, ADO with the SQL and XML calls.

Outcomes:

After Successful Completion of this course students will be able to Know and understand the interactions and compatibility of XML enabled applications using Microsoft SQL Server 2000.

Assessment:

This course provides assesment with quizzes and pre and post course tests. Students are able to review test scores, retake materials and retest to imporve outcome.

Course Information (see above or below lessons, outlines, activities, etc.) Instructor: Michael Lee is a Senior Trainer and Consultant with Saqqara Technology, Inc, a Microsoft Certified Partner and has over 10 years technology training experience and has published numerous books about SQL Server and Client/Server development. He is a popular speaker and presenter, and is in demand at client sites and conferences all over the US and Europe.



Course Outline:

Lesson 1: Introduction to XML Apps Using SQL SQL Primer Using Hierarchical Data XML Document Structure Formatting with XSL Validating Data with Schema XPath Concepts for SSQL Server General Syntax & SQL Limitations Location Paths Filters Operators & Functions Using the FOR XML Transact SQL Basic Concepts Using RAW Mode Using AUTO Mode Using the EXPLICIT Mode Using the OPENXML Transact SQL OPENXML Basics Mapping Columns to XML Defining Complex Mappings Performance Issues Lesson 2: Using SQL and XML Accessing SQL Data through HTTP Working with Virtual Directions Executing SQL Statements Executing Stored Procedures Using XML Templates Creating Templates Passing Parameters to Templates Using XSL Style Sheets with Templates Accessing Database Objects Using Annotated XDR Schemas Annotated Schema Concepts Mapping XML Elements to Columns Specifying Explicit Mappings Specifying Relationships Other Annotations Using XML with ADO Persisting ADO Data as XML Executing XML Queries Using Command Stream Attaching an XLS Style to XML Stream Using the XML for SQL Update Enhancements Using Updategrams Using the XML Bulk Load Utility

Contact Hours: 24