I want to learn how to manage data bases with libre software

Hi everyone, how are you?

I'd like to start learning about the administration of small, simple data bases, following a practical approach, i.e., I don't want to learn just theory about DB and the software used to manage them, but I want to learn the whole cycle, from the theory about designing of the data base, to the deployment and the elaboration of GUI for letting the people with no knowledge on the topic, to enter data, as well as to generate queries and reports.

What I have in mind is to be able of design, deploy and manage, as well as to teach how to manage, small and simple data bases applied to the protection of the environment using GIS in small communities in South America. I'm not interested in complex systems multiuser with remote access: a local database managed by one person, ready to be used by nono-specialist people (in local too), in order to enter and query information seems to be enough for me at this point. However, even if the data bases themselves are going to be simple, it's quite desirable the posibility of including multimedia in the databases: images, audio and video.

Taking into account the foregoing requierements, I'd like to ask your kind help about the topic; specifically, as I have red, I think I need:

1. A program to manage the database (following my online research, SQLiteStudio + SpatiaLite could be what I need).

2. One or several programs used to make the GUI used for the people to enter and query or generate reports. As far as I've red, SQLite is able to manage BLOB data type, which will let me to ingress multimedia files (I already did succesfully the test with images in SpatiaLite), but I don't know what program would let me to access to the multimedia files in order to query or to generate reporta. I tested two GIS programas (QGIS and gvSIG) but they don't understand the BLOB field.

3. Documentation about relational data base design and about the use of the programs mentioned in the numerals 1 and 2: books, tutorials, videos, courses, etc. The most important thing for me now is to follow a practical approach, as I mentioned above.

The documentation could be in English, Castilian, Portuguese or French. By the way, please excuse my English mistakes.

I indeed appreciate your kind suggestions, your time and your attention.

Libre hugs for all of you.