What are views ? How are they useful ?

A view is a (virtual) table that does not really exist in its own right but is instead derived from one or more underlying base tables. Views are useful to view desired information that is actually stored in a base table and they extend the control we have over our data. They are an excellent way to give people access to some but not all of the information in a table.