SQL Tutorial

tutorial and example
tutorial and example

SQL tutorial provides basic and advanced concepts of SQL. Our SQL tutorial is designed for beginners and professionals.

SQL (Structured Query Language) is used to perform operations on the records stored in database such as updating records, deleting records, creating and modifying tables, views etc.

Index

  • SQL CONSTRAINTS
    • NOT NULL
    • DEFAULT
    • CHECK
    • UNIQUE
    • PRIMARY
    • FOREIGN
  • AGGREGATE FUNCTIONS
    • MAX()
    • MIN()
    • SUM()
    • AVG()
    • COUNT()
  • SCALAR FUNCTIONS
    • LCASE()
    • UCASE()
    • MID()
    • ROUND()
  • SET OPERATIONS
    • UNION
    • UNION ALL
    • INTERSECT
    • MINUS
  • OPERATORS
    • ARITHMATIC OPERATORS
    • COMPARISON OPERATORS
    • LOGICAL OPERATORS
      • AND
      • OR
      • NOT
      • ALL
      • ANY
      • BETWEEN
      • IN
      • EXISTS
      • LIKE
  • TRUNCATE
    • ORDER BY CLAUSE
    • GROUP BY CLAUSE
    • HAVING CLAUSE
    • JOINS
    • VIEW
    • AUTO_INCREMENT
    • INDEX
    • Insert into select
    • EXAMPLE