Skip to content
Learning pathBeginner

Getting hired in data

From a portfolio that shows how you think to a CV that shows what changed, the SQL questions you will be asked, a take-home assignment done like real work and a project explained clearly in the interview.

By Grokem Editorial

  • 4lessons
  • ~47 minin total
  • Beginnerlevel
  • 2topics

Outcomes

What you will be able to do

  • Turn a list of tools and duties into lines a reader can believe: the problem, what you did and what changed, with a number you can defend, in one page that is easy to scan.

  • Second-highest salary, top per group, rows with no match, comparing to a manager, month over month change and filtering groups, each with a tested solution and the reasoning to say out loud.

  • Read the brief twice, check the data before you trust it, answer the question that was asked, state your assumptions and hand in something a reviewer can open and run in five minutes.

  • Context, question, approach, the decision you made, the result and what you would change: a six-part outline for explaining your own work clearly, with the follow-up questions to prepare for.

Covered

Topics and formats in this path

  • Interview Preparation
  • Career Paths
  • How-to
  • Best practices

Learning plan

4 lessons, in order

Each lesson is short enough for one sitting and ends by pointing to the next.

  1. How-to

    Interview PreparationDoneStarted

    Six SQL interview questions, worked through

    Second-highest salary, top per group, rows with no match, comparing to a manager, month over month change and filtering groups, each with a tested solution and the reasoning to say out loud.

    Grokem EditorialIntermediate20 min

  2. How-to

    Interview PreparationDoneStarted

    Approach a take-home data assignment like a piece of real work

    Read the brief twice, check the data before you trust it, answer the question that was asked, state your assumptions and hand in something a reviewer can open and run in five minutes.

    Grokem EditorialIntermediate15 min

Questions

Before you start

Who is this for?
From a portfolio that shows how you think to a CV that shows what changed, the SQL questions you will be asked, a take-home assignment done like real work and a project explained clearly in the interview. It is written for beginner readers.
How long does it take?
About 47 minutes of reading and doing across 4 lessons. Each lesson shows its own time, so you can do one at a sitting.
Do I need an account?
No. Everything here is free to read. An account is only needed to ask or answer a question in the community.
What if I get stuck on a lesson?
Ask in the community: say which lesson, what you tried and what happened. Every lesson also shows when it was last verified.

Ready when you are

Open the first lesson now: nothing to install, nothing to sign up for.

Choose what we may use. You can change this at any time with “Privacy choices” at the foot of every page. Details are in the Cookie policy and the Privacy policy.

Strictly necessary

Remembers your theme, the lessons you marked as done and this choice. It stays on your device, tracks nothing and cannot be switched off.

Always on
What exactly is collected, and why

Grokem’s own counts

Collects
The pages you open and how long you stay, how far you scroll, where you came from, your device type, browser, screen size, language and time zone. Your IP address is turned into a code that changes every day; it is never stored as it is.
Why
To see how long lessons are read and where readers leave. Not shared with anyone.
Stored
A random visitor ID, a visit ID and the time of your last page view in your browser’s storage (gr_vid, gr_sid, gr_last). No name or email is attached.
Getting hired in data | Grokem