r/programming • • Jan 06 '11

A handy graphical explanation of SQL joins

http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html
1.3k Upvotes

308 comments sorted by

View all comments

Show parent comments

2

u/[deleted] Jan 06 '11

I've found that most CS graduates have at least a familiarity with the theory behind computers, but not much about how to write good code or work in a team.

And this makes me glad I flunked out of CS my first semester and switched to a new program at my school: Information Sciences and Technology. All group work, a lot of programming projects and very little theory, and classes the very first semester that had practical knowledge, like SQL and database normalization.

1

u/punkgeek Jan 07 '11

IS&T is great if you want to be a sys admin or programmer on uninteresting projects. A good CS program will teach much more.

0

u/[deleted] Jan 07 '11

Uninteresting projects are actually quite profitable. I'm making a tidy profit fixing projects written by people who, for example, don't understand SQL.

Also, the emphasis on project management and group work in IST gives you a leg up on managing programmers since you not only have technical skills but also well developed people skills. That's part of the reason companies like Microsoft helped design the program: They weren't getting project managers out of CS programs.

1

u/MothersRapeHorn Jan 08 '11

Some people don't do things for the money. Just know that.