SQL Tutorial for Beginners

Facebooktwitterredditpinterestlinkedinmailby feather

SQL tutorial provides basic and advanced concepts of Structured Query Language and how you deploy SQL to work with a relational database system. Our SQL tutorial is designed for beginners and professionals.

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

Structured Query Language (SQL) is one of the most enduring technologies around. It’s so successful that many non-relational, “NoSQL” databases are scrambling to add SQL interfaces.

SQL 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
  • SQL OPERATORS

    • ARITHMETIC 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
Facebooktwitterredditpinterestlinkedinmailby feather