Video Course

MySQL and ExpressionEngine

by Ryan Irelan

You know ExpressionEngine but you want to take the next step and do something custom. This one-hour video is a primer on using MySQL and ExpressionEngine. Learn all of the tools available with ExpressionEngine, like the SQL Manager, Query Module and the CodeIgniter ActiveRecord class. Read the full description

What's in this Course?

This covers the legacy version of ExpressionEngine, version 2. Its content is not relevant for current versions of ExpressionEngine.
You’ve probably built several sites using ExpressionEngine. You have all the basics down. But sometimes the available ExpressionEngine tags don’t do what you need. Embrace the power and flexibility of ExpressionEngine by creating custom MySQL queries right in your templates.

This 58 minute screencast will walk you through all of the MySQL tools available in ExpressionEngine.

What You’ll Learn

The very basics of MySQL
Explore and access database tables right in the Control Panel
Test your queries using the SQL Manager
How to use the Query Module to create custom queries right in your EE templates.
Simple JOIN queries to connect multiple database tables together.
Write queries using the CodeIgniter ActiveRecord class and display data in your templates using PHP.

What is the difficulty level?

BeginnerExpert

This video is a beginner level introduction to MySQL and the tools available in ExpressionEngine. You should be experienced or at least familiar with building websites with ExpressionEngine.

How long is the training video?

This video is 58 minutes of guaranteed fun.

Where do I get the code you use?

All of the code for this screencast is available on the Code Download page.

What if I have a suggestion?

We love feedback about our training materials. Please get in touch and let us know what you think.

Get in touch

About Ryan Irelan

Ryan is the founder of Mijingo. He has authored numerous courses for people who build for the web. He's covered topics like Git, Craft CMS, website deployments, and more. He's been retained to teach developers at NASA, Canadian Broadcasting Corporation, University of Chicago, and more.