Learn SQL (Standard Query Language) for Databases

SQL stands for Structured Query Language. SQL is used to query and manipulate the underlying relational databases such as SQL Server, Oracle, MySQL, PostgreSQL, SQLite, etc.

SQL is an ANSI (American National Standards Institute) and ISO (International Organization for Standardization) standard language. However, not all the databases support the same SQL, but there is little variation. Also, most databases include their own addition to SQL.

Basics

What is SQL?
Create Table Statement
ALTER TABLE Statements
Rename Columns of a Table
Modify Column DataType
Drop Columns from Table
Rename Tables
Drop Tables
What is Null Value?

DML Statements

Insert Statement
Update Statement
Delete Statement
Truncate Statement
Merge Statement

SQL Functions

AVG()
COUNT()
MAX()
MIN()
SUM()

Select Queries

Select Query
WHERE Clause
GROUP BY Clause
HAVING Clause
ORDER BY Clause

SQL Joins

Inner Join
Left Join
Right Join
Full Join

SQL Operators

BETWEEN
IN
LIKE
INTERSECT
MINUS
UNION
UNION ALL
DISTINCT
ANY, SOME
ALL