My requirements are
Please do suggest me a database with the above mentioned features and some pointers to good tutorials regarding that.
I'd suggest HSQLDB. Looking at tutorials of frameworks like Spring and Hibernate, they tend to use HSQLDB as an example of how to use an embedded database with them.
You can use JPA with it, I've personally tried with Hibernate and have had some great results. It's used in projects such as OpenOffice and Mathematica, so that should speak of its quality.
HSQLDB fits 4 of your 5 requirements. Maybe 5 of 5, only because I don't use Netbeans as my IDE. But I'm sure you can try it yourself.