Table of contents
Introduction
SQL stands for Structured Query Language.
It is a standardized programming language used for managing and manipulating relational databases. SQL provides a way to interact with databases to perform various operations, such as creating, modifying, and deleting database objects (tables, views, indexes, etc.), as well as querying and manipulating the data stored in those databases.
The language is designed to be declarative, meaning that you specify what you want to be done, and the database management system (DBMS) takes care of figuring out how to execute the request efficiently.
SQL is an interface between the Relation database and the OS
Hence it is often referred to as an RDBMS which stands for Relational Database Management System.
There are different types of SQL versions available some of the famous ones are:
MySQL: An open-source relational database management system commonly used in web applications.
PostgreSQL: Another popular open-source relational database management system known for its advanced features and extensibility.
Microsoft SQL Server: A database management system developed by Microsoft and commonly used in Windows-based environments
Oracle Database: A robust and widely used commercial database management system.
SQL Lite: A self-contained, serverless, and lightweight database engine often used in mobile and embedded applications.