codescracker


sql

SQL Tutorial



« CodesCracker Home Next Tutorial »


This tutorial will teach you all about SQL from very basic for beginner to advance.

What is SQL ?

SQL stands for Structured Query Language. It is a simple query language used for accessing, handling and managing the data in relational databases.

The Structured Query Language (SQL) is a language that enables you to create and operate on relational databases, which are the sets of related information stored inside the tables.

The database world is becoming increasingly incorporated, and this has led to a clamour for a standard language that can be used to operate in many different kinds of computer environment.

Why SQL is a Standard Language ?

The Structured Query Language (SQL) has proved to be a standard language because it allows users to learn one set of commands and use it to create, alter, retrieve, and transfer the information, no matter, whether they are working on a PC, a mini, a workstation, or even a mainframe.

Here is a simple SQL example. Let's suppose we have this table (named EMPLOYEE) present in the database:

sql tutorial

Now query the following, to get this table:

select * from employee;

After querying the above, you will get the above EMPLOYEE table as output/result as shown here:

learn sql

You will learn all about SQL one by one in this tutorial series.

Audience

This tutorial is designed and developed to help all those SQL lover who are interested to learn SQL along with practicing a lot of SQL codes. Therefore we have included a lot of SQL query in each and every chapters where required along with its respective output after running the query.

Prerequisites

Before start learning SQL here, you must have some basic computer skills.

If you have some basic skills about computer and databases, then you feel very easy to learn SQL.


« CodesCracker Home Next Tutorial »








Tools
Calculator

Quick Links
Signup - Login - Give Online Test