Data Access and Manipulation using XML and ADO .NET

Hilton Computer Strategies
Houston, Texas, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course will teach developers to build data-centric applications and Web services with Microsoft ADO.NET, Microsoft SQL Serverâ„?2000, and the Microsoft .NET Framework.

Audience
This course is designed for the professional platform developer who is responsible for designing and building data-centric, distributed applications for his or her organization. It is designed for developers who have component and Web application development skills, and who have previously built solutions by using Microsoft Visual Studio®.

Typically, these individuals will have the following skills: Experience with a .NET language such as Microsoft Visual Basic® .NET, Microsoft Visual C#� or Microsoft Visual C++®; an understanding of object-oriented concepts and terminology; experience developing distributed applications; and experience developing Web-based applications hosted on Internet Information Server.

At Course Completion

After completing this course, students will be able to:

Describe data-centric applications, ADO.NET architecture, and ADO.NET and XML.
Connect to SQL Server and other data sources.
Perform connected database operations including executing SELECT commands, database definition commands, dynamic SQL commands, and commands that return data from a SQL Server database in XML.
Build a DataSet schema, populate it with data, and modify the data programmatically.
Build a DataSet from an existing data source.
Use XML techniques while working with DataSets, including mapping tables and columns, creating XSD schemas, building strongly typed DataSets, and interacting with XMLDataDocuments.
Build a Web service that uses ADO.NET to query and update a data source.
Troubleshoot errors within an ADO.NET application.
Microsoft Certified Professional Exams

This course will help the student prepare for the following Microsoft Certified Professional exam:

Exam 70-305: Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
Exam 70-306: Developing and Implementing Windows based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
Exam 70-315: Developing and Implementing Web Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET
Exam 70-316: Developing and Implementing Windows based Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET
Prerequisites
Before attending this course, students must have:

Understanding of relational database concepts: table, row, column, primary keys, foreign keys, constraints, and views
Data query and modification experience, including experience with SELECT, INSERT, UPDATE, and DELETE commands
Exposure to XML documents, style sheets, and schemas
Experience with Visual Basic .NET, Visual Basic for Applications, or previous versions of Visual Basic
Experience building user interfaces, including Web applications or Microsoft Windows® applications
Course Materials
The course materials are yours to keep. You will be provided with the following software for use in the classroom:

Microsoft Windows 2000 Server
Microsoft SQL Server 2000 Developer Edition
XML for SQL Server 2000 Web Release 2 (WR2)
Microsoft Visual Studio .NET
Microsoft Access 2002
Course Outline

Module 1: Basic XML

The following topics are covered in this module:

The Form of XML
Designing an XML Vocabulary
Namespaces
After completing this module, you will be able to, given a set of data requirements based on a real-world application, design an XML document that conforms to the formal rules of XML and satisfies requirements.

Module 2: Validating XML
The following topics are covered in this module:

Introducing Validation
Using XSD Schemas
After completing this module, you will be able to, given an instance document of moderate complexity, for example one that represents a purchase order, develop an XML schema to validate it.

Module 3: Technologies for Handling XML Data
The following topics are covered in this module:

Metadata and XML Processing
XML Processing Technologies
After completing this module, you will be able to identify situations where you need to use DOM, XPath, XSLT, and XQuery.

Module 4: Introduction to XML in the .NET Framework

This module introduces the use of XML in the .NET Framework to help you solve common business problems. XML is a standards-driven technology that is ideal for applications that use the Internet. Microsoft’s implementation of World Wide Web Consortium (W3C) standards ensures that applications you develop with XML in .NET will successfully communicate with other W3C-compatible applications

Lessons
Overview
Course at a Glance
Common Business Problems
XML in the .NET Framework
After completing this module, students will be able to:

Explain how XML provides solutions to common business problems.
Discuss how Microsoft’s implementation of W3C standards for XML provides a framework for XML solutions to business problems.
Diagram XML support in the .NET Framework.

Module 5: Parsing XML
This module discusses how to parse XML data from a file, string, or stream by using the XmlReader class. It also covers how to use the XmlTextReader to process XML as text, and how to use the XmlNodeReader to filter data by using an XPath expression and the object.

Lessons
Overview of XML Parsing
Parsing XML Using XmlTextReader
Creating a Custom Reader
Lab 5.1: Parsing XML
Exercise 1: Building an XML Web Service to Parse XML
After completing this module, students will be able to:

Create a Stream object from an XML file.
Build a mutable string by using the StringBuilder object.
Handle errors in the form of XML.
Parse XML as text by using the XmlTextReader object.
Create a custom XmlReader object.

Module 6: Validating XML
This module gives an overview of XML Schema Definition (XSD) data types, and then covers how to use the Microsoft .NET Framework XML classes to perform XML schema validation. The lesson Advanced Validation teaches how to resolve external entities, how to validate XML fragments, and how to validate XML by using a Document Type Definition (DTD).

Lessons
Examining Schemas
Validating XML While Parsing
Advanced Validation
Lab 6.1: Validating XML
Exercise 1: Extend an XML Web Service to Validate XML
After completing this module, students will be able to:

Instantiate an XML validating reader.
Associate one or more XML schemas with an XML validating reader.
Handle errors that result when a validating reader processes invalid XML.
Create an application that uses the .NET Framework XML classes and XML schemas to validate an XML fragment.
Resolve a Uniform Resource Identifier (URI) reference to a schema or DTD.
Create an application that uses the .NET Framework XML classes and an XSD schema or a DTD to validate well-formed XML.

Module 7: Writing XML
Writing XML is a central skill in developing XML-based applications. This module describes the .NET Framework classes that are used to write XML with or without namespaces. The module also explains how to control the format and validity of XML as it is being written.

Lessons
Overview of Generating XML Documents
Writing XML
Generating XML with Namespaces
Controlling XML Format and Converting XML
Lab 7.1: Writing XML
Exercise 1: Building an XML Web Service to Write XML
After completing this module, students will be able to:

Use the XmlTextWriter class to write well-formed XML.
Generate namespaces for elements and attributes.
Control indentation and other code format characteristics when ge ...''

Phone:1-800-324-7415

School Address:

Hilton Computer Strategies, 6001 Savoy, Suite 207, Houston, TX 77036 USA

Jobs & Resumes: Houston
Houses & Roommates: Houston

Developing Microsoft ASP .NET Web Applications using Visual Studio .NET
Advanced Web Application Development Using Microsoft ASP .NET
Visual Basic .NET
Programming with the .NET Framework (Visual Basic .NET)
XML and the Microsoft .NET Platform
Developing XML Web Services using Microsoft ASP.NET
Developing .NET Applications for Windows (C Sharp .NET)
C Sharp Programming with Microsoft .NET
Programming with XML in the Microsoft .NET Framework
XML Web Services (with MegaLAB)
Core Data Access With Microsoft Visual Studio 2005
Advanced Data Access with Microsoft Visual Studio 2005
Web Application Technologies with Microsoft Visual Studio 2005
Windows Forms Technologies with Microsoft Visual Studio 2005
Distributed Application Development with Microsoft Visual Studio 2005
Programming .NET Framework Applications with Visual Studio 2005
Programming with the .NET Framework using Visual Studio 2005
Web Application Development Using C Sharp & ASP .NET 2.0
Web Application Development Using VB .NET & ASP .NET 2.0

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: This website holds more than 300,000 training course records worldwide, with hundreds of new postings daily. All services in this website are free!