SQL Tutorial SQL Advanced SQL Database SQL Resources
Python Java C++ C C# PHP R SQL DS Algo InterviewQ

SQL - Tutorial



SQL stands for Structured Query Language. It is a query language and used for performing operations on the database such as insert new records, update records, delete records and view records etc. SQL queries are performed on database like Oracle database, MySQL database, and SQL Server database etc. All database management system uses SQL as standard database language.

About Tutorial

This tutorial provides basic and advanced concepts of SQL. It is designed for beginners and professionals as well. Every topic is explained with examples which make you learn SQL in a very easy way. In this tutorial, you will learn how to create new database, perform various operations on database like insert new records, update records, delete records and view records etc. Additionally, you will also learn how to create database/table, drop database/table, set permission on tables, procedures, and views and create stored procedure, function in a database.

We believe in learning by examples therefore each and every topic is explained with lots of examples that makes you learn SQL in a very easy way. Along with this, almost all examples can be executed online which provides better understanding of the language and helps you to learn the language faster. The classical "SELECT * statement" example is mentioned below for the illustration purpose:

Consider a database table called Employee with the following records:

EmpIDNameCityAgeSalary
1JohnLondon253000
2MarryNew York242750
3JoParis272800
4KimAmsterdam303100
5RameshNew Delhi283000
6HuangBeijing282800

To fetch all fields of the Employee table, the SQL code will be:

SELECT * FROM Employee;

This result of the following code will be:

EmpIDNameCityAgeSalary
1JohnLondon253000
2MarryNew York242750
3JoParis272800
4KimAmsterdam303100
5RameshNew Delhi283000
6HuangBeijing282800

Prerequisite

There is no prerequisite for this tutorial however a basic understanding of database would be an added advantage.


4