Learn SQL for SEO analytics
The best platform to learn how to solve real world SEO problems with SQL.
SQL will supercharge your SEO

Career

The skills you learn analyzing data with SQL can be applied to almost any medium/large company you join in the future.

Self-reliance

Don't wait for others to complete your data requests. Skip the data breadlines and become an SEO analytics pro!

No tool limits

Don't be limited by what a tool can do. Combine company specific datasets and answer any data question you want.

Save time

Automate tedious manual spreadsheet reporting by building reproducible SQL queries that you can schedule.

Big data

Databases are capable of processing hundreds of billions of records which you would never be able to do in Excel. Learn how to do big data SEO analytics.

Hidden data

Find and analyze hidden datasets that you couldn't previously access.

We've taught some of the most data driven SEO teams
All the experience gained from teaching in-person analytics with SQL courses to SEO, product, marketing and operations teams have been incorporated into our online platform.
No tool limits
Self-reliance
"Bayan's data analysis with SQL course equipped me with the skills to combine datasets and answer real business questions that traditional tools couldn't. It totally changed the way I make data driven decisions. I can highly recommend it."
Brad Forster
Head of SEO
Domain Group
Big data
Career
"Bayan's SQL for data analysis course changed my workflow from basic spreadsheet analysis to powerful big data analysis. The real world examples and datasets let me see the value of SQL quickly and encouraged me to learn. I can't imagine doing my job without SQL in my skillset."
Tom Donohoe
Global SEO Manager
Finder
Big data
Save time
"Bayan's SQL course will transform the way you work with large datasets, especially if you're an in-house SEO working on enterprise level sites. Having no prior experience with SQL before the course, I can now get straight to the answers and insights that I need without having to tediously export multiple spreadsheets and stitch data back together. There's been so many different applications in my role where SQL skills have been incredibly valuable."
Karla Sumera
Senior SEO Manager
Domain Group
Save time
No tool limits
"Before taking Bayan's data analytics with SQL course I was doing a lot of manual reporting with Excel which I can now automate by scheduling SQL scripts. This gave me a lot more time to answer more business questions rather than being bogged down with day to day reporting. I particularly liked the real Google Analytics examples in the course and how I could join the user event tables back to company specific tables which meant that I could answer questions that nobody else had answers for."
Kristjan Smarason
Marketing Insights Analyst
Zip Co
Big data
Save time
Career
Self-reliance
"Bayan's courses were a game-changer for me. In the past, I was heavily reliant on spreadsheets and time-consuming manual processes, but as the amount of data exploded in our company, my lack of SQL knowledge was becoming a real problem. Upskilling in SQL helped me do my job better, and get access to the data I needed to without having to wait days or weeks for someone else to query the data. In-fact, Bayan's program put me on a path to a new career, from Marketer to Data Scientist. The courses are well-paced for non-technical users and the heavy focus on real-life business problems helped me stick with it. Bayan does a fantastic job of explaining complex concepts. I've seen first-hand how these programs can transform an organisation."
Clinton McNabb
Data Scientist (Former Marketer)
Domain Group
The easiest way for SEO's to learn SQL.
Learn data analysis with SQL in the most efficient way without having to watch hours of boring videos or read thousands of lines of text.
Stay motivated with rewards
A fun learning experience with rewards and streaks to keep you motivated.
Real world example problems
Learn to solve actual problems you will have at work with realistic and relevant datasets.
Improve quickly
A range of learning formats designed to increase the rate at which you acquire, retain and master key concepts.
Adaptive difficulty
The rate of progress is never too easy or too hard to keep you in a state of flow.
Core SQL Lessons
Learn SQL basics with SEO examples you can use in your job from day one.
Filtering data
Transforming data
Aggregating data
Merging data
Walk-through SEO tutorials
Step by step walk-through tutorials completed using our easy to use learning platform.
Server Logs
Analyze time to crawl a page using web server logs
Analyze page crawl proportion using web server logs
Learn to estimate your websites daily crawl budget using server logs
Website Crawled Data
Analyze and combine website crawl data (Eg: Screaming frog) with other company specific datasets
Advanced Analytics
Time series trend & seasonality analysis for organic traffic
Segmentation and clustering of organic users
Organic traffic forecasting
Acquisition page attribution modelling for organic traffic
Clickstream Data
Customizable channel attribution analysis
Year on year traffic analysis for SEO and metrics monitoring
Funnel analysis for organic traffic landing pages
Learn to estimate the revenue value of your SEO sessions by combining datasets
User page flow analysis and UX debugging for SEO
Build fully customizable organic search conversion cohorts
Finding anomalies in organic search traffic metrics
SERP Ranking Data
Analyze SERP ranking data to find low rank pages
Learn to write SQL queries to combine your ranking data with traffic data to provide URL level insights
Relevant Datasets
Learn to analyze datasets relevant to SEO.
Learn SQL with datasets that are relevant to your day to day job whether that's Google Analytics, web server logs, keyword rankings, sitemap data or search traffic data.
Intuitive Learning Format
An easy learning process.
Learn to build SQL queries gradually with a variety of question formats. Start being productive with SQL for data analysis at work from day one.
Choose Your Database
Learn the same SQL that's used at your work.
There are many different flavours of SQL with each slightly different. We've personalized your learning journey to match the database you have at your company whether that's Snowflake, Redshift, BigQuery, MySQL or PostgreSQL.
Interactive SQL Editor
Interactive editor built to learn data analysis.
An interactive editor that guides you with hints as you learn to write queries to solve your SEO analytics problems. Start off by editing and running pre-written queries. Once you've mastered a concept, learn to write the full query on your own.
Who is this course ideally suited for?
At least a junior level understanding of SEO concepts.
No necessary prior knowledge of SQL, start learning from the right spot if you already know the basics.
Looking to master advanced data analysis and SQL concepts.
Working for, or looking to work for a medium to large company with a SQL database.
Want to learn how to apply existing SQL skills to real world SEO problems.
Looking for a fast and efficient way to learn data analysis with SQL without having to watch hours of boring videos or read thousands of lines of text.
FAQ
When will the platform launch?
The learning platform launched as a private beta in 2020 and will be available to the general public in March 2021.
Is this course just for beginners?
No, if you've dabbled in SQL before but haven't mastered the concepts, then this course would be great for you too! If you've mastered SQL but want to learn how to apply it to SEO problems, then you can just skip straight to the guided tutorials.
If I don't like the course, can I get my money back?
Yes absolutely! We're so confident you will love our course and learning platform that there is a no questions asked 100% money back guarantee within 30 days of starting the course.
What is the format of the course? Are there videos?
The course is a learn at your own pace style course where you answer questions with gradually increasing difficulty. New concepts are explained and introduced as you progress through the questions. There are no boring videos to watch and no scheduled times to complete the course.
Who designed the course material?
Bayan Hammami has taught analytics using SQL to SEO, product, marketing, operations, editorial and finance teams. He previously led a data science team at Domain Group.
Can I access the other courses when they become available?
Yes, enjoy full unrestricted access for all material including new courses added.
What happens after my initial 12 months ends?
You will be charged at the normal rate of $19 per month. Don't worry, you can change your subscription before then and we will make sure to give you plenty of notice so there are no surprises.
Can I run this course at my company or for my team?
Yes, if you're interested in having a customized course for your company designed and deployed on our platform, please reach out to us at hi@supercooldata.com
Will there be new material added regularly?
Yes, we will regularly add new real world SEO problems and projects you can directly apply to your day job.
Who built the SQL learning platform?
Aiham Hammami is a software engineer who has built consumer facing applications used at some of Australia's largest companies.
Tell us what you think!
Is there a feature you want that's missing?
Want more detail about the course content?
Not an SEO specialist and want us to prioritise course content that's more relevant to you?
Interested in running this for your team or company?
Just want to give us constructive feedback or encouragement?
We'd love to hear from you for any reason! We (Bayan and Aiham) read every message and if you decide to provide your email address we'll respond immediately. Thanks!
Ready to be an SEO analytics pro?
Have any questions? Email us anytime at hi@supercooldata.com