Total Time: 3 hour(s)

Summary: 
This course shows learners how to create Visual Basic .NET applications that access and manipulate data in relational databases and in XML files.

Ojectives: 
After completing this course, students will be able to:
Create a dataset schema
Create a dataset from a dataset schema
Write code that refers to data in a dataset schema
Construct and interpret t-sql statements
Write code that retrieves information from XML files and executes XML queries

Topics: 
Manipulating a dataset schema
Manipulating dataset relationships
Creating and using strongly typed datasets
Constructing ad hoc queries
Creating SQL queries
Using stored procedures
Accessing an XML file
Using the XML datadocumentclass
Understanding XPath
Using XSD schemas
Using XML with SQL server

Technical Requirements: 
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.