MongoDB(NoSQL) vs RDBMS(SQL) - What makes them different?

The first time I heard about NoSQL, I got really confused. Firstly, because I am usually not the type of person who is quick to jump on the band wagon of the latest technology. Secondly, because, well I thought why would anyone need that anyway. I th...