SQL Tutorial

SQL Select

SQL SELECT statement allows you to retrieve the data from one or more database tables.

SQL Where

SQL WHERE clause is used with other SQL statements such as SQL Select, SQL Delete,SQL Update statements ...to allow you to filter all data rows in database tables which satisfy conditions.

SQL Alias

SQL alias is used to organize the output. There are two types of alias: column alias and table alias.

SQL Distinct

SQL DISTINCT is used to eliminate the duplicated rows in the result of SELECT statement.

SQL Order By

SQL ORDER BY allows you to sort the result based on one or more sort keys in ascending or descending fashion.

SQL In

SQL IN operator allows you to determine if a value is contained in a set of values.

SQL Between

SQL Between operator allow you to retrieve records which has value in a range of values.

SQL Like

Using SQL Like to find a string of text based on patterns matching

SQL Group By

SQL Group By is used to divide a database table into groups based on group columns.

SQL Having

SQL HAVING clause is used together with SQL GROUP BY clause to filter group of records based on conditions.

SQL Inner Join

SQL JOIN allows you to combine records from two or more tables into a temporary table called join-table

SQL Outer Join

Different from the SQL inner join, SQL outer join returns all records from both joined tables even there is no matching record found.

SQL Join - Self-join

In this tutorial, you will learn a special kind of SQL join called SQL self-join.

SQL Union

SQL Union is used to combine results of two SQL queries into one.

SQL Insert

SQL INSERT statement allows you to insert one or more records into a database table

SQL Update

SQL update statement allows you to modify data in a database table.

SQL Delete

SQL Delete statement allows you to delete one or more records in a database table.

SQL Create Table

This tutorial shows you how to create database tables by using SQL CREATE TABLE statements.

SQL Alter Table

SQL provides you ALTER TABLE statement to allow you to modify existing data tables.