What is SQL?


What is SQL?

SQL, whose English is "Structured Query Language" and which is translated into Turkish as "Yapılandırılmış Sorgu Dili" (Structured Query Language), is a very useful database query language that allows us to make additions, deletions, creations, and modifications to data stored in computer environments.
Everything recorded in the internet and computer environment can be given as examples of data.
For example, on a website, posts, post titles, post tags, author names, number of likes, comments and the names of commenters, and many other things are examples of data in the internet and computer environment. In fact, if we are to add, the list can go on as far as users' profile photos and even the videos they upload.

How Does SQL Work?

Very strong mathematical algorithms lie behind the working principle of SQL. With SQL, we can reach the data we are looking for among millions of data in a very short time; the main reason for this is that the data added to the database is recorded in a very organized and categorized way or is constantly sorted in the order that will provide the best result in the most proper way, thus bringing up the data very quickly.
Thanks to the categorized data, instead of searching among all the data to reach a specific piece of information, it is much faster to search within the relevant category and reach the desired data.
It would be nonsensical for someone looking for a class score by school number to search for that number in the phone number field or any other unrelated field.


Database Systems

SQL is a query language and in order to use it, you must first use a database system. Here are some popular database systems
  1. MySQL
  2. SQLite
  3. Oracle
  4. Firebird
  5. PostgreSQL
  6. Windows SQL Server