SQL is a database communication language. SQL Queries are used to perform tasks such as selecting data, sorting data or updating data.

You can use SQL to interact with database systems. By writing SQL queries you can use the data.

You may like:
Learning SQL: Master SQL Fundamentals

Query

A query is often written as on line. This could be

1
SELECT name FROM users;

The database system would then return all names.

Database systems

There are several database systems that use the SQL language:

  • SQLite
  • MySQL
  • MariaDB
  • Microsoft SQL Server
  • Oracle
  • Sybase

While they support SQL, many of them have custom additions to the language.

These systems have unique properties: some are commercial, created by different organisations, some accept multiple connections to the database etc.

To learn the SQL language, all you need is the SQLite database system. This is the easiest way to learn SQL.

In this tutorial you will learn the basics of SQL and how to use it in practice.