Sommario
Dove si usa SQL?
SQL (acronimo di Structured Query Language) è il linguaggio di interrogazione più diffuso tra quelli usati per l’interazione con i principali Database Management Systems (DBMS), soprattutto relazionali. Chi ha necessità di utilizzare database sul proprio server, non può prescindere dalla conoscenza di SQL.
A cosa servono le diverse componenti di SQL ovvero DDL DML DCL?
Data Definition Language (DDL) – permette di creare e cancellare database o di modificarne la struttura. Data Manipulation Language (DML) – permette di inserire, cancellare, modificare i dati. Data Control Language (DCL) – permette di gestire gli utenti e i permessi.
Cosa fare con SQL?
L’SQL consente di interrogare e gestire i database attraverso costrutti di programmazione chiamati query. In questo modo è possibile leggere, modificare e cancellare i dati presenti nel database, ma anche esercitare funzioni di gestione e controllo sul sistema di database stesso.
What is the correct way to pronounce SQL?
In short, SQL was originally called sequel. Due to a legal challenge, the name was changed to SQL. So was the pronunciation, I guess. See from MySQL official docs: The official way to pronounce “MySQL” is “My Ess Que Ell” (not “my sequel”), but we do not mind if you pronounce it as “my sequel” or in some other localized way.
Why is SQL called the sequel to SQL?
So it was this spelling/pronunciation that was used from the start. It wasn’t until later that its name was changed to SQL. This was reportedly due to a trademark conflict with the Hawker Siddeley aircraft company. So it would seem that the “Sequel” pronunciation is simply paying homage to SQL’s humble beginnings.
How do you pronounce “sequel”?
You might’ve heard some developers pronouncing it as “S-Q-L” [ ˈɛs kjuː ˈɛl ] and others using “sequel” [ ˈsiːkwəl ]. It can start an argument anytime within the database community.
What is sequel (Structured English query language)?
This version, initially called SEQUEL (Structured English Query Language), was designed to manipulate and retrieve data stored in IBM’s original quasi-relational database management system, System R, which a group at IBM San Jose Research Laboratory had developed during the 1970s.