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
[-] ChaosMaterialist@hexbear.net 6 points 1 year ago

The PostgreSQL project has a tutorial in their documentation.

Section 1 is about setting up Postgres, and section 2 is the hands-on tutorial for SQL.

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?

Databases allow programs to connect to them and send SQL statements to the database. There are Python libraries that help manage this connection within a python program. After you get your feet wet with the above tutorial, you can start writing python programs that populate and retrieve information via SQL.

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

Another comrade has recommended postgresql too and it looks very self-explanatory, so I'll definitely be going through that tonight. Those last links seem pretty helpful too, so i'll try those next, thanks. I don't know why it didn't occur to me to see if i could find straight up documentation - docs are always written in a clear way that works for me.

[-] ChaosMaterialist@hexbear.net 5 points 1 year ago

It doesn't help that official docs don't rank on search engines picard-annoyed

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