Magento Product collections is a great way of extracting and manipulating data without using complex SQL queries. Check out this list of the methods.
