Designing and Implementing Distributed Applications with Microsoft Visual Basic 6.0 - Part 3

Course Code NGE72597

Contents

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Objectives
6. Topics Include
7. Duration
8. Minimum Requirements
9. Media

Screenshot

Description

This is the third course in a five part series that will provide programmers with the basic skills to build three-tier client/server solutions.

Audience

This course is designed for programmers using Visual Basic 6.0 and are currently building desktop applications and accessing corporate databases. Participants should have completed the first two courses in this series.

Prerequisites

(Currently no course prerequisite information)

Objective

• Identify features of SQL Server and select the data integrity to implement in a given situation.
• Use the ActiveX Data Object (ADO) types for establishing a connection, executing a command, navigating recordsets, modifying data and executing stored procedures.

Topics Include

Unit 1: SQL Server in Enterprise Solutions

• Identify the features of SQL Server that make it suitable for an Enterprise Solution.
• Identify the Data Integrity type to implement in a given situation.
• Identify the SQL commands to declare and assign values to variables.
• Identify the result of Flow-of-control statements in SQL.
• Identify the query command that retrieves data from joined tables.
• Add a Data Environment to a Visual Basic Project using the Add Data Environment command.
• Establish a connection to a SQL Server database using the Data Link Properties dialog box.
• Display the structure of a SQL Server database.
• Create a SQL Stored Procedure.
• Display the T-SQL Debugger for debugging a SQL Stored Procedure.
• Identify the use of delimiter commands in SQL Transactions.

Unit 2: Accessing Data from the Middle Tier

• Identify the objects and collections in the ActiveX Directory Object (ADO) hierarchy.
• Establish a connection with a data source by using the Connection object.
• Create an error handler for errors that may be returned while connecting to an external data source.
• Identify the code that uses a command object to execute a SQL command.
• Create a recordset from a Connection object.
• Identify the combination of cursor type and cursor location best suited in a specific situation.
• Identify the properties and methods that you will use for navigating a recordset in a given scenario.
• Identify the lock type best suited for a specific situation.
• Modify data in a SQL Server database by using the Connection object to directly execute SQL statements.
• Modify data in a SQL Server database by using the Prepared property of the Command object.
• Modify data in a SQL Server database by using a Recordset object.
• Create a disconnected recordset.
• Submit the changes from a disconnected recordset to a database.
• Identify the practices that improve the code performance while coding in ADO.
• Retrieve a recordset by invoking a stored procedure.
• Call a stored procedure to access the return code and output parameters.
• Create parameters for a stored procedure.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently, only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media