Joomla is a beautiful CMS to create dynamic websites. The CMS consists of PHP files for operation, HTML for display, CSS for layout and JavaScript for additional functionality in the browser and it's content is stored in a MySQL database.
Peter Martin talks about SQL databases in general and the Joomla 4 database in particular.