SQL Server 2000 provides powerful, versatile support for working with data as XML, and for communicating with the server over HTTP. In this course, you’ll learn how to retrieve data from SQL Server as XML, how to use standard XML-based techniques to query and modify data, and how to bulk-load large XML documents into SQL Server tables. The course combines detailed, example-based instruction on techniques with clear explanations of the underlying concepts.
Course includes 15+ hours of total training time...
SQL Server 2000 provides powerful, versatile support for working with data as XML, and for communicating with the server over HTTP. In this course, you’ll learn how to retrieve data from SQL Server as XML, how to use standard XML-based techniques to query and modify data, and how to bulk-load large XML documents into SQL Server tables. The course combines detailed, example-based instruction on techniques with clear explanations of the underlying concepts.
In this course you will learn to…
Understand the usefulness of the XML and HTTP technologies supported by SQL Server.
Safely set up Internet Information Services (IIS) to expose selected SQL Server data over the Internet or over your intranet.
Use the new FOR XML clause to return data from SQL Server as XML, and control the formatting of the XML results.
Create XML Views that expose your SQL Server data as if it were contained in an XML document.
Process XML within your SQL Server stored procedures.
Create XML documents that can be used to modify SQL Server data.
Efficiently load data from large XML files into SQL Server databases.
Prerequisites:
Some familiarity
with XML will be helpful, but it is not required—fundamental XML terms
and concepts are explained as they are introduced. Programming examples
assume knowledge of the Visual Basic language and ADO; however, these
examples comprise a relatively small portion of the material. The only
real prerequisite for this course is some basic experience using SQL
Server and Structured Query Language (SQL).
SESSION
1 (110 min)
XML Overview
A Standard for Exchanging
Data
XML Supporting Technologies
Combining XML with HTTP
XML/HTTP Features in SQL
Server 2000
Setting Up HTTP Access
to SQL Server
Creating a Virtual
Directory for SQL Server
Configuring Security
Setting Up Virtual Names
Using URL Queries and
Templates
SESSION
2 (117 min)
Retrieving Query
Results as XML
Using FOR XML
Retrieving XML from URL and
Template Queries
Creating and Using XML
Views
Understanding XML Views
Creating XML Views
Using the SQL Server XML
View Mapper
SESSION
3 (117 min)
Creating and
Using XML Views (cont.)
Using XML Views
and XPath to Query SQL Server Data
Your instructor, Andy Baron, is
a Senior Consultant with MCW Technologies, specializing in Visual Basic
and T-SQL programming, database design, the .NET Framework, and creation
of effective user interfaces. Andy is a Contributing Editor for Advisor
Media and for Pinnacle Publication, a writer for SQL Server Magazine,
and co-author of the Microsoft Access Developer's Guide to SQL Server.
Since 1995, Andy has been selected each year as a Microsoft MVP for his
contributions to Microsoft's online support. Andy also speaks regularly
at industry conferences.
