Database- The essential for all application
Every application has a database. Database is basically the platform of any application. Database is used to store data and access it from computer system. Structured Query language, SQLs is used to manipulate data stored in database. There are basically two kind of query. 1) DDL: Data Definition language or DDL is used to define the database schema. It is used to create and modify the structure of database. Example: CREATE, DROP, ALTER, TRUNCATE, COMMENT and RENAME 2)DML: Data Manipulation Language or DML is used to manipulate the data present in the database. Examples: INSERT, UPDATE and DELETE There are various database which is used to store data. MySQL: MySQL is free source database widely used. Oracle: Oracle DB is widely used by enterprises.