There is a gap in the industry between how data-driven it seems to be, and how it really is. Why? Because most people lack the skills to generate meaningful insights from the data at our disposal. 

While coding awareness is rising, there is a misconception about what matters: generating a script is fairly easy (especially with ChatGPT), but using this ability to generate powerful insights for a project is harder. And this is what marks the difference between a commodity and a well-compensated skill. 

I’ve been using SQL & Python for SEO since 2018. While I’ve been using it wrong at the beginning, I’ve come to understand how these two languages, if used correctly, can help you work faster and/or better. I still use Excel every day, but my most valuable insights do not come from this tool anymore.

In this course, I want to teach two things: 

  • The mandatory SQL knowledge you need. This is not a complete course on this language, but we’ll get through the basics to ensure that you can start crunching your data by yourself. I'll skip concepts that are not mandatory as a SEO, based on my current usage at my daily job.

  • Some simple (and not so simple) applications of this knowledge using first-party data from Screaming Frog, GSC and GA.

NO PRIOR SQL KNOWLEDGE IS NEEDED TO FOLLOW THIS COURSE.

This course is for you if: 

  • ✅ You’re curious about what data analyst skills can bring to your SEO career

  • ✅ You master Excel, but you’re often facing issue due to the limited number of rows it can hold

  • ✅ You're tired of asking your data team to perform simple analysis for you

This course is not for you if: 

  • ❌ You're looking for a comprehensive SQL course. This is not the aim of this course and if that's your objective, the course won't cover plenty of topics.

  • ❌ You already master main SQL concepts (GROUP BY, HAVING, JOIN, CTEs ...). While this course is SEO-oriented, most of it is an explanation of these concepts. If you already know them, you'll find little value in this course.

  • ❌ You would like to learn SEO. SEO knowledge is assumed for this course.

  • ❌ You’re not willing to spend some time learning the basics of a programming language. ChatGPT is great to speed things up, but you still need to master the basics.

The course is listed at €49 but note that based on your country, VAT might be added during the checkout. I'm based in Spain; hence it affects mostly EU countries.