(Tutorial) What is SQL? – DataCamp
SQL or structured question language is the native language for interacting with databases and is designed for precisely this goal. It is a language of databases. A database fashions actual-life entities like professors and universities by storing them in tables. Each desk accommodates information from a single entity sort. This reduces redundancy by storing entities solely as soon as. For instance, there solely must be one row of information containing a sure firm’s particulars. Lastly, a database can be utilized to mannequin the connection between entities.
If you wish to know learn how to study the fundamentals of SQL or turn out to be an knowledgeable, take a look at these weblog posts:
While SQL can be utilized to create and modify databases, this tutorial’s focus shall be on querying databases. A question is a request for information from a database desk (or mixture of tables). Querying is an important ability for a data scientist for the reason that information you want on your analyses will usually dwell in databases.
In SQL, you’ll be able to choose information from a desk utilizing a
SELECT assertion. For instance, the next question selects the
identify column from the
SELECT identify FROM folks;
In this question,
FROM are known as key phrases. In SQL, key phrases will not be case-delicate, which implies you’ll be able to write the identical question as:
choose identify from folks;
That stated, it is good observe to make SQL key phrases uppercase to tell apart them from different components of your question, like column and desk names.
It’s additionally good observe to incorporate a semicolon on the finish of your question. This tells SQL the place the tip of your question is!
SQL Order of Execution
Note: Your question will all the time want a SELECT and a FROM assertion (to determine which columns you need returned from which desk)—the others are non-obligatory.
Example of SELECT
In the next instance, you’ll SELECT the
title column from the
SELECT title FROM movies;
When we run the above code, it produces the next outcome:
This content material is taken from DataCamp’s Introduction to SQL course by Nick Carchedi.