SQL language

SQL language

1. 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

2. Used in

   • retail
   • health
   • banking
   • education
   • telecommunications
   • Even defense

3. History

   • In 1970s
   • by IBM researchers Raymond Boyce and Donald Chamberlin
   • Standardized in 1986

4. 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

5. 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

6. Who does it use?

   • companies that have databases
   • data analysts
   • data scientists
   • data engineers
   • back-end or mobile application developers