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


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
Microsoft SQL Server 2000 and XML
Format Modules Retail Price

CD-ROM

3CD-ROMs

$195
Buy Now!

CD-ROM & Books

3CD-ROMs + Printed Books

$225
Buy Now!

Order online 

Read about Andy Baron

Course Outline(Outlines are subject to change.)

XML with Microsoft SQL Server 2000

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

  • 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 (110min)

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

Andy Baron is a nationally recognized industry expert specializing in Visual Basic, Visual C#, ASP.NET, ADO.NET, SQL Server and SQL Server Business Intelligence. He has authored and presented more than 15 Visual Studio and SQL Server courses . Andy is also Senior Consultant with MCW Technologies, as well as a contributing editor for Advisor Media and Pinnacle Publications, 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