When I work on sql queries I usually start with a base query and edit as I go depending on the requirements, sometimes running the query and debugging. However, after being in a sql interview it seems like this approach doesn’t work the best for interviews as I frequently go down the wrong path before correcting myself, and especially not in situations where I can’t actually run intermediate queries.
What’s a good approach for working out a sql query in a structured way?
"There are plenty of reasons why people who DO have the knowledge would not admit to it. By asking, you're asking for more than what you think you're asking.
You're asking people to take responsibility. You're questioning people's confidence in their abilities. You're also unnecessarily walling other people out. I often answer questions related to languages or libraries I have never used, because the answers are (in a programmer kind of way) common sense."
Hello, I recently got interested in statistics and wanted to read some books that would give me a good introduction to it.
I'm not looking for a book that goes more technical and teaches me about the different techniques, but I was hoping to find some book that talks about maybe what exactly is valid data, etc... more like meta-statistics? or more philosophical statistics?
Stumbled upon this Fast API Tutorial and was surprised at how thorough this guy is. The link is part 21! Each part is dedicated to adding some small component to a fake cleaning marketplace API. It seems to cover a lot but some of the key takeaways are best practices, software design patterns, API Authentication via JWT, DB Migrations and of course FastAPI. From his GitHub profile, looks like the author used to be a CS teacher which explains why this is such a well thought out tutorial. I don't necessarily agree with everything since I already have my own established style and mannerisms but for someone looking to learn how to write API's this is a great resource.
FoldFold allExpandExpand allAre you sure you want to delete this link?Are you sure you want to delete this tag?
The personal, minimalist, super-fast, database free, bookmarking service by the Shaarli community