Learn SQL (Standard Query Language) for Databases

Learn SQL

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

  1. What is SQL?
  2. Create Table Statement
  3. ALTER TABLE Statements
  4. Rename Columns of a Table
  5. Modify Column DataType
  6. Drop Columns from Table
  7. Rename Tables
  8. Drop Tables
  9. What is Null Value?

DML Statements

  1. Insert Statement
  2. Update Statement
  3. Delete Statement
  4. Truncate Statement
  5. Merge Statement

SQL Functions

  1. AVG()
  2. COUNT()
  3. MAX()
  4. MIN()
  5. SUM()

Select Queries

  1. Select Query
  2. WHERE Clause
  3. GROUP BY Clause
  4. HAVING Clause
  5. ORDER BY Clause

SQL Joins

  1. Inner Join
  2. Left Join
  3. Right Join
  4. Full Join

SQL Operators

  1. BETWEEN
  2. IN
  3. LIKE
  4. INTERSECT
  5. MINUS
  6. UNION
  7. UNION ALL
  8. DISTINCT
  9. ANY, SOME
  10. ALL