Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Order CD-ROMs   Order Videos 
Microsoft SQL Server 2000 and XML
with Andy Baron

CD-ROM Training

for Developers by Developers™


View the Course Outline

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...

  • 3 CDs
  • Over 5 hours of media run time
  • Over 200 pages of courseware on CD-ROM
  • Step-by-step hands-on-labs
  • Sample code
Format Sessions Retail Price
Microsoft SQL Server 2000 and XML
CD-ROM

 3 CD-ROMs

$495.00  
CD-ROM & Books

 3 CD-ROMs + Printed Books

$525.00  
Read about Andy Baron.
Special savings on this course: XML Developer CD-ROM Training Suites™
Course Outline (Outlines are subject to change.)

XML with Microsoft SQL Server 2000

Sessions Run Time Pages
3 CDs 5 hours 200

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
  • Using XPath to Retrieve SQL Server Data Directly

Processing XML Documents in Transact-SQL

  • Understanding the XML Document Object Model (DOM)
  • Parsing XML Data with OpenXML
  • Defining the OpenXML Rowset
  • Using OpenXML to Modify Data

Modifying Data with Updategrams and XML Bulk Load

  • XML for SQL Server 2000 Web Release 1
  • Using Updategrams to Modify Data
  • XML Bulk Load

back to top


Your Instructor

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.

back to top


 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
© Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy