In SQL, it seemed as though most of the tasks are manually done, someone has to perform the queries. Can it be automated?

Answer 1

SQL is basically just the interface language to access the database from elsewhere.

Most people probably use SQL from PHP. be warned though - it is very easy to open up your database to SQL injection, cross site scripting and other kinds of exploits. it's alright for learning purposes, but to create a secure application with PHP/SQL, you require a deep understanding of both.

if you just want to practice or play around, I suggest downloading XAMPP and learning PHP.
for a real application you might want to use a framework such as laravel or symfony.

however, you have options beyond php. Python for example can utilize SQL in many ways. web frameworks to check out would be Flask+SQLAlchemy, or Django for bigger projects.

anyway, most programming languages in use today probably allow accessing databases, and SQL is usually the means to do so. this allows interactive as well as automated queries by yourself and/or other users.

Answer 2

Thanks a lot. I will check out your recommendations.
Thanks for your time