Data
Data is any sort of information which is stored in computer memory. This information can later be used for a website, an application or any other client to store for future purpose.
The most common information is User information in the form of user personal, address and banking information. Let’s consider Facebook, it stores our personal data, images, posts, comments and many more things. Banking application also stores user data, their transactions details, funds summary etc. All this information is data, but when it put together and store in a structural way, it becomes informational data.
Database
A database is a collection of information that is organized so that it can be easily accessed, managed and updated.
Database is actually a place where related piece of information is stored and various operations can be performed on it. Any piece of information or the known facts that can be recorded and that have implicit meaning is data. Example: Students roll no., name, address etc.
Most Database products/tools uses SQL language, which is just a ANSI standard, and is used as a base with most database systems, like Microsoft SQL Server, Oracle, MySQL, IBM DB2 have used this as a base and extended/enhanced in their database systems.
SQL
SQL (pronounced “ess-que-el”) stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc.
Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system. However, the standard SQL commands such as “Select”, “Insert”, “Update”, “Delete”, “Create”, and “Drop” can be used to accomplish almost everything that one needs to do with a database.
DBMS stands for Database Management System
A database may be generated and maintained manually or it may be computerized. A computerized database may be created and maintained either by a group of application programs written specifically for that task or by a database management system.
A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data.
