DBMS

SQL (Structured Query Language) is a powerful language used to interact with Database Management Systems (DBMS). It is specifically designed for querying and manipulating data in relational databases. In this blog post, we will explore the fundamental concepts of SQL and gain insights into its evolution and implementations. The Evolution of SQL First published in 1986, SQL has undergone several updates and revisions over the years. The latest version, as of writing this blog, is SQL 2019....

A database is a collection of information carefully organized into a system. The technology that allows us to organize data and represent the information necessary for an information system is called Database Management System (DBMS). A DBMS is software that encapsulates the data of a database and provides us with a centralized way to store, retrieve, edit, persist, and perform other operations on it. Let’s define some of the main properties of a DBMS:...