SQL - Coggle Diagram
What is SQL?
SQL, stands for Structured Query Language.
It is a programming language that is used to communicate with and manage databases.
SQL is a standard language used for manipulating data held in relational database management systems (RDBMS).
It was first developed in the 1970s by IBM.
What are Query/Queries in SQL?
A query is a request for data or information from a relational database.
It is a way to communicate with a database management system (DBMS) to retrieve, manipulate, or update data stored in a database.
What is Data Definition Language(DDL)?
Data Definition Language lets you to create, alter, or delete databases and their related objects like tables, views, etc.
These commands include CREATE, ALTER, DROP, and TRUNCATE.
What is Data Manipulation Language(DML)?
Data Manipulation Language lets you manage data within database objects.
These commands include SELECT, INSERT, UPDATE, and DELETE.
What is Data Control Language (DCL)?
Data Control Language lets you primarily deal with rights, permissions and other control-level management tasks for the database system.
These commands includes like GRANT and REVOKE.
What are Relational Databases?
A relational database is a type of database that stores and organizes data in a structured way.
It uses a structure that allows data to be identified and accessed in relation to other data in the database.
Data in a relational database is stored in various data tables, each of which has a unique key identifying every row.
Relational databases are made up of a set of tables with data that fits into a predefined category.
Each table has at least one data category in a column, and each row contains a certain data instance for the categories defined in the columns.