Pressure Variations and Ocean Exploration

How do the pressure variations with depth affect the ability to explore the ocean? How does it affect scuba diving and submarines? If you explain it to me and also if you give me internet site or reference book I would learn more.

Thanks for your help.