Introduction to SQL
 
DBMS
 
DBMS (Database Management System) consists of inter-related data and methods to manipulate those data. It is designed to help users in managing data in a database efficiently.
 
A database management system (DBMS), sometimes also called as a database manager, is a program that lets one or more computer users create and access data in a database. The DBMS manages user requests, as well as requests from other programs, so that users and other programs are not bothered to understand where the data is physically located on storage media and, in a multi-user system, who else is also be accessing the data. In handling user requests, the DBMS takes care that integrity of the data (that is, making sure it continues to be accessible and is consistently organized as intended) and security (making sure only those with access privileges can access the data) remain intact. The most typical DBMS is a Relational Database Management System (RDBMS).
 
A DBMS is usually an inherent part of a database product. Some of the popular DBMSs (actually they are all Relational DBMS) are-Oracle's line of database management products, Sybase's products, Microsoft's SQL Server. On PCs, Microsoft Access is a popular example of a single-or small-group user DBMS.