Web develoopment frameworks

i am new to web debvelopment and laid hands on core php and Sql. but online i am coming through all different frameworks like magento,cake,drupal,wordpress... Could anyone help me briefing about them ,and how one varies from another.