Thanks to everyone who attended my session at the 2016 Joomla World Conference in Vancouver, B.C., yesterday. For those who attended, and for those simply interested in learning a bit more about Joomla's class for handling database queries, this article will present the video and also the course notes for you.
Here's the video:
And, for the course notes:
Here is a direct link to the presentation entitled "Leveraging the JDatabase Class".
This is a pretty good intro, IMHO, to working with database queries within the Joomla! context, and includes a mini course library with code examples that should be easy to copy/paste/test. So, go there, get coding, and have fun! Let me know if you run into any questions, etc.