Font size:

Description:

This is a bundled training package. It contains training for each of the bundled items below:

Course Price
Getting Started with ADO.NET 4 Connections and Commands Using Visual Basic 2010 $74.95
Managing ADO.NET 4 Connections and Commands with Visual Basic 2010 $74.95
Getting Started with ADO.NET 4 DataSets using Visual Basic 2010 $74.95
Viewing and Navigating Data with ADO.NET 4 DataSets using Visual Basic 2010 $74.95
Updating ADO.NET DataSets with Visual Basic 2010 $74.95
Synchronizing Data and Managing ADO.NET 4 Applications with Visual Basic 2010 $74.95
Working with the ADO.NET Entity Framework 4 using Visual Basic 2010 $74.95
Using LINQ and XML with ADO.NET 4 and Visual Basic 2010 $74.95

Bundle Price: $249.00
Total Savings: $350.60


Getting Started with ADO.NET 4 Connections and Commands Using Visual Basic 2010

ADO.NET allows developers to create applications that are driven by data and services. This course identifies the various ways to manage ADO.NET connections and also details how to access data by using command objects and the DataReader object. Specific topics covered in the course include an introduction to ADO.NET, defining ADO.NET Connection objects, managing connections with Visual Basic 2010, and using ADO.NET command objects and DataReaders. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist: Accessing Data with Microsoft .NET Framework 4 Exam 70-516. Passing this exam will earn the learner credit towards the MCTS: .NET Framework 4, Data Access certification.
  • identify the features, capabilities, and benefits of ADO.NET
  • identify the components and uses of the ADO.NET object model, the DataSet object, and data providers
  • identify the uses and benefits of LINQ and the Entity Framework
  • select the appropriate .NET data provider in a given scenario
  • identify the steps for setting the ConnectionString property
  • identify the features of the ConnectionString property's provider-specific attributes
  • identify ways to open and close connections
  • recognize ways for handling connection events
  • recognize the code for handling typical exceptions
  • select a data provider
  • configure a connection
  • encrypt data and add a user instance
  • handle connection events
  • recognize the steps for creating a command to retrieve a single value from a data source
  • recognize the uses of DataReader properties and methods and the steps for retrieving a result set from a database
  • name the different ways of processing rows of read-only data
  • identify the code for using ExecuteXmlReader for returning an XML stream
  • work with Command objects
  • use a DataReader object
  • retrieve a single value from a data source
  • retrieve an XML data stream

Managing ADO.NET 4 Connections and Commands with Visual Basic 2010

ADO.NET connections and commands are crucial components of building data-driven applications. This course examines managing connections using connection pools and configuration files, as well as stored procedures, and using generic data-access code to establish a connection. Specific topics covered include optimizing ADO.NET connections and commands, ADO.NET transactions, and working with Multiple Active Result Sets (MARS) and asynchronous commands. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist: Accessing Data with Microsoft .NET Framework 4 Exam 70-516. Passing this exam will earn the learner credit towards the MCTS: .NET Framework 4, Data Access certification.
  • identify ways to pool connections
  • recognize the steps for retrieving a connection string from a configuration file
  • identify the steps for monitoring connection resources
  • recognize the code for using parameters with SQL statements
  • recognize the steps for using the ExecuteNonQuery method
  • identify the steps for creating a stored procedure with parameters
  • recognize how to use the DBProviderFactory, DbConnection, DbCommand, and DbException objects
  • identify the steps for using generic data access code to retrieve provider information
  • retrieve a connection string from a configuration file, based on a provider name
  • create a DBProviderFactory and DBConnection
  • create a DBCommand object
  • handle data source errors
  • recognize how the .NET Framework APIs can be used to configure transactions
  • identify the code for implementing implicit and explicit transactions and for managing concurrency
  • recognize the ways for managing and implementing transactions using the System.Transactions namespace
  • implement an asynchronous explicit transaction
  • implement an implicit transaction
  • implement concurrency
  • recognize the steps and considerations for enabling and using MARS
  • identify the code for using MARS to manipulate data
  • identify the uses of asynchronous design patterns in a given scenario
  • recognize how to poll an asynchronous operation, implement a callback, and monitor asynchronous operations
  • recognize the code for manipulating large objects
  • identify the code for moving large amounts of data
  • identify the benefits and uses of the SqlBulkCopy class
  • identify the code for populating a table-valued parameter
  • work with MARS, asynchronous commands, and special data types

Getting Started with ADO.NET 4 DataSets using Visual Basic 2010

ADO.NET DataSet objects allow developers to utilize cached versions of data when working within disconnected data environments. This course examines the various aspects of DataSets and their role as one of the key components of the ADO.NET architecture. Specific topics covered include creating DataSets with Visual Basic 2010, working with typed and untyped DataSets, and configuring typed DataSets and DataAdapters. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist: Accessing Data with Microsoft .NET Framework 4 Exam 70-516. Passing this exam will earn the learner the MCTS: .NET Framework 4, Data Access certification.
  • identify the scenarios in which it's appropriate to use the disconnected access model in ADO.NET
  • recognize the code for creating a DataSet, adding a DataTable to it, and setting column properties
  • enforce and remove unique constraints for a column or an array of columns
  • recognize how to programmatically fill an existing DataTable using a DataAdapter
  • identify how to use a DataAdapter object to retrieve data
  • recognize the steps for using the Fill method of a DataAdapter to page through query results
  • create an untyped DataSet and DataTable structure
  • enforce and remove unique constraints
  • use a DataAdapter to fill a DataSet and enable results to be paged through
  • recognize the steps for creating a typed DataSet
  • identify the steps for creating a TableAdapter, using the TableAdapter Configuration Wizard
  • recognize the different ways to create TableAdapters
  • recognize the steps for updating a TableAdapter
  • create a typed DataSet
  • create and configure a TableAdapter
  • add a query to a TableAdapter

Viewing and Navigating Data with ADO.NET 4 DataSets using Visual Basic 2010

The ability to view and navigate data in an efficient fashion is vital to any robust data application. This course explains how to accomplish this using ADO.NET DataSets and Visual Basic 2010. Specific topics covered include how to manage and constrain data relationships in a DataSet using DataRelation objects and ForeignKeyConstraints, and accessing and manipulating data using DataViews and the DataViewManager. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist: Accessing Data with Microsoft .NET Framework 4 Exam 70-516. Passing this exam will earn the learner the MCTS: .NET Framework 4, Data Access certification.
  • identify the steps for adding a DataRelation object and specifying settings for the ForeignKeyConstraint object
  • recognize the uses of DataRelation objects
  • recognize the steps for navigating a DataRelation object
  • create a DataRelation object
  • apply foreign key constraint rules
  • navigate related DataTables
  • recognize the code for using a DataTableReader to iterate over result sets
  • recognize the code for using the Select and Find methods to access DataTable data
  • use the Compute method to perform an aggregate calculation on a subset of DataTable columns
  • identify the steps for creating a DataView
  • identify the appropriate method to use to view, access, or locate data in a DataView in a given scenario
  • recognize the code for editing a DataView
  • identify the steps for using a DataViewManager to apply default and custom settings to a number of DataViews
  • create a DataView
  • edit a DataView
  • configure DataView settings

Updating ADO.NET DataSets with Visual Basic 2010

ADO.NET DataSets allow developers to easily update and manage data sources using Visual Basic 2010. This course examines how DataSets are used to update source data and also how to manage the integrity of the data being updated. Specific topics covered include updating data sources, committing changes to data sources, managing data integrity, and how to deal with data concurrency violations and exceptions. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist: Accessing Data with Microsoft .NET Framework 4 Exam 70-516. Passing this exam will earn the learner the MCTS: .NET Framework 4, Data Access certification.
  • identify different ways of inserting data into DataSets
  • identify the code for adding rows to DataSets
  • recognize the steps for loading a DataTable with rows from a data source
  • recognize the code for editing existing ADO.NET data
  • recognize how to commit or undo changes made to a DataSet
  • identify the code for filtering and merging DataTable changes
  • recognize the code for updating content with a DataAdapter
  • recognize the steps for updating content using a TableAdapter
  • recognize the steps for updating a DataSet within a transaction
  • change DataTable content
  • filter and merge DataTable changes
  • update changes to a data source
  • recognize the steps for validating data during row and column changes
  • identify the steps for handling DataTable errors
  • recognize the steps for implementing concurrency
  • recognize ways to handle update errors
  • use row and column events to validate data
  • handle DataTable errors in a given scenario
  • handle update errors and exceptions using DataAdapter events
  • update DataTable content

Synchronizing Data and Managing ADO.NET 4 Applications with Visual Basic 2010

Microsoft Sync Framework allows developers to create applications with the ability to display up-to-date data at all times. The course examines how to enable efficient, remote use of data using the Microsoft Sync Framework database synchronization API. This course also demonstrates how to deploy, monitor, and secure ADO.NET applications. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist: Accessing Data with Microsoft .NET Framework 4 Exam 70-516. Passing this exam will earn the learner credit towards the MCTS: .NET Framework 4, Data Access certification.
  • recognize the benefits and uses of synchronization as provided by the Microsoft Sync Framework database synchronization API
  • identify the architectural requirements for implementing client and server synchronization
  • recognize the uses and benefits of classes used in Synchronization Services
  • recognize the steps for creating synchronization tables and groups
  • recognize the steps for retrieving an anchor value and creating a synchronization adapter
  • recognize the steps for coding statistics and events
  • recognize the steps for building a basic synchronization-enabled application
  • recognize the steps for configuring the cache for synchronization using Microsoft Sync Framework
  • code the synchronization providers
  • code the synchronization agent
  • code statistics and events
  • call the Synchronization method
  • deploy standard ADO.NET applications
  • deploy Entity Framework applications
  • recognize key considerations when deploying WCF Data Services applications
  • implement tracing
  • view generated SQL
  • collect statistics
  • recognize key security considerations when designing ADO.NET applications
  • describe the cryptographic primitives used in application cryptography
  • use hashing and digital signatures
  • deploy a standard ADO.NET application
  • implement tracing
  • deploy an Entity Framework application
  • hash a password

Working with the ADO.NET Entity Framework 4 using Visual Basic 2010

The ADO.NET Entity Framework provides developers with the tools and framework elements they need to create unique, flexible data applications, while minimizing the amount of code required. This course explores the various ways you can employ the ADO.NET Entity Framework to develop and optimize data applications. Specific topics covered include Entity Data Models, ADO.NET Object Services, POCO support, the EntityClient Provider and Connection Strings, and WCF Data Services. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist: Accessing Data with Microsoft .NET Framework 4 Exam 70-516. Passing this exam will earn the learner credit towards the MCTS: .NET Framework 4, Data Access certification.
  • recognize the key features of the ADO.NET Entity Framework
  • create an Entity Data Model
  • create a database using an Entity Framework model
  • update the Entity Data Model using the Update Model Wizard
  • edit the .edmx file manually by adding a defining query
  • map entity model operations to stored procedures
  • create complex types
  • add a function to the .edmx file
  • complete the code to build an object query against the Entity Data Model
  • identify the code used to shape query results
  • identify how code is used to ensure changed data is written back to the data store and transactions are managed
  • identify the code used to customize data classes for use with an Entity Data Model
  • incorporate POCOs in a data model
  • |INS work with POCOs |/INS
  • recognize key code elements associated with the EntityClient Provider
  • recognize key Connection String parameters
  • generate an Entity Data Model (EDM)
  • complete an object query
  • perform coding task to ensure changed data is written back to the data store
  • use key classes and commands associated with the EntityProvider class
  • |INS create data services |/INS
  • |INS enable access to data services |/INS
  • |INS query data services |/INS

Using LINQ and XML with ADO.NET 4 and Visual Basic 2010

The .NET Language-Integrated Query (LINQ) provide developers common query language within ADO.NET applications, minimizing the amount of code required. This course explores the various ways you can use LINQ to develop and optimize data applications. Specific topics covered include LINQ to DataSet, LINQ to SQL and LINQ to Entities queries. The course also explores how XML data can be accessed and manipulated using ADO.NET applications, including coverage of LINQ to XML queries. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist: Accessing Data with Microsoft .NET Framework 4 Exam 70-516. Passing this exam will earn the learner credit towards the MCTS: .NET Framework 4, Data Access certification.
  • match the three ADO.NET LINQ technologies to their descriptions
  • recognize how to use the language features supported by LINQ
  • recognize the code used to perform different LINQ to DataSet queries
  • recognize how to create a LINQ to SQL query
  • recognize the steps for creating and executing a LINQ to Entities query
  • use XmlReader
  • use XPathDocument to query XML data
  • query XML with LINQ
  • write a LINQ to DataSet query
  • write a LINQ to SQL query
  • write a LINQ to Entities query
  • use LINQ to query XML
Register Now
Microsoft .NET Framework 4: Accessing Data with Visual Basic 2010 e-learning bundle
  • Course ID:
    252614
  • Duration:
    17 hours
  • Price:
    $249