I manage with quite simple INSERT INTO, DELETE FROM, UPDATE and SELECT statements, which are easy to learn and there are loads of sites dishing out tutorials in SQL.
When you have figured out your SQL sentence to retrieve the data you want, look in the other modules how to get the information out of the database in XOOPS