I have always loved to share my passions, and Joomla is one without a doubt! For me sharing knowledge is natural, and whatever our level, we still need another person to accompany us, support us and help us make progress, as well as help us know our stuff when it comes to teaching others.
Using Joomla! by Ron Severdia and Jennifer Gress is an excellent reference for anyone looking to build and maintain their own website using Joomla 3. The authors' use of practical advice and hands-on exercises takes the reader through the real-world process of building and optimizing a Joomla site.
Joomla is an open source content management system which based on PHP and MySQL. You can work with it both online or offline. However, managing Joomla offline requires you to install a compatible web server and the Joomla package as well. Below are instructions to install Joomla on XAMPP - a good web server which can work well on local machine. This is an extract from the free ebook "Joomla 3.0 Made Easy".
Andrea Tarr’s book “PHP and MySQL 24-Hour Trainer” is a great educational tool for anyone who wants to learn how to work with PHP and MySQL. If you believe that programming books are generally dry, convoluted and hard to understand, you will be very pleasantly surprised by the neat, well-structured, and accessible way this book deals with its subject matter.