38138396
Description
Mind Map by Gildardo Cortes Gallo, updated more than 1 year ago
|
Created by Gildardo Cortes Gallo
over 2 years ago
|
|
SQL language
- What is ?
- SQL stands for Structured Query Language
- is a management language for
handling information in relational
databases.
- allows to communicate with
the database and perform
operations to access and
manipulate the stored
information
- Is a type of programming Languaje
- SQL stands for Structured Query Language
- Used in
- retail
- health
- banking
- education
- telecommunications
- Even defense
- retail
- History
- In 1970s
- by IBM researchers Raymond Boyce and Donald Chamberlin
- Standardized in 1986
- In 1970s
- Functions
- control all the
functions that
a database
management
system
provides to its
users
- providing a
framework
for creating
the database
itself
- managing its security
- updating its contents
- retrieving data
- sharing it among
different users
- interact
with the
database
- control all the
functions that
a database
management
system
provides to its
users
- features
- use of algebra and relational calculus to perform queries
- manage and retrieve information from
relational database management systems
- implementations in different systems with the
same code
- Data integrity
- valid, correct and
complete
- protects the dBase from
corruptions caused by system
failures or inconsistent updates.
- valid, correct and
complete
- Flexibility
- allows to define different ways of
viewing data to meet specific user
demands.
- allows to define different ways of
viewing data to meet specific user
demands.
- Simplicity and clarity
- unified, clear and easy to
understand language
- statements are easy
to understand and
learn
- unified, clear and easy to
understand language
- use of algebra and relational calculus to perform queries
- Who does it
use?
- companies that have databases
- data analysts
- data scientists
- data engineers
- back-end or mobile
application developers
- companies that have databases
Want to create your own Mind Maps for free with GoConqr? Learn more.