SQL stands for Structured Query Language, which is the programming language used to communicate and manipulate databases. To learn more about what SQL is? Refer to the following article of Taimienphi.vn.
SQL programs are used by businesses and organizations to access and manipulate information and data stored in databases as well as create and change new tables. To understand what SQL is, you must understand exactly what a database is.
What is SQL? Learn SQL
Follow Microsoft, database (database) is a tool to collect and organize information. The database may store information about users, orders, or other information. Many databases can open word processing programs or spreadsheets, and for large businesses, it is more useful to create a database management system.
To control information in databases, SQL is used to allow users to retrieve the specific data they are looking for. Although it is just a simple programming language, SQL is also quite powerful and useful.
According to the Database Dir page, SQL can insert data into database tables, modify data in existing database tables, and delete dose data from SQL database tables. Also SQL can modify database structure itself by creating, modifying and deleting other database objects.
According to Database Dir, SQL uses scripts to manipulate data in the database. For example, the SQL INSERT statement is used to add data to database tables, the SQL SELECT statement is used to retrieve data from database tables, and SQL UPDATE to edit database records. whether existing.
The SQL programming language was developed in the 1970s by IBM researchers, Raymond Boyce and Donald Chamberlin. This programming language, known as SEQUEL, was created after relational data modeling for banks. Edgar Frank Todd’s big data-sharing row was published in 1970.
In his book, Todd publishes all the data in the database expressed in relational form. In Oracle Quick Guides (Cornelio Books 2013), author Malcolm Coxall wrote that the original version of SQL was designed to manipulate and retrieve data stored in the original relational database management systems. IBM’s called System R.
About a few years later, SQL was made public. In 1979, the company called Relational Software, later renamed Oracle, released a version called the Oracle V2 programming language Oracle V2.
Since then the American National Standards Institute (ANSI) and the International Standards Organization have considered SQL as the standard language in relational database communication. Although major SQL vendors have modified the language to their liking, most rely on SQL programs in ANSI-approved versions.
Instead of trying to write SQL for its own databases, many companies use database management systems that already have SQL built in. Developed and distributed by Oracle, MySQL is one of the most popular SQL database management systems today. The software has an open source version, which means users can download and use it for free.
Reference way Attach and Detach database does not lose user rights here
According to GoDaddy web hosting service, MySQL is a complex and powerful relational database, used on many websites to create and change content quickly.
Although MySQL can be used on many applications, it is also found on many Web servers, according to TechTerms.com.
There are currently many major technology companies in the world using MySQL on their websites, including Facebook, Google, Adobe, Alcatel Lucent and Zappos.
Above Taimienphi.vn has just explained to you what is SQL? In addition to MySQL, there are several other open source SQL database management systems such as PostgreSQL, Ingres and Firebird.
Also related to SQL, you can find out more What are MS SQL Server and Oracle? Compare Oracle and SQL Server Here to distinguish these 2 popular database systems.