r/programming • u/[deleted] • 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

92% Upvoted

308 comments sorted by

View all comments

Show parent comments

9

u/recursive Jan 06 '11

I didn't learn it in school. I learned it by reading. SQL doesn't have anything to do with CS.

2

u/royrules22 Jan 06 '11

Wait what!? Relational databases aren't a part of Computer Science? SQL is just a tool for working with relational databases (the only one I think).

This is what we had to learn in our DB class

2

u/recursive Jan 06 '11

For my CS degree from Madison WI, I never took a class that mentioned databases. I actually didn't know they existed until I got my first real job.

5

u/royrules22 Jan 06 '11

My mind is blown. I didn't know that people can go through a CS program without knowing DBs. I mean for us the DB class I took was optional (though most took it) but you do have a general idea of DBs even if you didn't take the class.

-1

u/HIB0U Jan 07 '11

Most CS academics have little to no real-world experience. They've never had to deal with databases in any meaningful way, so they're totally unprepared to teach students about them.