Sql Tutorial
Learn Sql interactively. Read the concept and write code to practice.
1. SQL Introduction
SQL stands for Structured Query Language. SQL lets you access and manipulate dat...
2. SQL SELECT Statement
The `SELECT` statement is used to select data from a database. The data returned...
3. SQL SELECT DISTINCT
The `SELECT DISTINCT` statement is used to return only distinct (different) valu...
4. SQL WHERE Clause
The `WHERE` clause is used to filter records. It is used to extract only those r...
5. SQL AND, OR and NOT
The `WHERE` clause can be combined with `AND`, `OR`, and `NOT` operators. - The...
6. SQL ORDER BY
The `ORDER BY` keyword is used to sort the result-set in ascending or descending...
7. SQL INSERT INTO
The `INSERT INTO` statement is used to insert new records in a table. It is pos...
8. SQL NULL Values
A field with a NULL value is a field with no value. If a column in a table is o...
9. SQL UPDATE
The `UPDATE` statement is used to modify the existing records in a table. Synta...
10. SQL DELETE
The `DELETE` statement is used to delete existing records in a table. Syntax: `...
11. SQL Aggregate Functions
SQL has many built-in functions for performing calculations on data. Aggregate ...
12. SQL LIKE Operator
The `LIKE` operator is used in a `WHERE` clause to search for a specified patter...
13. SQL IN Operator
The `IN` operator allows you to specify multiple values in a `WHERE` clause. Th...
14. SQL Aliases
SQL aliases are used to give a table, or a column in a table, a temporary name. ...
15. SQL Joins
A `JOIN` clause is used to combine rows from two or more tables, based on a rela...