Home » SQL Basics

SQL Basics

SQL is Structured Query Language. It is used for storing, manipulating and querying data stored in relational databases.
The first incarnation of SQL was in 1974, when a group in IBM developed the first prototype of a relational database.

The SQL is used by all major RDBMS today and it has different flavors used by different RDBMS Providers.
This is due to two reasons:
1) The SQL command standard is fairly complex, and it is not practical to implement the entire standard.
2) Each database vendor needs a way to differentiate its product from others.

In this tutorial pages the most of them refer TSQL(Transact SQL) used by SQL Server.

1.Basic SQL statements for storing, retrieving, and manipulating data in a relational database. Example: DRL, DML
a)Retrieving Data
b)Manipulating Data
2.SQL statements are used to manage tables inside the database. Example: DDL
a)Creating and Manipulating Schema
3.Advanced SQL: Advanced SQL commands and InBuilt Functions. Example: Aggregate Function, Concatenate Function,Union, Union ALL, Intersect etc.
a)In Built Functions

SQL Syntax: A single page that will list all the syntax statements for SQL commands in this tutorial.

For each of the command, the SQL syntax will first be explained and presented with by an example.
This tutorial is mainly focussed on getting users good general understanding of the SQL syntax and make them able to write SQL queries using the correct syntax.

Enjoy Reading.

Leave a Reply

Your email address will not be published. Required fields are marked *