Finishing My Computing Degree After Failing an Exam

I failed one of my exams the first time around. Not because the material was impossible, just because I didn't have the time to actually study for it properly that semester. Other things ate the hours I should have spent preparing, and it showed on exam day.

Going back in for the retake

The retake for that module was a SQL exam, and not the kind I expected. No laptop, no database open in front of me to test anything against. Just paper, and I had to write actual SQL by hand: joins, inner joins, indexes, and then explain the reasoning behind each one in writing too.

Writing SQL without a computer is a different skill

I'd written plenty of SQL before, but always with autocomplete filling in table names, a syntax highlighter catching typos before I noticed them myself, and the option to just run the query and see if it actually worked. None of that was there this time. I had to actually know the syntax, not just recognize it when IntelliSense suggested it, and I had to be able to explain why a join or an index made sense instead of just writing something that happened to work.

It was hard, but it clicked

Explaining concepts by hand, without a tool to check my work, forced me to actually understand what I was writing instead of pattern-matching my way through it. It was a hard exam. I got through it, and I understood SQL joins and indexes better afterward than I did going in.

What it changed

Failing that first attempt wasn't fun. But the retake taught me more about SQL than passing on the first try probably would have. I finished the degree because of that failed exam, not despite it.