1/40
Looks like no tags are added yet.
Structrured Query Language
Meaning of SQL
Database Management System
are providing different set of operations to store and manipulate data such as creating, reading, updating and deleting
Database Management System
These operations are the database languages.
Data Definition Language, Data Manipulation Language, Data Control Language, Transaction Control Language
4 Types of Database Language
Data Definition Language
enables us to specify and modify the metadata and database structure
Data Definition Language
The database structures, such as the schema, tables, indexes, and so on, can be created, modified, and deleted using these commands.
Data Manipulation Language
We can access and modify the data held in pre-existing schema objects, which is a set of unique instructions.
Data Manipulation Language
he insertion, deletion, updating, and retrieval of data from the database are just a few of the actions carried out by these commands.
Data Control Language
is used to manage user access in a database system. The user has access to ALL, CREATE, SELECT, INSERT, UPDATE, DELETE, and EXECUTE, among other things.
Transaction Control Language
is used to manage transactions within databases.
Transaction
is a group of connected tasks that the DBMS software treats as a single execution Page | 9 unit.