Here's a quick JDBC with HSQLDB tutorial to get you up and running with Java database connectivity and the popular HyperSQL database.

An introduction to Cosmos DB data architecture If you are using Azure Cosmos DB alongside a relational database, it makes sense to use SQL for both.