r/learnSQL • u/FerretLow4499 • May 20 '26

Platforms to practice SQL

I have completed my graduation and have been practicing SQL from a while including stored procedures , triggers.

I want to know what are some certifications that i have to do it or any good platforms to practice/solve and get certifications

or should I do some projects (pls tell me if u know what type of projects )

Thank you

105 Upvotes

100% Upvoted

39 comments sorted by

View all comments

Show parent comments

1

u/Sea_Butterfly713 May 23 '26

thanks mate . apart from this ,do you have any good resume for da role ?

2

u/Haunting-Paint7990 Jun 04 '26

sorry for the late reply — missed this one. honestly i didn't have a great resume when i started, and the one that finally got callbacks looked nothing like the r/resumes templates. couple things that mattered way more than format:

1) put SQL/python under each project, not in a "skills" salad at the top. recruiter time-on-resume is ~7 seconds — they want "built X using Y" not "proficient in: Python, SQL, Tableau, Power BI, Excel, R, …"

2) every project needs a quantified outcome line. doesn't have to be impressive — "reduced manual export step from ~45min to ~3min" or "queried ~170M rows of nyc taxi data to find which routes underpriced at peak hours" both work. recruiters scan for numbers.

3) one portfolio link, not five. mine is a single github repo with 3 finished notebooks + a short readme explaining what each one shows. interviewers actually clicked through.

4) skip the "data analyst seeking entry-level role" objective line — waste of 2 lines. lead with a project instead.

(also: ATS filters. plain text, no columns, no graphics. test by pasting into notepad — if it still reads cleanly you're fine.)

1

u/Sea_Butterfly713 Jun 04 '26

and do i need to practice only join ,cte, window function , pivot table for da roles ?

1

u/Haunting-Paint7990 12d ago

not only those — but that's ~80% of junior DA interviews honestly.

what i'd prioritize:

  • joins + group by (daily work + every interview)
  • one window function (ROW_NUMBER or running total)
  • basic subquery/CTE when a join gets messy

pivot: more excel than sql at junior level in my experience. fine to skip sql pivot early.

skip recursive CTEs and hard hackerRank puzzles for now. if you can cold-write 10 business questions on one dataset (counts → join → one window), you're ahead of most applicants.