• 11 Posts
  • 54 Comments
Joined 1 year ago
cake
Cake day: June 13th, 2023

help-circle





  • Like others said: sql, sql, sql. The syntax is probably easier than excel, but a lot of people stink at it because they don’t want to invest in the spatial reasoning required to make it work magic, and that opens doors to easy opportunity.

    If you can get into a position like reporting or data quality, and be “that person” that fixes a dreaded slow query to make it run in milliseconds instead of minutes, then you’ll get your proverbial blank check to go where you want. Those queries exist in just about every business.

    Take a look around for “sql portfolio projects” for more complete stuff that goes beyond tutorials.


















  • It’s a lot easier than I initially thought: just write down a high-level, abstract sentence fragment of what needs to be done. Get it off your chest and put it in ink (or pixels?). Then ask yourself: how can I split this into two parts? Rinse and repeat.

    The initial limiter for me was anxiety and fear about it. Once I got into the habit, the limiter was avoiding hyperfocus and micromanaging myself in the project plan. I try not to break things down beyond 1-2 hour tasks.