I'm not really keen on this company because of the longer-than-usual commute from home but I figured, the technical interview will help me pinpoint areas of weaknesses that I need to improve since I planned on reviewing, studying and possibly, even going for a certification during my downtime (which is NOW). Also, getting some technical exam practices will surely help build up my confidence.
I remember taking my first technical assessment test around this time last year, I was so scared! I had not taken an exam or been tested for anything (technically) since I started working and that was more than a decade ago. I was so scared of failing but since it was a C# test which was only 30 questions long, I wasn't really sure which areas I needed to review so I just threw caution to the wind and told the guy that I have not done any coding in a while (disclaimer).
As it turns out, I got 95% correctly. Ang galing galing ko talaga.... manghula ;) LOL!
Anyway, tonight, I realized that despite the lack of recent practice, I can still hack it as a developer (at least on paper anyway). I do need to brush up on the terminologies - abstract, virtual, interface, override, overload,... - as I realized that I know how and when to use each of those concepts but ask me to define ? .. uh ... I get tongue-tied.
Oh, and I learned about a new SQL Server function "COALESCE " today. Thinking back to the SQL statements, SPs and views that I've written over the years, I cannot think of an instance where I could've used this but I would love to get a chance to use this soon. I remember feeling this excited when I was first learning about SQL's "Partition By" feature too and couldn't wait to use it in an actual application.
*channeling my inner geek*