this post was submitted on 09 Sep 2023
20 points (100.0% liked)
technology
23218 readers
2 users here now
On the road to fully automated luxury gay space communism.
Spreading Linux propaganda since 2020
- Ways to run Microsoft/Adobe and more on Linux
- The Ultimate FOSS Guide For Android
- Great libre software on Windows
- Hey you, the lib still using Chrome. Read this post!
Rules:
- 1. Obviously abide by the sitewide code of conduct. Bigotry will be met with an immediate ban
- 2. This community is about technology. Offtopic is permitted as long as it is kept in the comment sections
- 3. Although this is not /c/libre, FOSS related posting is tolerated, and even welcome in the case of effort posts
- 4. We believe technology should be liberating. As such, avoid promoting proprietary and/or bourgeois technology
- 5. Explanatory posts to correct the potential mistakes a comrade made in a post of their own are allowed, as long as they remain respectful
- 6. No crypto (Bitcoin, NFT, etc.) speculation, unless it is purely informative and not too cringe
- 7. Absolutely no tech bro shit. If you have a good opinion of Silicon Valley billionaires please manifest yourself so we can ban you.
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
https://learnsql.com/
It's paid but not prohibatively expensive. The way it's strucrured is it explains a command to you, gives you an example, and then asks you to do a slightly modified example. It ends chapters with some exercises. Honestly a great resource for learning sql. Literally the only one that worked for me tbh.
There are libraries that use sql-like queries withib python, you can also run sql queries and feed them into python structures through python. The way I do it is I write up a sql query, test it, add some special characters for myself so I can modify it within python, then store it in a text file to use in python. But sql itself isn't really pythonic. It's very straight forward though, if ylu can code in any language and can solve SAT level logic problems, you can probably write sql reasonably well.
I'm real broke rn, hence the desperate job search lol, so its a bit pricey for me right now, but it does seem like they do pretty nice courses from what I can see. Maybe once I've actually got a job confirmed I'll swing by there to get up to standard before I go in.
Okay, that makes more sense than how my mates were explaining it. So I'll focus on learning the actual sql itself then before i combine it with my python. Thanks comrade