Video Course MySQL and ExpressionEngine

by Ryan Irelan


Buy Now

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.

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.

Ryan Irelan

About Ryan Irelan

Ryan is the founder of Mijingo and former Vice President of Technology at Happy Cog where he helped manage web projects for some of the most prominent brands in the world. Ryan has authored numerous courses for people who build for the web. He's covered topics like Git, Craft CMS, website deployments, and more. Ryan also authored the first book on ExpressionEngine 2.

MySQL and ExpressionEngine

$14.99 $7.49

What is the difficulty level?

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?

I love feedback about my training materials. Please get in touch and let me know what you think.

Customer Testimonials

  • They’re really clear, and I actually feel like I’m learning how EE works, not just repeating things monkey-like.

    Jodi Warren

  • I like things that make life easier in web design land. [T]hank goodness for Mijingo.

    Molly Bermea