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

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