3 ms·
Learning SQL early on in uni. I attended a course where you passed the course if you completed a certain percentage of the home exercises on a web platform. The
by h3mb3 4y ago
Learning SQL early on in uni. I attended a course where you passed the course if you completed a certain percentage of the home exercises on a web platform. They were just tons and tons of different kinds of SQL pickles against a fake corporation Postgres database, probably more complex than you'd ever need in an average CRUD app project. This was very useful in my first job were I had to make sense of a weird legacy data platform built on top of MSSQL but also later on in basically any project ever involving a relational DB.
Git somes to mind too, where it changed the way I think about how to do the day-to-day writing of my code and that the knowledge is very transferable across all kinds of projects.
- lewisedc 4y agoYou don’t happen to have a link to the home exercises or know anything similar I could follow?
- h3mb3 4y agoNope, sorry mate. It was a long time ago. I did find [1] which seems similar-ish (I have no idea what "w3resource" is) but I think our schema back then had a lot more tables and the questions were a bit more diverse. [1] https://www.w3resource.com/sql-exercises/employee-database-exercise/index.php https://www.w3resource.com/sql-exercises/employee-database-e...
- omosubi 4y agoA bunch of the leetcode like interviewing sites have SQL sections, like hacker rank
- mattbrewsbytes 4y agoI would second this as being proficient at SQL is a 10x skill. I learned more on the job than in college though. If you want to be good at web app development that means CRUD which means understanding RDBMS and SQL. Even though I work with Rails, I think in SQL when it comes to data relationships. Being able to just join together tables in SQL, get metrics, dive into data issues, etc. without some ORM or layer in between you and the data is a 10x skill since it will likely carry through your entire career as web frameworks, libraries, etc. come into and out of fashion. I would extrapolate this further into knowing the base languages used in whatever you work on. If its web, a fundamental understanding of HTTP, HTML, CSS, JS without frameworks, code generators, etc. will give a solid base to then easily pick up how various languages and frameworks layer on top of the fundamentals.
- homarp 4y agosame learning early: regex and basic 'unix' tools: grep (or ripgrep), find (or fd), cat, head, tail, and simple sh/bash
- ceasesurthinko 4y agosecond the regex