- Applications using Microsoft ® SQL Server ™ 2000. - Except as expressly provided in any written license agreement from Microsoft, the furnishing of this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property.. - Module 1: Using XML and Microsoft SQL Server 2000 Overview...1. - Building Solutions with XML and SQL Server 2000...2. - XML Support in SQL Server 2000...21. - Module 2: Retrieving XML Data Overview...1. - Lab 2.1: Retrieving XML Data ...26. - Lab 2.2: EXPLICIT Queries ...42. - Module 4: Using ADO to Access XML Data Overview...1. - Retrieving XML Data with ADO...2. - Lab 4.1: Creating an ADO Client Application...16. - Lab 4.2: Using ADO on a Web Site...27. - Module 5: Using HTTP to Access XML Data. - Lab 5.1: Publishing a SQL Server Database. - Lab 5.2: Accessing a Database Object. - Module 6: Using Mapping Schemas Overview. - Using Mapping Schemas. - Lab 6.1: Using Mapping Schemas. - Lab 6.2: Mapping Multiple Tables. - Lab 6.3: Annotating an Existing Schema. - Lab 7.1: Using Updategrams. - Inserting XML Data with the Bulk Load Facility. - Lab 7.2: Bulk Loading XML Data. - About This Course. - This course provides students with the knowledge and skills they need to build applications that exchange data with Microsoft ® SQL Server ™ in Extensible Markup Language (XML) format. - The course covers the XML-based features of Microsoft SQL Server 2000, including XML-based enhancements to the T-SQL language. - configuring SQL Server for Internet/intranet access. - publishing SQL Server data on the Internet by using the HTTP protocol. - XML data access by using Microsoft ActiveX ® Data Objects (ADO) 2.6 and the SQL Server OLE DB (SQLOLEBD) Provider. - using XML Data-Reduced (XDR) Schemas. - and updating a database with XML data.. - The target audience for this course includes:. - SQL Server database developers who need to query, insert, update, or delete data from a database by using XML.. - SQL Server database administrators who need to publish SQL data as XML.. - This course requires that students meet the following prerequisites:. - Successful completion of Course 2073A, Programming a Microsoft SQL Server Database, or equivalent experience designing relational databases, including the use of primary and foreign keys. - Students should also be familiar with the SQL Server Query Analyzer and SQL Profiler tools.. - Experience using ADO to access a data source.. - The modules in this course provide instruction and learning activities that allow students to achieve the following objectives.. - 1 Describe the XML features provided by SQL Server 2000 and the SQL Server-XML architecture.. - 2 Generate and specify the structure of an XML document from SQL Server data by using Transact-SQL.. - 3 Insert XML data into SQL Server, and use XML to modify existing data.. - 4 Use ADO to access SQL Server data and generate XML.. - 5 Publish a SQL Server database on the Internet/intranet over HTTP, and query the data by using a URL.. - 6 Create and use annotated schemas to query and transform SQL Server data.. - 9:30 10:30 Module 1: Using XML and Microsoft SQL Server Break. - Lab 1: Working with XML Module 2: Retrieving XML Data Lunch. - 1:00 1:30 Lab 2.1: Retrieving XML Data. - 1:30 2:45 Module 2: Retrieving XML Data (continued Break. - 3:00 3:30 Lab 2.2: EXPLICIT Queries. - Module 4: Using ADO to Access XML Data Lunch. - 1:00 1:15 Lab 4.1: Creating an ADO Client Application. - 1:15 1:30 Module 4: Using ADO to Access XML Data (continued Lab 4.2: Using ADO on a Web Site. - 2:00 2:30 Module 5: Using HTTP to Access XML Data 2:30 2:45 Break. - 2:45 3:30 Lab 5.1: Publishing a SQL Server Database. - 3:30 4:00 Module 5: Using HTTP to Access XML Data (continued). - 9:30 10:00 Module 5: Using HTTP To Access XML Data (continued Lab 5.2: Accessing a Database Object. - Module 6: Using Mapping Schemas Lab 6.1: Using Mapping Schemas Lunch. - 12:45 1:15 Module 6: Using Mapping Schemas (continued Lab 6.2: Mapping Multiple Tables. - 1:45 2:15 Module 6: Using Mapping Schemas (continued Break. - 2:30 3:00 Lab 6.3: Annotating an Existing Schema 3:00 3:45 Module 7: XML for SQL Tools. - 3:45 4:15 Lab 7.1: Using Updategrams 4:45 5:00 Lab 7.2: Bulk Loading XML Data. - The Trainer Materials compact disc contains the following files and folders:. - It contains the steps for manually installing the classroom computers.. - This folder contains the Web page that provides students with links to course-related resources, including additional reading, review and lab answers, lab files, multimedia presentations, and course-related Web sites.. - This folder contains a template that is used to record any errors and corrections that you find in the course.. - This folder contains fonts that are required in order to view the Microsoft PowerPoint ® presentation and Web-based materials.. - This folder contains files that are required to install Microsoft Windows Media ™ Player.. - This folder contains the PowerPoint slides that are used in this course.. - This folder contains the PowerPoint Viewer, which is used to display the PowerPoint slides.. - This folder contains the files that install the course and related software to computers in a classroom setting.. - This folder contains files and utilities used to complete the setup of the instructor computer.. - This folder contains the files that are required in order to view the course Web page. - Student Materials Compact Disc Contents. - The Student Materials compact disc contains the following files and folders:. - This folder contains additional reading related to this course. - If there are no additional reading files, this folder does not appear.. - This folder contains appendix files for this course. - If there are no appendix files, this folder does not appear.. - This folder contains demonstration code. - If there is no demonstration code, the Democode folder does not appear.. - This folder contains fonts that are required in order to view the PowerPoint presentation and Web-based materials.. - This folder contains Internet Explorer 5.5.. - This folder contains files that are used in the hands-on labs. - This folder contains files that are used in multimedia presentations for this course. - If this course does not include any multimedia presentations, this folder does not appear.. - This folder contains elements for autorun.exe.. - This folder contains files that are required to install Windows Media Player.. - This folder contains files that are used in the hands-on practices.. - If there are no practices, the Practices folder does not appear.. - This folder contains the sample applications associated with this course. - If there are no associated sample applications, the Sampapps folder does not appear.. - This folder contains sample code that is accessible through the Web pages on the Student Materials compact disc. - If there is no sample code, the Sampcode folder does not appear.. - This folder contains files that create the sample site associated with this course. - If there is no sample site, the Sampsite folder does not appear.. - This folder contains additional files that may be required for lab setup. - If no additional files are required, the Setup folder does not appear.. - This folder contains the Word Viewer that is used to view any Word document (.doc) files that are included on the compact disc. - If no Word documents are included, this folder does not appear.
Xem thử không khả dụng, vui lòng xem tại trang nguồn hoặc xem
Tóm tắt