SQL
Definition:
Structured query language (SQL) is a standard language for
database creation and manipulation. You can use SQL
statements (estaimens) to store, update, delete, search (serch),
and retrieve (retriiff) information from the database. You can
also use SQL to maintain (mainten) and optimize (optimais)
database performance.
Importancia:
For example, they can embed SQL queries with the Java
programming language to create high-performance data
processing applications with leading SQL database systems,
such as Oracle or MS SQL Server. In addition, SQL is very easy
to learn, since common English keywords are used in its
instructions.
Nowadays (nouadays) SQL is very very important in all aspects,
since as we already know SQL is a language that is used to
manipulate and manage (manache) information, and
information is one of the most important things in this world,
information is power, So most companies in the world, if not all,
from all sectors use databases to store their data. In addition,
SQL is used in data science or data analysts, as well as by
software developers, both web and apps.
History:
The history of SQL begins (bigins) at IBM in 1969, when a
investigator named Edgar F. Codd introduced or created the
famous relational databases (A relational database is where it's
tables are related to each other by some common data) .
Then, in 1977, IBM implemented SQL for the first time in its
database management (manachment) system called System R.
But it was ORACLE that in 1979 implemented SQL in its
database management system commercially for the first time.
At first SQL had the name SEQUEL (Structured English Query
Language).
Features:
*It is certified and standardized by different standardization
organizations such as ISO (International Organization of
Standardization) (en español, organización internacional de
estandarización), mientras que ANSI significa American
National Standards Institute (en español, instituto americano de
estándares nacionales).
How SQL work
SQL is executed (excequiur) through queries.
SQL Components
The commands are basically the syntax itself. Although all of
these have different names, they are all commands, the only
thing that differentiates (diferenchis) them is the function.
● DDL: Its function is to define the database schema.
● DML: As its name says, its function is to manipulate data
or tables, insert, delete, update. etc
● TCL: Work with groups of pre-established joint execution
tasks. It defines the characteristics of transactions and can
execute (Exseqiu) and create a save point, and revert
changes.
● DCL: Used to manage rights and permissions to control
the database system. Its commands are: GRANT, REVOKE.
● DQL: Its purpose is to obtain information related to the
query to work with other operations. This is the case of the
SELECT command.
características:
1. Sencillez y comprensibilidad: Para la unificación
estructural, usa la sintaxis que es fácil de interpretar en
sus comandos.
2. Flexibilidad: Los usuarios pueden adaptarlo a cualquier
tipo de necesidad, lo que les permite visualizar datos y
encontrar soluciones fácilmente.
3. Integridad de datos: Protege de fallos y asegura que
toda la información sea correcta y esté completa.
4. Certificación por ANSI e ISO (International Organization
for Standardization): Cuenta con el sello de aprobación de
las entidades que garantizan calidad, conformidad y
seguridad de su uso.
SQL: Qué es, para qué sirve, sus características y cómo
funciona el lenguaje (ebac.mx)
What Is SQL? | Commands, Language Elements & Constraints
(selecthub.com)
SQL Operators - SQL Tutorial | Software Testing Material
