PICARDI ACADEMY  ·  LEARN SQL BY DOING THE JOBpicardiacademy.com
P
Picardi Academy
SQL practice that acts like a job
$1 first month · then $5/month · everything included

Hold a data-analyst job. Answer your inbox in SQL.

The Job Simulator hands you an inbox of requests from colleagues — real, loosely-worded asks. You reply with a query, graded against live data. Miss a skill often enough and it builds you a lesson aimed right at it.

No install · runs in your browser · real MySQL 8 · 120 learners registered

8
Industries
12
SQL skills scored
Live
Graded on real data

The Job Simulator

It's a job, not a problem set.

Requests arrive the way they do at work — a sentence or two from someone who doesn't know or care how the database is laid out. You read it, work out what they actually need, and write the SELECT. It runs against the company's real tables and your result is checked column by column, order-independent. Some come in urgent, on a countdown. Keep your reputation up and you level up; let it slide and you get let go and pick a new job.

The request

Hey — can you pull the ten branches that opened the most new checking accounts in the last 30 days? Just the branch name and the count, highest first. Thanks!

— Renée, Deposits team

Your reply
SELECT b.branch_name, COUNT(*) AS new_accounts
FROM   bank_accounts a
JOIN   bank_branches b ON b.branch_id = a.branch_id
WHERE  a.account_type = 'checking'
  AND  a.opened_date >= CURRENT_DATE - INTERVAL 30 DAY
GROUP BY b.branch_name
ORDER BY new_accounts DESC
LIMIT  10;

Not sure what they mean by “new”? Reply to the colleague and ask — or, in the full simulator, open an intake call and ask as many questions as you want before you answer.


Why it works

Closer to the actual job.

Most SQL practice hands you a prompt, the exact columns to return, and a schema diagram. Real analyst work gives you none of that — and neither does this.

A request, not a specA sentence or two from a person. Working out what they actually mean — and which of the eight tables it lives in — is half the skill.
Figure out the schemaThe tables are yours to explore from a rail on the side. No ER diagram handed to you, same as day one at a new job.
Graded on live dataYour query runs. The result is diffed against the right answer column by column, order-independent. SELECT * passes; a missing column fails and names it.
It teaches what you missThe moment it sees a pattern of wrong answers on a skill, it writes you a lesson on that skill — against the same data.

Pick your industry

Eight companies to work for.

Each is a full database of its own. Switch jobs any time — your level carries over.

RetailAn e-commerce retailer — customers, products, orders, order lines.
Restaurant groupMenus, staff, shifts, daily sales, reservations.
Real estateA brokerage — agents, listings, closed sales, open houses.
Retail bankBranches, accounts, loans, transactions.
People analyticsA company HR team — departments, employees, salaries, reviews.
UniversityStudents, courses, enrollments, grades.
HospitalPatients, doctors, appointments, diagnoses.
Health insuranceMembers, plans, claims, prior auth, appeals, premiums.

How it works

The simulator is the teacher.

1

Work the inbox

Pick an industry, clock in, and answer each request with a SELECT against the company's database. Difficulty adapts to how you're doing — level 1 through 5.

2

It spots what you miss

Every request is tagged with the SQL skills it needs and every reply is graded. The sim keeps a running mastery score per skill, so it knows which ones keep tripping you up.

3

It builds the lesson

When a skill is clearly weak it generates a short lesson aimed at exactly that — a plain-language explanation, a worked example, and graded exercises against the same data. Clear it and your mastery jumps.


SQL Lessons

Lessons that come from your mistakes.

You don't pick lessons off a shelf. When the simulator sees you keep missing a skill, it writes one — against the same database you're working in, so the examples use tables you already know.

  • A plain-language explanation of the skill, framed around your current job's data.
  • One fully worked example query, walked through a line at a time.
  • A Tables & fields browser showing exactly the tables the exercises use — click a name to drop it into the editor.
  • One to three graded exercises, escalating in difficulty, checked the same way the simulator checks your replies.
  • Clear them all and your mastery score on that skill jumps.

Fumble a join inside a grouping lesson? That still counts against joins. Every query you write anywhere is scored on every skill it touches.


Coverage

Every core SQL skill, in context.

Not a syllabus you march through — the simulator draws from these as the requests demand, and leans harder on whatever you're weakest at.

filteringsortingjoinsaggregationgroupinghavingdate filteringsubquerieswindow functionsrankingtext matchingdistinct

Progress

A scorecard for every SQL skill.

Your workspace keeps a 0–100 mastery score per skill, updated on every graded reply. It's how the simulator decides what to throw at you next and what to teach — and it's the clearest read you'll get on where you actually stand.

Skills to shore up
joins
34
window functions
41
subqueries
58
grouping
76

Reputation and level ride alongside it: three clean answers and the requests get harder; a bad run and you drop a level, or get let go and pick a new job.


Also included

Everything else in the lab.


Who it's for

If SQL is the thing between you and the job.

Aspiring analystsData and business analysts building the muscle memory of turning a vague ask into a correct query.
Interview prepPracticing joins, window functions and aggregation under a little pressure, on data you can't memorize.
Career switchersComing from ops, finance or support and need reps, not another video course.

Prove it

Free SQL placement test.

Sixteen questions against a real retail database — no account, no payment. Score 75% or better and claim a verifiable SQL Foundations certificate you can hand an employer. Below that, you'll see exactly which skills to work on, and if you join your measured levels carry straight into your account — you don't start over.


Questions

Before you join.

Do I need to install anything?

No. You write SQL in the page and it runs against a real MySQL 8 database on our server. Nothing to set up, works on any machine.

Do I need SQL experience to start?

No. The simulator opens easy and gets harder as you go. Whenever a skill keeps tripping you, it builds a lesson on that skill from the ground up.

Is it actually graded, or self-check?

Graded. Your query runs and the result set is compared to the expected answer — column by column, order-independent. SELECT * and extra columns still pass; a missing column fails and tells you which.

Which SQL dialect?

MySQL 8. The SELECT syntax you practice carries over to PostgreSQL, SQL Server and SQLite with small changes.

How big are the practice databases?

Real size, not toy tables — each company is five to nine related tables with hundreds to thousands of rows of consistent, generated data. You can't memorize the answers.

What if I get stuck on a request?

Reply to the colleague and ask for clarification, skip it and come back, or open the SQL Console on the side to poke at the tables. Only the occasional urgent request is on a timer — the rest wait for you.

How long is a session?

As long or short as you want. It's turn-based with no clock on the session itself; most people work a handful of requests at a sitting.

Can I break something?

No. The simulator only ever queries an isolated practice database through a read-only account. The Sandbox is a separate throwaway database that's wiped and reseeded on every run.

Do you train on my queries or sell my data?

No. Your queries are used to grade you and to decide which lessons to generate. That's the whole of it.

Is there a trial or refund?

No separate trial, but your first month is $1 — it renews at $5/month after that, and you can cancel from your account any time before it renews. Billing runs through Stripe.


Membership

One membership. All of it.

$1 first month
then $5 / month — cancel any time before it renews
  • The Job Simulator — eight industries
  • SQL Lessons generated from your gaps
  • SQL Console + full sandbox
  • DAX Lab & BI Studio
  • Pharmacy Tech Simulator
  • Cancel anytime
Join — $1 to start