Business Accounting
Communication
Database
Document Management
e-Commerce
Networking
Office Suites
Personal Finance
Presentation
Project Management
Reports & Forms
Schedule & Contact Management
Spreadsheet
Tax Preparation
Training & Tutorials
Word Processing
|
|
Designing and Implementing Distributed Applications with Microsoft® Visual Basic® 6.0- Part 3 CBT Training CD |
List Price:
Your Price: |
|
|
|
Product Info |
Reviews |
<< 1 >>
Rating: Summary: Designing and Implementing Distributed Applications ... Review: 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.
<< 1 >>
|
|
|
|