Antoine Eripret/Introduction to SQL for SEO

  • €49

Introduction to SQL for SEO

  • Course
  • 20 Lessons

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.  Master the mandatory SQL knowledge you need to work better as an SEO with this course !

Contents

Welcome to this course !

(READ BEFORE BUYING) - Is this course for you?
Preview
Loading our data

SQL basics

SELECT
Data Types
Common Operations for Numeric Values
Common Operations for Strings
Common Operations for Dates
WHERE (filtering)
ORDER BY (sorting)

Intermediate SQL

CASE (Conditional Statements)
Aggregate Functions
GROUP BY (Group Statistics)
JOIN

Advanced SQL

CTE and Subqueries
Window Functions

Let's practice !

Introduction
GSC
GA
GA + WC

Wrap things up

End of the course