SQL - Introduction

 

SQL, which stands for Structured Query Language, is a non-procedural programming language used to interact with databases. It is specifically designed for managing data in relational databases. SQL provides various functions that allow users to read, manipulate, delete, and modify data.

SQL is also referred to as SEQUEL(Structured English Query Language). It was developed by IBM Corporation in the early 1970s. SQL is not case-sensitive i.e, the queries can be written in either uppercase or lowercase.

A database management system (DBMS) is a software system used for creating and managing databases. It provides a structured approach for users and programmers to create, retrieve, update, and manage data effectively.

RDBMS stands for Relational Database Management System. It is a type of DBMS that is based on the relational model, where data is stored in relational databases. A relational database organizes data into tables, which consist of columns and rows. Each column represents a specific data category, and each row contains a set of data related to that category. In a relational database, multiple tables can have relationships with each other, and these relationships are established using foreign keys.

SQL is the language used to communicate with data in a Relational Database Management System (RDBMS). There are various RDBMS Products. Some of them is as follows :-