Chris EK, on life as a continually learning software engineer.

Translating Verbs: CRUD, SQL, and HTTP

Jun 20th, 2014

Recently I was asked two interview questions about basic CRUD functions, specifically (1) how they correspond to HTTP verbs and (2) how to perform those actions on the database side with SQL statements.

On the other hand, it took me a second to recall the SQL statements. Crud. I remember hearing at Flatiron that a shortcoming of many junior developer candidates is SQL, that they don’t know to retrieve a record with SELECT expression FROM table WHERE conditions;.

I remember thinking “I know my SQL—I’ll never run into such a problem.” Well, I almost did! It’s amazing how easy it is to forget even the most basic syntax when you don’t use it. So I’ll be sure to commit the following table to memory: