Query Language, SQL and its parts

A Query Language is a set of commands to create, update, access data from database allowing users to raise adhoc queries/questions interactively without the help of programmers

There Exists Different set of Commands under each Language component of SQL

These Components/Commands are made clear and can be understood by the hierarchical chart given below :

Benefits of using DBMS

Data Base Management System acts as a route map to a distributed bunch of Database(s)

• Reduced Data redundancy and inconsistency
  
• Enhanced data integrity and security
  
• Provide logical and physical data independence
  
• Provide application Data Independence

Data Base and Data Base Management System[DBMS]

Data Base is a COMPUTER FILE SYSTEM that uses particular file organization to facilitate rapid updating of individual records, simultaneous updating of related records, easy access to all records, by all applications, programs, and rapid access to all stored data which must be bought together for a particular routine report or inquiry or a special purpose report or inquiry. As far as pats of DBMS are concerned, it consists of Data, Hardware, Software & User.