Working With Local Data Access Technologies

Developers wanting to understand the fundamentals of data access in .NET and those preparing for Microsoft exam 70-487.

Prerequisite
None

Expected Duration
192 minutes

Description
This course covers the foundations of data access in the Microsoft .NET Framework and how to choose between data access technologies, and is one of a series that prepares students for Microsoft exam 70-487.

Objective

Introducing Windows Azure and Web Services

  • start the course
  • explain .NET web services and use of the Windows Azure platform
  • choose a technology for creating a web service based on application requirements
  • Using ADO.NET to Query and Manipulate Data

  • understand how a .NET application connects to and queries a data source
  • use ADO.NET to query a SQL Server database
  • use an ADO.NET DataReader to read data from a data source
  • use ADO.NET to retrieve data from a data source into an in-memory dataset
  • insert, update, and delete records from a data source using the DbCommand class
  • insert, update, and delete records from an in-memory dataset and backing data source
  • retrieve and update database data using SQL Server stored procedures
  • perform synchronous and asynchronous database operations
  • LINQ Fundamentals

  • describe LINQ and its uses
  • use basic LINQ to Objects queries
  • issue advanced LINQ queries
  • use LINQ to update back-end data sources
  • Manipulating XML Data Structures

  • explain the uses of XML data structures
  • read XML data using XMLReader and XMLDocument
  • write and update an XML hierarchy using XMLWriter
  • understand Xpath and execute basic Xpath queries
  • transform XML using XSLT
  • query an XML document using LINQ to XML
  • update an XML document using LINQ to XML
  • Implementing Caching

  • understand caching and how to read and write basic cache entries
  • apply caching policies
  • use CacheDependency to update a cache periodically or in response to a trigger
  • use a SQL Server query notification to trigger a cache update
  • Implementing Transactions

  • understand transactions and their use
  • create and manage transactions directly against ADO.NET objects
  • create and manage transactions using high-level objects in the System.Transactions namespace
  • understand a simple distributed transaction
  • implement a simple distributed transaction
  • understand and specify transaction isolation levels
  • Practice: Understand Web Services and Data Access

  • identify web services and local data storage and access
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.