Introduction to
SQL
What is SQL?
SQL is a “Structured Query Language”.
Developed in the mid-1970s, SQL has become the
standard programming language for database
applications. SQL is much more than just the queries
that give it its name: this language represents
the predominant interface for interacting with
relational databases.
It is essential to know that the language is based on
“relational algebra” . It is a mathematical theory to
structure data and determine the results of queries.
How does SQL work?
Applications (App) can be programmed with different
languages such as Python, PHP or Ruby. However,
databases do not understand these languages.
Until recently, they only understood SQL (although
things have changed a lot in recent years).
This is why learning SQL is indispensable for working in
the fields of application development or web
development.
What is SQL used for?
The SQL language is used when working with databases.
In the financial sector, online banking and payment processing
applications store data about financial transactions and users.
Music streaming applications such as Spotify or Youtube make
heavy use of databases, for example, to store the vast catalogs
of music files from different albums by different artists.
Social networks such as Facebook or Instagram use SQL to
store information about a user's profile, such as their
biography or location.
Practice with SQL
https://www.w3schools.com/sql/sql_syntax.asp
SELECT FROM
SELECT DISTINCT
WHERE
ORDER BY
AND
OR
NOT
COUNT
SUM
AVERAGE
