|
This course shows learners how to create Visual Basic .NET applications that access and manipulate data in relational databases and in XML files.
Objectives:
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
|