DBMS

Database Management System

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 :-

  1. Hierarchical Database
  2. Network Database
  3. Relational Database
  4. Centralized Database
  5. Distributed Database
  6. Object-Oriented Database
  7. Cloud Database
  8. 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

Introduction To Database & 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 :-

  1. Create
  2. Drop
  3. Alter
  4. Rename
  5. Comment
  6. 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 :-

  1. Select
  2. Insert
  3. Delete
  4. Update
  5. Call
  6. 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 :-

  1. Revoke
  2. 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 :-

  1. Rollback
  2. Commit

We provide you a wonderful course on DBMS, you can get it by clicking on below Get Course button.

Leave a Reply

Your email address will not be published.

Back to top button
Close

Adblock Detected

Disable Adblocker or Open Website in Google Chrome to View Content