Intermediate VisualCafé
Database Edition

Our VisualCafé Database Edition 3.0 class delivers the latest and most powerful Java features to Java programmers and Web developers. This two-day hands-on instruction builds on the knowledge gained in the VisualCafé Professional Edition 3.0 one-day class and provides an interactive environment to demonstrate the features of VisualCafé Database Edition 3.0. Students will learn through the creation of a databound project using various windows, toolbars, wizards and other project customizing features.

1. The VisualCafé Environment

Identify key areas of the VisualCafé Environment

Create a JFC applet

Using Swing components

2. Create a Databound Project

Configure Database Connections

Create a Databound project

Modify and Save Your Databound Project

3. Develop Project X Using Stored Procedures

Develop Stored Procedures

Bind Parameters to Datasources

Change Individual Component Properties

Add Database Table

4. Access Databases

Create Master-Detail Projects

Create Master-Detail Relationship in Project X

Access Databases Using dbNAVIGATOR

Create JDBC Connection Using Connection Manager

5. Develop Query Navigator Projects

Create Query Navigator

Join Two Query Navigators

Create Databound and Non-Databound Components

6. Create Projects with Data Binding

Define JFC and Swing Components

Working with BinderModel and TableBindingModel

7. Query Data Using SQL and Query by Example

Create SQL Statements

Using SQL Adapter Components

Using the SQL Text Editor

Working with Query by Example

Input Masking versus Data Masking

Upon completion of the VisualCafé Database Development course,

developers will be certified in the successful application of:

relating databound projects

Configuring database connections

Querying VisualCafé projects using QBE

Creating master-detail relationships

Databinding databases to projects using dbNavigator

Developing filters and sorting data using SQL statements

Length: 2 Days

Students must attend the VisualCafé Professional Edition 3.0 one-day class prior to taking this course. Students must have an understanding of object-oriented programming languages and concepts such as GUI components, event models, interactions, classes and inheritance. Students should also have a basic knowledge of HTML and the Java programming language, including concepts such as syntax, properties, exceptions, applets and applications, inner classes and Java I/O. Students must understand SQL and client server models.