Home > Kurse - Seminare > Visual Basic (VisualBasic) > Online > Kurs 73248 - Microsoft Visual Basic .NET-Distributed Applications Pt 3: Data Access - Online

Kurs 73248 - Microsoft Visual Basic .NET-Distributed Applications Pt 3: Data Access - Online

Unverbindlich in kontakt treten Zentraler Informatikdienst

Um die Anfrage zu senden, müssen sie die Datenschutzpolitik akzeptieren

Informationen über Kurs 73248 - Microsoft Visual Basic .NET-Distributed Applications Pt 3: Data Access - Online

  • Ziele
    - To identify features of ADO.NET. - To identify benefits of ADO.NET. - To sequence the steps to read data from a database in a connected environment. - To identify features of DataSets. - To identify the syntax for creating a DataSet programmatically. - To identify the syntax for saving a DataSet. - To identify features of XML Schema Definition (XSD). - To generate an XML Schema Definition (XSD). - To identify methods of loading schemas into DataSets.
  • Anforderungen
    This course is aimed at database administrators, application developers, systems analysts, and software engineers. Typically, students will may be working in a medium to large development environment that uses Microsoft Visual Studio .NET, Enterprise Developer Edition. Candidates should have at least one year of experience developing middle-tier components. Candidates should also have a working knowledge of Microsoft Visual Basic.NET.
  • Titel
    Kurs 73248 - Microsoft Visual Basic .NET-Distributed Applications Pt 3: Data Access
  • Inhalt
    Course Description

    The Microsoft Visual Basic .NET-Distributed Applications Pt 3: Data Access course teaches learners how to consume and manipulate data by using ADO.NET.

    Deployment Options

    Self-Study

    Objectives

    Unit 1: SQL Server Data Access Using ADO.NET 2 hours

    - Identify features of ADO.NET.
    - Identify benefits of ADO.NET.
    - Sequence the steps to read data from a database in a connected environment.
    - Identify features of data provider classes that are used in a disconnected environment.
    - Identify methods of using XML in ADO.NET.
    - Identify features of SqlClient namespace classes.
    - Identify the syntax for using a SQL Server connection object.
    - Identify features of SqlCommand objects.
    - Identify the syntax for retrieving data using a SqlDataReader object.
    - Sequence the steps for calling a simple stored procedure.
    - Sequence the steps for calling a complex stored procedure.

    Unit 2: DataSet Creation and Manipulation 2 - 3 hours

    - Identify features of DataSets.
    - Identify the syntax for creating a DataSet programmatically.
    - Identify the syntax for saving a DataSet.
    - Identify the steps to populate a DataSet by using the DataAdapter object.
    - Identify ways of updating data in DataSets.
    - Sequence the steps for creating a typed DataSet.
    - Sequence the steps for replicating the changes made to a DataSet to a data source.
    - Identify the syntax for accepting changes into a DataSet.
    - Identify options in the Data Adapter
    - Configuration Wizard for detecting conflicts.
    - Identify strategies for resolving conflicts.
    - Identify the syntax for creating a primary key constraint.
    - Identify the syntax for creating a foreign key constraint.
    - Identify features of unique constraints.
    - Identify the syntax for creating a custom expression.
    - Sequence the steps for creating a DataRelation object.
    - Identify the syntax for navigating related DataTables.
    - Identify RowState property values used to track DataRowState changes.
    - Identify the functions of data modification commands.
    - Identify the steps for setting a data modification command using the Data Adapter Configuration Wizard.
    - Identify the syntax for using the GetChanges method.

    Unit 3: Accessing XML Data 2 - 3 hours

    - Identify features of XML Schema Definition (XSD).
    - Generate an XML Schema Definition (XSD).
    - Identify methods of loading schemas into DataSets.
    - Create an XML file based on a schema using the Visual Studio XML Editor.
    - Add data to an XML document.
    - Match XmlReadMode values for loading XML data into DataSets with their descriptions.
    - Match the .NET XML classes used for accessing an XML file using the Document Object Model (DOM) with their descriptions.
    - Identify the syntax for querying XML data using XPath.
    -  Match the XmlValidatingReader ValidationType property types with their descriptions.
    - Identify the syntax for writing an XML schema to a file.
    - Identify the code used to write data from a DataSet to an XML file.
    - Identify the syntax for writing DataSet changes using DiffGram.

    Course Access

    Each student has access to the course for a period of 6 months from the day of enrollment in the course.

Ähnliche Angebote die in Bezug zu Ihrer Anfrage "Visual Basic (VisualBasic)" stehen

Diese Webseite verwendet Cookies. Wenn Sie weiterhin navigieren, verstehen wir das Sie der Nutzung einverstanden sind. Vehr sehen  |