21
submitted 1 year ago* (last edited 1 year ago) by Lerios@hexbear.net to c/technology@hexbear.net

I've never touched SQL but some friends said that its a language you can basically learn in an afternoon, so I put it on my CV and applied to some jobs that say they want SQL lol. But now I've actually gotten an interview and I'd like to not get caught out as bullshitting - is it as easy as my friends say and do any of yall have some good resources about learning/using it? In the past I've had pdfs that take you from nothing to profiecency in a language and I'd love something similar, but now that I've graduated I don't have access to stuff like that anymore. I have a shittonne of experience in python if that helps (although at a glance nothing i'm seeing online looks much like python, but i'm told that you can implement it through python or something?)

Most stuff I can find quickly either try to make you pay for it or they're videos instead of text and that doesn't really play well with the adhd. Do you guys have anything? Thanks for the help scamming a corporation comrades meow-hug

you are viewing a single comment's thread
view the rest of the comments
[-] hexaflexagonbear@hexbear.net 3 points 1 year ago* (last edited 1 year ago)

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.

although at a glance nothing i'm seeing online looks much like python, but i'm told that you can implement it through python or something?

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.

[-] Lerios@hexbear.net 2 points 1 year ago

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.

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.

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

this post was submitted on 09 Sep 2023
21 points (100.0% liked)

technology

23308 readers
332 users here now

On the road to fully automated luxury gay space communism.

Spreading Linux propaganda since 2020

Rules:

founded 4 years ago
MODERATORS