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