techno-dict
Quick Guide for DBMS:- Part I

Quick Guide for DBMS:- Part I

Aniket Singh's photo
Aniket Singh
·

3 min read

Some important terms:-

1.Data- Data is a collection of facts, such as numbers, words, measurements, observations, or just a description of things.

For Example- Student record, library record.

2.Database- A database is a collection of related data.

For Example- Student database, Employee database.

3.DBMS- It stands for Database Management System. A DBMS is software designed to store, retrieve, define, and manage data in the database.

For Example- MySQL, PostgreSQL.

4.Information- Information is organized or classified data, which has some meaningful values for the receiver.

Types of Databases according to the user requirements:-

  1. SQL
    1. RDBMS.
  2. NoSQL
    1. Document databases.
    2. key-value databases.
    3. Wide-column stores.
    4. Graph databases.
  3. Hierarchical Database.
  4. Network Database.
  5. Object-Oriented Database.

Purpose of Database Systems:-

  1. It is a collection of programs that enables the user to create and maintain a database.
  2. In other words, it is general-purpose software that provides the users with the process of defining, constructing, and manipulating the database for various applications.
  3. Database systems are designed to manage large bodies of Information Management of data involves both defining structures for storage of information and providing a mechanism for the manipulation of information.
  4. In addition the database system must ensure the safety of the information stored, despite system crashes or attempts at unauthorized access.

Database Languages

  1. Data Definition Language[DDL].
  2. Data Manipulation Language[DML].
  3. Data Control Language[DCL].
  4. Transaction Control Language[TCL].

Characteristics of SQL.

  1. SQL is easy to learn.
  2. SQL is used to access data from relational database management systems.
  3. SQL can execute queries against the database.
  4. SQL is used to describe the data.
  5. SQL allows users to set permissions on tables, procedures, and views.
  6. SQL is used to create and drop the database and table.
  7. SQL is used to define the data in the database and manipulate it when added.

Note:- I will be covering all the DBMS topics in-depth in upcoming blogs.

Thanks and Regards, Aniket Singh.

DatabasesSQLNoSQLMongoDBMySQL