SQL language

SQL language

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

Resource summary

	Created by Gildardo Cortes Gallo about 2 years ago