Training Classes | Learning and Development Resources | Training Directory | New Training Programs | New Training Providers | Site Map | Promote Training | Training Keywords | Training Programs | Training Providers | Regions | Training Search | Advertise Training Programs | Login
Provided by: Online Training Directory

SQL Server 2000 - XML-Enabled Applications Using SQL 2000

Click here for more information or to take this course

Search for Training
Find Your Genius!
What do you want to learn about?

Training Provided by Online Training Directory

This course is designed to teach students the basics of SQL and XML in building and combining applications where database functions are required

Training Avaliability and Delivery

on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Contact Online Training Directory for more information
Training Presented in:English

Related Keywords:  programming   languages   linux   windows   database   sql   server 

Training Program Details


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


About Online Training Directory - Training Provider

Online Training Directory - Workforce and Continuing Ed online courses are offered at basic, intermediate and advanced levels. Going beyond basic training provides a deeper and more educationally rewarding learning experience, especially for students who wish to advance careers or initiate new ones. For the general lifelong learner we continue to offer "fun to learn" single, stand-alone courses. We look forward to...

More SQL Server Training from Online Training Directory

Click here for more information or to take this course

Training Directory | New Training Programs | New Training Providers | Search | Site Map | Promote Training | Login | Links


Connecting people who want to learn with people who love to teach
 Are you a Programming training provider?
You could be on this page today - for FREE!