As simple as 4 rules of code you can do create a mySQL statment for database interactions.

By default users cannot register unless you enable them to. This is a Joomla setting.

To make the default Joomla forms more secure, and safe from spammers, you can add a captcha to your Joomla site. This tutorial shows you how to do just that.

When writing a Joomla module or component, you can access the database with the JDatabase option.

Below you can find a script that loads the joomla 4 (only 4) framework on an external PHP page

Should you have a module installed that locks you out of your back office (for instance the IP block module), you can disable this in the Joomla database.