- SQL Basics
- SQL Home
- SQL Syntax
- SQL RDBMS
- SQL Databases
- SQL Data Types
- SQL Operators
- SQL Expressions
- SQL Database
- SQL Create Database
- SQL Select Database
- SQL Drop Database
- SQL Table
- SQL Create Table
- SQL Drop Table
- SQL Keywords
- SQL Insert Into
- SQL Select
- SQL Where
- SQL And & Or
- SQL Update
- SQL Delete
- SQL Like
- SQL Select Top
- SQL Group By
- SQL Order By
- SQL Distinct
- SQL In
- SQL Between
- SQL Joins
- SQL Joins
- SQL Inner Join
- SQL Left Join
- SQL Right Join
- SQL Full Join
- SQL Constraints
- SQL Constraints
- SQL Unique
- SQL Not Null
- SQL Primary Key
- SQL Foreign Key
- SQL Check
- SQL Default
- SQL Create Index
- SQL Advance
- SQL Aliases
- SQL Union
- SQL Auto Increment
- SQL Views
- SQL Dates
- SQL Transactions
- SQL Injection
- SQL Test
- SQL Online Test
- Give Online Test
- All Test List
SQL 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:
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:
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 »