• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

IT Vendor Courses   Microsoft SQL Server Training Courses

M2091: Building XML-Enabled Applications Using Microsoft SQL Server 2000

View course dates

Course Duration: 3 days

Course Code: M2091

Course Description:

This course is intended for developers of database client applications, including Internet and N-tiered application clients.

It is also intended for SQL Server database developers who need to query, insert, update, or delete data from a database by using XML, and for SQL Server database administrators who need to publish SQL data as XML.

Prerequisites:

Before attending this course, students must:



- Have written basic Transact-SQL statements to query, insert, update, and delete information from a database, and used joins to retrieve information from multiple tables.
- Have knowledge of relational database design, including the use of primary and foreign keys. Students should know how to create databases, tables, and stored procedures. Students should also be familiar with the SQL Server Query Analyzer and SQL Profiler tools.
- Have knowledge of basic XML formats and techniques, including attributes and elements, schemas, the Extensible Stylesheet Language (XSL) and Extensible Stylesheet Language Transformations (XSLT), and the XML Path Language (XPath).
- Be able to access a data source by using ADO.
- Be able to write Visual Basic Script (VBScript) code.
- Be able to read standard Hypertext Markup Language (HTML) and build a form to gather and present data.
- Be able to create Active Server Pages (ASP) by using the ASP Programming model. Skills include using the POST and GET methods, using the Response object, and using the Session object.






Taking one or more of the following courses will help the students meet the prerequisites and get more out of the course:



- Course 1905, Building XML-Based Web Applications
- Course 2073, Programming a Microsoft SQL Server Database

Prerequisite courses:

Developing XML-Based Applications

M2073: Microsoft SQL Server 2000 Database Programming

This course includes the following modules:

Using XML and Microsoft SQL Server 2000

• Building Solutions with XML and SQL Server 2000
• XML Technology Review
• XML Support in SQL Server 2000

Retrieving XML Data

• Using the FOR XML Clause to Retrieve Data
• Controlling XML Output
• Generating Custom XML Formats

Manipulating XSL Using Transact SQL

• Creating a Rowset from an XML Document
• Processing Nested Documents
• Working with Meta-Properties

Using ADO to Access XML Data

• Retrieving XML Data with ADO
• Using ADO and XML on an ASP-Based Web Site

Using HTTP to Access XML Data

• Enabling HTTP Access to SQL Databases
• Publishing XML Templates on the Server
• Posting Query Templates from the Client
• Publishing a Database Object

Using Mapping Schemas

• Using Mapping Schemas
• Using Schemas to Retrieve Data
• Mapping Multiple Tables
• Annotating an Existing Schema

XML for SQL Tools

• Modifying Data with Updategrams
• Inserting Data with the Bulk Load Facility

 

To make an enquiry for this course to be run ONSITE at your location, click here or call Sales on +44 (0) 20 7620 0033.

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course