Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases SQL Basics Data, Databases and SQL Why This Course?

Obayanju Damilare
Obayanju Damilare
3,383 Points

SQL for WORDPRESS THEME DEVELOPMENT

Hi, I wanted to ask if I need SQL to learn WordPress Theme Development. Thanks for your answer in advance:)

2 Answers

Sue Dough
Sue Dough
35,800 Points

Shadd is wrong. It depends on the theme and what it does. The WordPress native functions/classes like wpdb simply allow you to write less code but you'll still need to know MYSQL to write queries. If you are doing any database work in your theme it is a must.

Source: https://codex.wordpress.org/Class_Reference/wpdb and I worked on big WordPress projects before.

For developers, most of the time they use SQL, they're not even aware they're using it. I'm not all too aware of WordPress, but I know that most of the time you'll ever save anything to a database, there's already an API that does it for you without you ever having to write a single line of SQL. You can create custom queries for specific things, but the basics are often already implemented.

All that being said, having a basic working knowledge of SQL can't hurt, especially if you want to better understand what these APIs are doing behind the scenes, and to help you write those custom queries.

Hope that answers your question :)