Visual InterDev 6: Database Interaction

Synopsis
Visual InterDev 6: Database Interaction explains how to use the Query Designer to retrieve and update information in the database.

Audience
This course is for web programmers who are interested in learning more about the Visual InterDev tools.

Time
6 hours

Product Code: VIDC05

After completing Visual InterDev 6: Database Interaction, the user should be able to:

Create queries

Change join types

Sort and Filter data

Modify database contents

Connecting with the Query Designer
Adding a new data connection

Viewing database objects

Accessing the query designer panes

Other query designer options

Creating a Query
Beginning a new query

Executing the query

Customizing Query Columns
Using the Grid pane to customize queries

Changing the names of the columns

Customizing Query Grids
Specifying the output

Searching for particular rows

Changing Database Contents
Creating an Update query

Creating a Delete query

Using the Results pane

This course has the following features:

Exercises that allow users to practice in Visual InterDev 6

Simulations that allow users to practice course skills, even if they don't have access to Visual InterDev 6

A course index

A glossary

A Skill Assessment