SQL - NOT REALLY LANGUAGE.
source link: https://dev.to/hte305/sql-not-really-language-3jen
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
The SQL language ๐จโ๐
SQL is a tool for organizing, managing and retrieving data stored by a computer database. The original named by IBM was Structured English Query Language which we often call is SEQUEL. SQL - the shorten named by the Hawker Siddeley Aircraft Company of the United Kingdom after was a trademark owner. But somehow both them are correct.
SQL is a computer language that you can work with the database. In real life, you are often working with a special type of database and in SQL we are called it is the relational database.
The computer program that controls the database is called a database management system (DBMS).
When we use SQL to make request. The DBMS processes that request and retrieves the requested data and returns it to us. Whole this process we is called query - hence the name Structured Query Language.
----------------
SQL Request ๐จโ๐
(Give me ๐)
----------------
| ^
| | ๐ Data
v |
---------------------
DBMS ๐ข
---------------------
| ^
| | ๐ Data
v |
---------------------
Database
(Mysql, MSSQL,..)
Store
๐๐๐๐๐๐๐ฅญ๐๐๐๐
๐๐๐ฅ๐๐ฅฅ๐
๐ถ๐๐ฅ๐ ๐ง
---------------------
Database Management System (DBMS) ๐ข
SQL is used to control all the functions in DBMS. It's include many tools to process data in the database.
- Data definition: allows a user define the structure and organization of the stored data and relations.
- Data retrieval: allows a user or and application program retrieve stored data and use it from the database.
- Data manipulation: allows a user or an application program to retrieve stored data from the database and use it.
- Access control: used to restrict a user permission to protected data.
- Data sharing: used to coordinate data sharing by the current users to make sure that changes at the same time will not impact another one.
- Data integrity: used to defines integrity constraints in the database. Protected it from inconsistent updates or system failures.
Summary:
- SQL is comprehensive language for controlling and interacting with the database management system.
- SQL is not really a computer language like C++, C, Java,...
- SQL is a database sublanguage.
- SQL statements can be embedded into another language.
SQL is used to control all the functions in DBMS.
Enjoy your time ๐ชด
Thanks for reading.
Recommend
-
47
Long-time Slashdot readerslack_justyb writes, "Jonathan Blow, an independent video game developer, indicated to gamesindustry.biz that while working on a recent project he stopped and considered how miserable programming...
-
24
We want you! Well, no, actually, no, not really. Writing Software, technology, sysadmin war stories, and more. Friday, June 21, 2013 We want you! Well,...
-
16
New Flash Player? No not really. Monday, October 7, 2002 A couple of people have noticed that there appears to be a new version of the Flash Player (6.0.50.0). However, this version only includes the debug, standalone...
-
6
Is Verizonโs 5G Really Faster? Not Necessarily By Jesse Hollington...
-
5
This is the only way to go given the growth, founder says Telegram is considered one of the top alternatives to WhatsApp, and this year has generated a massive growth, with close to 500 million acti...
-
8
Study shows only 13% of Apple users are โvery interestedโ The foldable display revolution is under way, and companies out there are looking into ways to launch devices based on this new form factor,...
-
13
Michelle Crapo March 18, 2022 1 minute read ...
-
4
Itโs Not Just You, Music is Getting Really BoringIn March of 2022, the song Heat Waves by UK band Glass Animals hit the top of the Billboard Hot 100. It had spent
-
7
Really,itโs OK not to be a mixed methods researcherBreaking into UXR can be hardโ really hard. As the industry continues to grow both in size and demand for skills, resea...
-
4
Baseline Does Not Really Cover Baseline Support Updated December 17, 2023, originally posted December 16, 2023;
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK