Photo by Annie Theby on Unsplash

What Is SQL?

A High-Level Overview Of Database Architecture

2 min readJan 27, 2021

--

What is a database?

A database is a systematic collection of information that can easily be accessed, managed, and updated. Databases store a variety of data such as usernames, user IDs, email addresses, etc.

Why databases?

  • Databases can store, process, and analyze very large numbers of records and turn them into useful information.
  • When a database is used, data can be searched, sorted, imported easily.
  • More than one person can access the same database at the same time.

DBMS(Database Management System)

DBMS is a software that handles the storage, retrieval, and updating of data.

The most common database management systems are MySQL, Oracle, Microsoft SQL Server, and PostgreSQL.

Types of databases

There are many types of databases. The most important two of them are relational and nonrelational ones.

Relational databases

The most common database type is called a relational database, and the systems that manage these kinds of databases are called Relational Database

--

--