>Everyone always have circlejerk thread about C and Javascripts and shit
>I'm here just trying to do SQL and Hadoop
Let's have a good ol' SQL thread lads
one of the best languages. withstood the test of time.
I have about 90% chance of getting an internship at logistics dept of some automaker,so what type of SQL queries should i concentrate on more.
Any books,videos or links to practice queries online ?
solid mathematical foundation
>>60757248
inner join is more than enough in 90% of the cases, nigger. now stfu
>>60757382
You obviously never used SQL professionally kid.
SQL is not a real programming language and if you are not at least advanced with it you are a brainlet
>>60757382
You have to at least accept that LEFT JOIN is used as often.
>>60757382
>not listing clients that missed at least one shitty field
kek, go back to school, kid
I fucking hate SQL and want to stab the first developer guy in the face.
>>60757369
sqlzoo is okay
>>60757451
stick to gluing together shitty js libraries faggot
love sql, lmaoing@nosql is always a hearty kek
>>60757409
How do I git gud then
>writing functions in pgplsql, sending in all the shit for postgres to its thing
vs
>compute all the shit in your backend, send infinite inserts to postgres
second feels more natural and might scale easier than putting unnecessary stuff in the DB, however you can skip a lot of communication overhead with the first
>>60758306
A bug in the first is hell on earth.
A bug in the second is a paddling from your neighbor dba.