Microsoft® Visual C++® 6.0: Designing and Implementing Applications- Part 8 CBT Training CD

Rating:
Summary: Microsoft® Visual C++® 6.0: Designing and Implementing...
Review: Course Overview
This is the final course in an eight part series for programmers. This series provides the C++ programmers the necessary skills to develop applications using the MFC library and the Microsoft Visual C++ 6 development environment.

Learn To

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.

Audience
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.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs

Language Options
US English

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Creating and Accessing Databases 3 - 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 3 - 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.