 | Level: Introductory Gregory Scott (glscott1@us.ibm.com), Senior Learning Specialist, IBM
28 Mar 2006 This is the fourth in a series of seven tutorials created to help
you prepare for the IBM Certification Test 255, Developing with IBM Rational® Application Developer for WebSphere® Software V6. This tutorial uses the Data perspective in Rational Application Developer 6. It shows you how to connect from Application Developer to the database, sample the data from within Application Developer, and use
visual tools to create SQL statements and to run them.
Objectives
Application Developer offers the ability to work easily with databases without having to open other tools, and this tutorial highlights the
relevant features. After completing this tutorial, you should be able to create a database instance, tables, columns, and primary and foreign keys along with some sample data, from within the Data perspective and directly from within Cloudscape, the database that comes with
Application Developer. You should also know how to connect from Application Developer to the database, sample the data from within Application Developer, and use visual programming features to create SQL statements and to run them. Finally, you should be able to use JDBC in a servlet originally created in Tutorial 3 to retrieve data from the tables that you created and populated.
Prerequisites
This tutorial assumes you have gone through the three previous tutorials in this series or have equivalent knowledge with Application
Developer. A basic grasp of relational database fundamentals is helpful, but not required.
System requirements
To run the examples in this tutorial, install Rational Application Developer for
WebSphere Software or Rational Web Developer for WebSphere Software.
Download a free trial version of
Rational Application Developer for WebSphere Software if you don't have it installed.
The hardware and software requirements for this software can be located at
IBM Rational Application Developer System Requirements.
Duration
Under two hours
Formats html, pdf
| | | |
