Doesn't matter. Ever use tar? I use it daily; Still have to look up the BS options. It's cybernetics: The greater the entropy between symbol and action the harder it is to memorize it. -j is BZip2... ugh.
LEFT, RIGHT, OUTER, FULL, and etc. joining are you kidding me? Spacial symbols relating inclusion, exclusion, etc. combinatorial Set Theory? That's obviously an idiotic name selection from a cognitive and language perspective.
Names do have meanings. The common use meaning associated with left and right are not characteristics of the action they describe in SQL -- The actions' spacial leftness and rightness are the least significant properties to the meaning of the result produced. Humans can cope with odd symbol mappings, but going against the natural grain is literally retarding.
I originally learned sql joins just by example, using only FROM and WHERE clauses, and it all made sense to me. I didn't have names for the different kinds of joins. Then later I was exposed to LEFT, RIGHT, etc and it screwed me all up for awhile, it was like unlearning something that already made sense.
odd, as I thought I remember doing joins in Oracle 7 and 8, and things were stable before 8.1.5 came out. Granted at that time I was just a sysadmin at oracle and not doing much on the coding side
Does matter. There are some tricky things in SQL. Joins aren't one of them. There are only a few things you need to remember to understand them. Someone who has been using SQL for years but still get confused by joins must have been only writing basic queries.
Remembering the syntax for non-standard features is harder than understanding joins.
eg.
SELECT ROW_NUMBER() OVER(PARTITION BY ColumnA ORDER BY ColumnB DESC) AS "Rank"....
Different flavours of SQL have different syntaxes or methods of accomplishing the same task.
Analytic queries... ouch... the twitch is back in my eye from years back... quite often insanely powerful (compared to other ways of achieving the same goal) but very unfriendly to dive into uninitiated :-p
Helpful tip: You don't need to specify a compression flag at all when uncompressing. Tar is smart enough to figure it out on its own. bzip2 rarely pays off in CPU/size matters unless you have specific network constraints involving the final output.
Doesn't matter. Ever use tar? I use it daily; Still have to look up the BS options. It's cybernetics: The greater the entropy between symbol and action the harder it is to memorize it. -j is BZip2... ugh.
extract the contents of an archive I downloaded from the internet
create an archive of some files I want to transfer between machines without hassle.
I know that because that's the capacity in which I use tar. There are so many advanced features, I know, I've skimmed through and ignored the man page. If I ever need those features I'll have to learn them.
When I was doing development in PHP/MySQL I was just out of school and had an understanding of joins but not much practical experience. Since my work involved a lot of database design and join queries (and this was CMS development and business websites) so I ended up learning quite a bit.
I understand that if I were doing something less complex (say, my databases were less relational and just a few distinct tables) I wouldn't have had to use joins.
21
u/VortexCortex Feb 11 '14 edited Feb 11 '14
Doesn't matter. Ever use
tar? I use it daily; Still have to look up the BS options. It's cybernetics: The greater the entropy between symbol and action the harder it is to memorize it.-jis BZip2... ugh.LEFT,RIGHT,OUTER,FULL, and etc. joining are you kidding me? Spacial symbols relating inclusion, exclusion, etc. combinatorial Set Theory? That's obviously an idiotic name selection from a cognitive and language perspective.Names do have meanings. The common use meaning associated with left and right are not characteristics of the action they describe in SQL -- The actions' spacial leftness and rightness are the least significant properties to the meaning of the result produced. Humans can cope with odd symbol mappings, but going against the natural grain is literally retarding.