SQL for People Analytics

Stop asking for the data.
Write the query yourself.

SQL coaching for HR practitioners and I/O psychology graduates. Live sessions, homework on a synthetic HR dataset, and your work read line by line — not marked right or wrong.

Practice tool
Free, no signup
Coaching
Live 1:1
Every month
2 learning + 2 review
Dataset
9 linked HR tables
The practice tool

Nine HR tables. No signup.

A SQLite database that runs in your browser, preloaded with a synthetic HR schema. Write a query, run it, see the rows. Nothing to install, no account, no email.

// dataskillup · sql practice
Tables
employees
candidates
applications
job_postings
interview_stages
performance_reviews
survey_questions
survey_responses
question_responses
Run query
Open the practice tool // free whether or not you ever talk to us
Why SQL

You know which question to ask.
You just can't reach the data.

It comes up in a leadership meeting. Is there a pay gap by level? Which managers are losing people fastest? Where does the hiring funnel actually break? You know exactly what would answer it.

What you don't have is a way to get to the numbers without filing a request and waiting. So you wait — and the answer arrives shaped by whoever pulled it. A spreadsheet you didn't design, cut the way someone else thought was useful, two weeks after the meeting that needed it.

SQL is the shortest way out of that. Not because writing queries is impressive, but because it removes the dependency. You ask the question, you pull the answer, you check it yourself.

Who it's for

For people who own the question but not the database.

HR business partners

Answering leadership questions without a two-week wait on a data request.

New to people analytics

Expected to produce the numbers now, not just interpret someone else's.

I/O psychology graduates

Strong on method and statistics. This is the part the programme skipped.

HR teams with no data function

At a startup or NGO where nobody else is going to pull it for you.

What you'll be able to answer

Real questions. Not toy exercises.

The problems are the kind leadership actually asks. The dataset is synthetic — built to mirror the structure of an HRIS, with nothing from a real organisation in it.

Question · 01

Is there a pay gap by level?

Aggregate salary and bonus across level, tenure and department. Find where the gaps sit, how wide they are, and which ones survive once you control for level.

GROUP BY · HAVING · CASE
Question · 02

Which managers are losing people?

Join employees to their managers and their review history. Rank attrition by team, and separate the managers with a problem from the ones with a big team.

self-joins · window functions
Question · 03

Where does the hiring funnel break?

Trace candidates through applications and interview stages. Find the stage that drops the most people, and whether it drops them evenly across sources.

multi-table JOINs · CTEs
What you'll learn

Four stages. SELECT to window functions.

Most people start at stage one, and that's the normal place to start.

Stage 01

Querying and summarising one table

SELECT, WHERE, ORDER BY, then GROUP BY and HAVING. Counting, averaging and filtering groups — and getting comfortable with being wrong in a way you can see and fix.

Stage 02

Combining tables

INNER and LEFT JOIN, self-joins, UNION. Employees to reviews, candidates to applications, and the three- and four-table chains that answer a real question.

Stage 03

Window functions

Rankings, running totals, and comparing a row to the group it sits in — without collapsing the rows. Includes the decision rule for when a window function beats a GROUP BY, and how ROWS and RANGE frames differ.

Stage 04

Putting it all together

One real analysis end to end: summarise, join across four tables, and use a subquery or CTE to hold the middle steps. The point is producing an answer you'd be willing to put in front of leadership — and a query someone else can read, including you in six months.

// every stage practised on the same synthetic HR dataset
How the coaching works

Your work, reviewed line by line.

This is not a course. There are no pre-recorded videos to work through at your own pace, and no checker that tells you "correct" without telling you why.

You write queries against real HR problems. We read them, line by line, and tell you what's working, what's fragile, and what would break the first time the data changed. That's how analysts actually learn.

01

Intake call

A short call to place you. What you've done before, what you need to be able to answer, which stage to start at.

02

Learning session

Live, working the concept through on the synthetic HR dataset. Up to two a month, booked at your cadence.

03

Homework

A question set on the same data, built around problems HR roles actually get handed. No answer key to peek at.

04

Code review session

We read your queries line by line. Not marked right or wrong — read, so you know why the working one works. Up to two a month.

05

Async support in between

Message us when you're stuck. You don't sit on a broken query for a fortnight waiting for the next session.

From past learners

What people say about working with DataSkillUp.

Quotes from DataSkillUp learners.

"What I initially expected to be a challenging learning curve turned out to be a surprisingly smooth experience. Aaron and Abhinav made learning SQL feel almost like a cakewalk."
SG
Shalin Gehlot ↗
SQL · People Analytics
"Their sessions are very practical and grounded in real-life examples. They're straight to the point — definitely not just another lecture with slides."
AR
Alessandra Rigardo ↗
HR Analytics
"From the beginning, I could tell they were not only knowledgeable but also genuinely passionate about teaching. They created an environment where no question was too small."
SM
Shannon Moran ↗
HR · Coaching
Pricing

Coaching that fits around your job.

Sessions booked at whatever cadence your calendar allows.

SQL for People Analytics
Live coaching · code review · synthetic HR data
// per month
$399
billed monthly
  • Up to 2 live learning sessions a month
  • Up to 2 code review sessions a month, line by line
  • Async support between sessions — message us when you're stuck
  • Question sets on synthetic HR data, written for HR roles
  • Recorded sessions to go back to
  • Learning slides and reference material
  • Full access to the SQL practice tool
  • Certificate of completion
Start a conversation →
// No pressure call
Common questions

Questions before you start.

No. Every dataset you work on here is synthetic. It's built to mirror the structure of an HRIS — employees, candidates, applications, job postings, interview stages, performance reviews and engagement surveys — so the queries you write are the queries you'd write at work. But nothing in it comes from a real organisation, and no real person's information is involved anywhere in the tool or the coaching.
No. Open the link and query.
Yes. It's open, there's no account, and we don't ask for your email. Use it as long as you like whether or not you ever book a session with us.
No. The practice tool runs entirely in your browser.
Plan on 2–3 hours of homework between sessions. It's a question set, not reading — the time is spent writing queries and getting them wrong a few times, which is the part that actually teaches you.
A course gives you videos and an automatic checker that says right or wrong. This is 1:1 — a person walking you through the underlying concepts, so you understand why a query is built the way it is rather than copying a pattern. Then reading your own queries back to you: what's working, what would break on a bigger table, what a reviewer at work would say about it. The exercises are written for HR data specifically, not generic sales tables.
Yes. You get a certificate of completion you can share on LinkedIn, in interviews, or with your employer.