For Oracle, we use Oracle Developer. You can use it for both administration and development. There are also professional tools like Toad, but I don't have a license for that.
It's a native program from Oracle to access the database, create users, create tablespaces, and so on. You can work with Oracle Developer by connecting to the cloud or to an on-premises database. You can use the same tool. It just depends on where the database is hosted. You can host it on AWS, Microsoft, Oracle, or Google cloud.
I teach. My main projects are teaching projects. I do many English and German seminars all over Germany for big companies like Siemens, Mercedes, or IBM, teaching people the basics of databases in general and the specifics of Oracle database administration.
There are a lot of features in Oracle Developer. You can create tables, users, views, materialized views. You can also do data pump jobs to export jobs, export databases and dump files, create backup jobs, that sort of thing.
Users can usually integrate this tool with other solutions for development or management processes. There are different connections you can create. For example, with Office applications, you can connect to the database. Or if you're programming in Java, you can use a JDK connection to retrieve data from the database and read, store, or update records.
For security, everything's perfect. You can use an SSH connection if you're accessing a server in the cloud, or you just have a normal IP connection if you're running your database on the local network.
