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.
