A programming language for managing data in databases. SQL in Joomla code, as in many other CMS, is used in combination with PHP to generate dynamic web pages.
Generation of dynamic pages can be represented as follows:
- The server receives a request to open a web document.
- The PHP script uses SQL queries to retrieve data from the database.
- Processes the received data, generating the HTML code of the requested page.
- The client receives the generated web document.
The main operations performed via SQL:
- creating new tables in the database;
- adding, changing and deleting records from tables;
- selecting records from one or more tables according to specified conditions;
- changing the structure of tables.
For manual administration of databases on web servers, the phpMyAdmin program is most often used.
For Joomla, there is an extension called DB Replacer, which allows you to execute database queries from the Joomla admin panel without using SQL syntax.