SQL Tutorial

What is SQL?

HRML Tutorial home

SQL is a domain-specific language developed to manage the data and kept in a relational database management system. SQL stands for Structured Query Language and was created by ISO/IEC, and the typing discipline is made stronger. The statements perform many operations on a database, such as retrieval of data, updating data, removing and renaming data, and deleting data. Oracle, Sybase, and Microsoft SQL Server are some databases that use SQL language. We cannot call SQL a programming language, but it has some standards to create procedural extensions to extend the functionalities to form a programming language.

Before understanding SQL, we need to understand RDBMS first. RDBMS, or Relational Database Management System, stores structured data and establishes relationships between the data. It stores data in tabular format. It has column and rows which contains related data entries. Columns are a vertical entity of a table. It includes the record’s attribute; rows are horizontal entities with records/data. The intersection of rows and columns consists of the information of a record concerning that attribute.