Database Management Systems
A database management system is used to organize who can access a database and how they can make changes. They are important for managing the security and the integrity of data.
A database management system (DBMS) is a tool to store, edit and organize data in a database. It provides several key features:
|
|
Benefits of a DBMS:
The benefits of a DBMS include:
A database in a DBMS could be viewed by lots of different people with different responsibilities |
DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.
|
|
DML is short name of Data Manipulation Language which deals with data manipulation and includes most common SQL statements such SELECT, INSERT, UPDATE, DELETE, etc., and it is used to store, modify, retrieve, delete and update data in a database.
|
|
|
Need More Information then Download the material!
© Copyright Protected.