Kurs 72617 - Microsoft Visual C++ 6.0: Designing and Implementing Applications - Part 8 - Online

Unverbindlich in kontakt treten Zentraler Informatikdienst

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

Informationen über Kurs 72617 - Microsoft Visual C++ 6.0: Designing and Implementing Applications - Part 8 - Online

  • Ziele
    - Create a database, maintain data integrity and import data. - Write SQL statements to access data from tables and manipulate the data. - Implement data access in applications through stored procedure model and cursors. - Create transactions and implement locking strategies.
  • Anforderungen
    This course is designed for programmers looking to develop applications using MFC library and Microsoft Visual C++. Participants should have completed the first seven courses in this series.
  • Titel
    Kurs 72617 - Microsoft Visual C++ 6.0: Designing and Implementing Applications - Part 8
  • Inhalt
    Deployment Options

    Self-Study

    Objectives

    Unit 1: Creating and Accessing Databases - 4 hours

    - Identify the features of SQL Server 7.0.
    - Identify the features of physical database architecture components.
    - Modify the properties of a database by using Enterprise Manager.
    - Create a table by using Enterprise Manager.
    - Create an index by using Enterprise Manager.
    - Create a relationship between two tables to enforce referential integrity.
    - Import data from an external source by using Enterprise Manager.
    - Access data from a single table by using the SELECT statement.
    - Access data from multiple tables by using joins with the SELECT statement.
    - Create summary queries to display data in customized sorted format.
    - Modify the data contained in a table by using SQL statements.
    - Create a view for restricting access to the specific columns to tables by using Enterprise Manager.
    - Identify the features of the ODBC data access technology.
    - Identify the features of the RDO data access technology.
    - Identify the features of the OLE DB data access technology.
    - Identify the features of the ADO data access technology.

    Unit 2: Implementing Data Access in Applications - 4 hours

    - Set up data source for SQL Server.
    - Match the ODBC handles with their features.
    - Sequence the steps associated with connecting to a data source.
    - Sequence the steps to disconnect from a data source.
    - Identify the advantages of stored procedure access model.
    - Access data by using the stored procedure access model.
    - Create a trigger to ensure referential integrity.
    - Create a stored procedure that returns information.
    - Identify the features of cursors.
    - Identify the appropriate type of cursor that can be used in a given situation.
    - Create a cursor to access data from a table.
    - Match the fetch options with their functions.
    - Update data by using a cursor.
    - Close a cursor by using the SQL statement.
    - Identify the features of a transaction.
    - Create a transaction for the specified set of tasks.
    - Match the types of locks with their uses.
    - Identify the situations in which the locking strategies are implemented.

    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 "microsoft" stehen

Diese webseite verwendet cookies.
Wenn sie weiterhin auf der webseite navigieren stimmen sie der nutzung dieser zu.
Vehr sehen  |