a/A W3D1 - The Assessment SQL
Today we had our second assessment, and we also started SQL (can be pronounced sequel). The title is a dumb pun, sorry. Anyway, Our assessment covered debugging code for a game using RSpec tests. The game was FreeCell. I had trouble with this assessment as I skipped over a method in a class that didn't have a RSpec test to verify it worked. I kept trying to fix a method that relied on the method I skipped over and couldn't get it to pass. Thankfully, this speedbump happened towards the end, so I was still able to pass. Note to self for the future: Complete all methods before moving on.
We worked on SQL syntax for the remainder of the day. It didn't seem that difficult and reminded me of my Microsoft Excel days. Not because all the syntax is the same, but just the way you would pull information with formulas that called on different columns and tables. I was definitely mentally exhausted by the end of the day, but now I have a better grasp of subqueries, outer joins, inner joins and aggregate functions.
