SQL Server 2000 - XML-Enabled Applications Using SQL 2000
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
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.
|
|
||||||||||
SQL Server 2000 - XML-Enabled Applications Using SQL 2000
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.
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
Contact Hours: 24
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.
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
- General Syntax & SQL Limitations
- Location Paths
- Filters
- Operators & Functions
- Basic Concepts
- Using RAW Mode
- Using AUTO Mode
- Using the EXPLICIT Mode
- OPENXML Basics
- Mapping Columns to XML
- Defining Complex Mappings
- Performance Issues
- Working with Virtual Directions
- Executing SQL Statements
- Executing Stored Procedures
- Creating Templates
- Passing Parameters to Templates
- Using XSL Style Sheets with Templates
- Accessing Database Objects
- Annotated Schema Concepts
- Mapping XML Elements to Columns
- Specifying Explicit Mappings
- Specifying Relationships
- Other Annotations
- Persisting ADO Data as XML
- Executing XML Queries Using Command Stream
- Attaching an XLS Style to XML Stream
- Enhancements
- Using Updategrams
- Using the XML Bulk Load Utility
Contact Hours: 24
About The Training Provider: Online Training Directory
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...
