====== Apache Derby ======
A tiny Java DB (2MB) deliered togehter with JDK.

== install ==
set environment var DERBY_HOME
<code>
DERBY_HOME=d:\path\to\jdk8x64\db\
</code>

and add DERBY_HOME\bin to Path environment variable


== start derby ==
<code>
$DERBY_HOME/bin/startNetworkServer
</code>

== create Database ==
Start queriing tool **ij**
<code>
ij
</code>

Create DB by connecting to it with **create=true**
<code>
ij> connect 'jdbc:derby://localhost:1527/Chapter01DB;create=true';
</code>

Create **customer** Table
<code>
ij> create table customer (custId int primary key, firstname varchar(20), lastname varchar(20));
</code>

Print **customer** Table
<code>
ij> describe customer;
</code>

Insert stuff into **customer** Table
<code>
ij> insert into customer values (1, 'Fred', 'Chene'); 
ij> insert into customer values (2, 'Sylvain', 'Verin'); 
ij> insert into customer values (3, 'Robin', 'Riou');
</code>

Count stuff in **customer** Table
<code>
ij> select count(*) from customer;
</code>