Mapa mental

SQL language

Gildardo Cortes Gallo Tecnología Technology Inglês

Conteúdo do mapa

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
Used in
- retail
- health
- banking
- education
- telecommunications
- Even defense
History
- In 1970s
- by IBM researchers Raymond Boyce and Donald Chamberlin
- Standardized in 1986
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
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.
- Flexibility
  - 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
Who does it use?
- companies that have databases
- data analysts
- data scientists
- data engineers
- back-end or mobile application developers