Activity 1: Run SQL using the embedded driver

In this activity, you will use the embedded driver to load the Derby database engine, create and connect to a database, and use some basic SQL statements.

1. Create a directory and copy scripts into the directory
2. Create a Derby database and run SQL statements

• Creating a directory and copying scripts into the directory
  To help you complete this activity, you must create a directory and copy several scripts into the new directory. You will use these scripts to quickly add tables and data to a new Derby database.
• Creating a Derby database and running SQL statements
  Now, you will use the Derby ij tool to load the Derby database engine. You will use the Derby embedded driver to create and connect to the firstdb database. You will also use a few basic SQL statements to create and populate a table.