SQL Databases in Joomla

Crash Course on SQL Databases in Joomla

This class is targeted for people who have some knowledge of Joomla programming and would like to learn the basics of working with databases in Joomla. This is for beginner and intermediate level developers.

In a Joomla site, virtually all of your data is stored in a database. We will start with an overview of how databases work. Then we will learn how to:

• use phpMyAdmin to work with MySQL databases
• create database tables when we install an extension
• remove database tables when we uninstall an extension
• create queries to retrieve data
• learn about different join types for tables
• create queries to update and delete data
• debug database query problems
• use the JDatabaseQuery class in our Joomla code to build a query
• use the JDatabase class to run a query
• extend the JTable class to use custom tables with our Joomla forms

You will get the most from this class if you bring a laptop with access to a Joomla 1.7 site and phpMyAdmin. We will use an example extension with code that illustrates the concepts covered in the class.

Schedule:

• JoomlaDEVDay, Day 2, 10/23
• Time: 1:30 - 3:30
• Presenter:Mark Dexter

 Devday-sql (4.4 MB 2011-10-24 15:11:46)

Video streaming by Ustream