SQL

SQL

1. Importance

   • At present, this SQL Language is of the utmost importance since all entities They have a database, so it is very important to master the subject at hand. perfection, to comply with the standards and to comply with the integrity, confidentiality and availability of data in an organization

2. SQL language

   • Known as (Structured Query Language) is an information management language stored in a database which allows communication, interaction and operation between data with the ease of being able manipulate the same

3. Advantage

   • Control various functions of a database with functions such as creation, management update and recovery of data
   • Currently, most database management systems data makes use of the SQL language
   • Simplicity and clarity, easy to understand due to its structure

4. Disadvantages

   • Large number of locks at the page size level since it has a fixed and quite small one
   • High RAM consumption for your software installation and use

5. What is it?

   • It is a programming language created in the 70's and designed for a wide variety of sectors such as banking, health, telecommunications etc.. currently it is the language most used worldwide

6. Features

   • Integrity and data protection
   • Flexibility in data visualization
   • Same code in different systems like Oracle and Microsoft language
   • Allows you to retrieve and manage information from relational databases
   • Use methods of algebra and relational calculus to perform queries