Here is what you can expect to learn in each activity:

Activity 1:

Use the  ij tool to load the embedded driver and start the database engine. Create the database firstdb and the table FIRSTTABLE. Use a few basic SQL statements to insert and select data. The message log derby.log and the database directories and files are introduced.

Activity 2:

Use within a client/server configuration. Start the Network Server, which will embed the engine. In a separate process, use the  ij tool to load the client driver and connect to the Network Server. Create a database called seconddb and the table SECONDTABLE. Use a few basic SQL statements to insert and select data.

Activity 3:

Load the database engine from a simple Java JDBC program. Use the embedded driver to create the database jdbcDemoDB and the WISH_LIST table. Populate the table with text entered from the keyboard, then view a list of the records in the table. Walk through the code to understand the basic structure of a JDBC program that accesses a database. The CLASSPATH variable and connection URL attribute ;shutdown=true are introduced.

Activity 4:

Modify the Java JDBC program to load the client driver and connect to the Network Server. Compile the altered program and test that the program operates as it did in the previous activity.