Sakila Database Example for MySQL

Schema Design and Sample Queries for Mysql sample db.

Data analysis for the Sakila Database which is a nicely normalised schema modelling a DVD rental store, featuring things like films, actors, film-actor relationships, and a central inventory table that connects films, stores, and rentals using tools like Excel used to view the data and create insert queries for all the tables and then by using SQL

Connection and quering to MySQL Sakila and World databases via Java app

Java Web App with Quarkus and JPAStreamer

With SQL queries I explore the Sakila DVD Rental database, to present insights about customer behavior and rental patterns.

Queries to learn sql

Like JDX_ReverseEngineeringExample but generates JSON-capable container classes extending JDX_JSONObject instead of POJOs, and produces a JSON-aware .revjdx mapping using VIRTUAL_ATTRIB. Compatible with JDX ORM, Gilhari ORM, and MCP server deployments.

🔄 Reverse-engineer JSON models from relational databases using JDX ORM, demonstrating compatibility with multiple frameworks through the Sakila sample database.