SQL

SQL

1. What is it?

   • a management language for handling information in relational databases
   • allows communication with the database and perform operations
   • access and manipulate stored information

2. What is it for

   • Perform data selection, insert, update, and delete operations
   • Perform administrative operations on databases
   • Controls all the functions that a SBGD offers to users
   • Manage security, update content, recover data and share it between different users

3. features

   • using algebra and relational calculus to perform queries
   • allows to deploy implementations of the same in different systems
   • Integrity
     • Ability to preserve the integrity of the data, ensuring that they are valid, correct and complete
     • protects the database from corruptions caused by system crashes or inconsistent upgrades inconsistent.
   • Flexibility
     • versatile language in the implementation of solutions, allows defining different forms of view data to meet specific user demands.
   • Simplicity
     • Clear and easy to understand language. Includes a high level of English, so SQL statements are easy to understand and learn