In this blog you’ll learn about Database and Database Management System (DBMS) .
So, lets get started
What is Data?
Data is a collection of small distinct unit of information. It can be in different forms like character,integer,media and any other type of information.
What is Database?
Database is a organised form of data that can be accessed and managed easily.
You can organise data into tables and index it to make it eaiser to to find required information.
Types of Databases :-
There is so many types of databases available to used. Some is listed below :-
- Hierarchical Database
- Network Database
- Relational Database
- Centralized Database
- Distributed Database
- Object-Oriented Database
- Cloud Database
- NoSQL Database
What is DBMS?
DBMS is stands for Database Management System. It means DBMS is a Management System to manage data. There is so many DBMS softwares available line Microsoft SQL Server, Postgre SQL, MySQL, Oracle, etc. DBMS software works as a interface between the user and the database.
Languages Used in DBMS
1. DDL
DDL stands for Data Definition Language. This is used to make structure of database.Using DDL you can create tables, schema, constraints, indexes, etc.
Tasks that come under DDL :-
- Create
- Drop
- Alter
- Rename
- Comment
- Truncate (for removing all records from a table)
2. DML
DML stands for Data Manipulation Language. It is used to access and change data in database.
Tasks that come under DML :-
- Select
- Insert
- Delete
- Update
- Call
- Merge
3. DCL
DCL stands for Data Control Language. It is used for fetching data from a database. Rollback function also comes in DCL.
Tasks that come under DCL :-
- Revoke
- Grant
4. TCL
TCL stands for Transaction Control Language.It is used to live the changes that is made by DCL statement.
Tasks that come under TCL :-
- Rollback
- Commit
We provide you a wonderful course on DBMS, you can get it by clicking on below Get Course button.
