Microsoft Course 2541 - Core Data Access with Microsoft Visual Studio 2005— A 3-Day CourseCourse SynopsisThis three-day instructor-led workshop provides students with the knowledge and skills to develop data-access applications by using the Microsoft .NET Framework and Microsoft Visual Studio 2005. The workshop describes how to access and update data in a database by using ADO.NET. The workshop also describes how to create, read, and write XML data. Course ObjectivesOn completion of this course, delegates should be able to:
Intended AudienceThis workshop is intended for corporate and Independent Software Vendor (ISV) application developers who have a desire to learn more about specific technology areas in distributed application development. Course PrerequisitesBefore attending this course, students must:
Microsoft Certified Professional ExamsThere is no Microsoft Certified Professional exam associated with this course. Publicly scheduled dates, locations, and pricesCentral London — £595 (+VAT)
Leeds — £595 (+VAT)
Manchester — £595 (+VAT)
Leicester — £595 (+VAT)
Sunderland — £595 (+VAT)
Glasgow — £595 (+VAT)
Outline Course ContentsUnit 1: Connecting to Databases and Reading DataThis unit introduces the fundamental skills required to connect to a database and read data from the database. It describes how to use ADO.NET data providers to connect to various different kinds of databases, and how to execute a query that returns a scalar value from the database. It also describes how to use connection pooling to achieve scalability, and how to handle connection events and exceptions.
After completing this unit, students will be able to:
Unit 2: Querying and Updating Databases by Using CommandsThis unit describes how to create and run commands that return a scalar value, return a result set, update data in the database, or update the schema of the database. It also describes how to create and run parameterized commands.
After completing this unit, students will be able to:
Unit 3: Performing Transactional OperationsThis unit describes how to manage transactions in a .NET application at the middle tier. It describes how to write ADO.NET code to start, commit, and rollback local transactions. It also describes how to specify an appropriate isolation level for a transaction, and how to enlist in distributed transactions.
After completing this unit, students will be able to:
Unit 4: Performing Disconnected Operations ProgrammaticallyThis unit describes how to create and use DataSets programmatically. It describes how to create DataSet, DataTable, and DataColumn objects, how to populate a DataSet manually, and how to load and save data by using a DataAdapter. It also describes how to create in-memory views on data by using a DataView.
After completing this unit, students will be able to:
Unit 5: Performing Disconnected Operations by Using Visual Studio 2005 WizardsThis unit describes how to create typed DataSets, DataAdapters, and TableAdapters by using the TableAdapter Configuration Wizard and the Data Source Configuration Wizard in Visual Studio 2005. It also describes how to write type-safe code to access data in a typed DataSet.
After completing this unit, students will be able to:
Unit 6: Performing XML Operations on Disconnected DataThis unit describes how to read and write DataSets in XML format. It describes how to read and write data only, schema only, or a combination of the two. It also describes how to read and write a DataSet as a DiffGram, so that modifications to the data can be retained when the DataSet is serialized to XML format.
After completing this unit, students will be able to:
Unit 7: Reading and Writing XML DataThis unit describes how to use the XmlReader and XmlWriter classes to serially read and write XML data. It describes how to read elements, attributes, and text content in an XML document, and perform validation against an XML schema. It also describes how to create an XML document and write elements, attributes, namespace declarations, and text content.
After completing this unit, students will be able to:
Unit 8: Processing XML Data by Using DOMThis unit describes how to process XML data in memory by using the Document Object Model (DOM). It describes how to load an XML document into a DOM tree, and validate the XML document against an XML schema. It also describes how to read existing XML content, modify XML content, and save the DOM tree to an XML document.
After completing this unit, students will be able to:
|
Visual Studio training UK enquiriesVisual Studio training UK pricesFor publicly scheduled training (individual places), see our UK training schedule. In-house training for company groups is charged at a daily rate per group — see our In-House UK Training Guidelines. Publicly Scheduled Training LocationsWe currently run public training courses in the following locations:
Most UK public training courses are available on a monthly basis. Please see the individual course outlines or our public training schedule for details. In-house (on-site) training locationsWe deliver in-house courses at client premises and/or training facilities in any part of the world which is practically and commercially accessible. Our In-house training guidelines outline our basic requirements and our UK pricing structure. To estimate costs for training in other countries, simply convert to your local currency and then make a rough calculation of our tutor's costs for travelling to and staying at your location. |
|
West Yorkshire Office
GBdirect Ltd
Training: 0800 651 0338 Please call between 0900 and 1700 (UK time) on Monday to Friday South East Regional Office
GBdirect Ltd
Training: 0800 651 0338 Please call between 0900 and 1700 (UK time) on Monday to Friday Please note: |
