Designing and Implementing Distributed Applications with Microsoft® Visual Basic® 6.0- Part 3 CBT Training CD

Features:

• Identify features of SQL Server and select the data integrity to implement in a given situation.
• Chinese, US English
• 6 to 8 hours
• NASBA credits: 4 CPE Credits, CEU credits: 0.70 CEUs

Customer Reviews:

Designing and Implementing Distributed Applications ... [Posted on 2004-10-26]
Course Overview
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.

Learn To

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.

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.

Deployment Options
e-Learning

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

Language Options
Chinese, US English

Total Learning Time
6 to 8 hours

Objectives
Unit 1: SQL Server in Enterprise Solutions 3 - 4 hours

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 3 - 4 hours

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.

Click here for more details and discount information...