Skip to content
Data Engineer Onsite Details
Share
Explore
Coding Exercise

Coding Exercise - Machine Setup

Pre-interview machine setup
Duration: 30 minutes

Before
the coding exercise, please have the following ready:
Dev environment with a language of your choice
A relational database engine of your choice
Optionally, a UI took to work with the database
Instructions for Postgres and MySQL are included below
An account at
, which can be created for free
Install Zoom on your laptop

Should you have any questions, or run into any challenges walking through this guide, please don’t hesitate to reach out to
and
and we’ll get them resolved.

1. Dev environment

Choose any programming language. You’ll write a console-based application that communicates with an API and a relational database.

2. Relational Database Engine

Choose a relational database engine. If you don’t already have one on your machine, we recommend setting one up using Docker.

Step A. Install Docker

Check to see if
docker
is already installed by running
docker -v
If not, please download & install Docker from
Once installed, re-run
docker -v
in a terminal to make sure it’s installed correctly.

Step B: Install a Database

With docker setup, you can install Postgres or MySQL by executing the following commands in a terminal.

Option 1: Postgres

Download the docker image
docker pull postgres:latest
Run Postgres in a docker container
docker run --name data-interview -p 5432:5432 -e POSTGRES_PASSWORD=pwd postgres:latest

This creates and runs a new container named
data-interview
on port
5432
, for user name
postgres
, and with password
pwd
.

You should be able to connect to Postgres with connection info:

Host:
127.0.0.1
, Port:
5432
, User:
postgres
, Password:
pwd


Option 2: MySQL

Download the docker image
docker pull mysql:latest
Run MySQL in a docker container
docker run --name data-interview -p 3306:3306 -e MYSQL_ROOT_PASSWORD=pwd mysql:latest

This creates and runs a new container named
data-interview
on port
3306
, for user name
root
, and with password
pwd
.

You should be able to connect to MySQL with connection info:

Host:
127.0.0.1
, Post:
3306
, User:
root
, Password:
pwd

Optional: UI tool

If you like to use a UI tool with creating schema, issuing queries etc, here are a few options:

Works for both MySQL and Postgres

After installation:
Make sure your relational engine is running (see steps above)
Connect to the engine using connection info provided above
Verify that you can create a test database & perform simple queries

3. Account at coda.io

If you haven’t already, please sign up for an account at
Our interview questions are shared as coda docs; having an account makes it easy for you to view an edit them.

4. Zoom

Make sure you have
installed on your laptop. We’ll be using Zoom to screen share & walk-through the solution together.

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.