I use MySQL on a daily basis. Most web developers connect to databases using GUI's such as phpmyadmin or MySQL query browser.
This article will briefly explain how to use the command line to backup your databases, making it easy to automate your tasks using bash scripts.
This is a brief introduction to PHP sessions. Creating sessions are very easy! Frameworks and CMSes usually have a built in class to handle PHP sessions, but today I was working on a project which didn't have such a class. Also this is a good article if you are just learning PHP. I wrote this article back in 2005.
Don't make the assumption that Joomla module positions have to be displayed in the template.
Modules can be displayed from within the article content using Joomla.
This article briefly describes how to display a module inside your content.