SQL¶
WHAT IS SQL?¶
SQL is a language used to communicate with a database, standing for Structured Query Language.
RUNOOB¶
-
RUNOOB：SQL 🎯🏆
PROGRESS¶
BASIC¶
- SQL Tutorial
- SQL Introduction
- SQL Syntax
- SQL SELECT
- SQL SELECT DISTINCT
- SQL WHERE
- SQL AND & OR
- SQL ORDER BY
- SQL INSERT INTO
- SQL UPDATE
- SQL DELETE
ADVANCED¶
- SQL SELECT TOP
- SQL LIKE
- SQL WILDCARDS
- SQL IN
- SQL BETWEEN
- SQL ALIAS
- SQL JOIN
- SQL INNER JOIN
- SQL LEFT JOIN
- SQL RIGHT JOIN
- SQL FULL JOIN
- SQL UNION
- SQL SELECT INTO
- SQL INSERT INTO SELECT
- SQL CREATE DATABASE
- SQL CREATE TABLE
- SQL CONSTRAINTS
- SQL NOT NULL
- SQL UNIQUE
- SQL PRIMARY KEY
- SQL FOREIGN KEY
- SQL CHECK
- SQL CREATE INDEX
- SQL DROP
- SQL ALTER
- SQL AUTO INCREMENT
- SQL VIEWS
- SQL DATES
- SQL NULL VALUES
- SQL NULL FUNCTIONS
- SQL GENERAL DATA TYPES
- SQL DB DATA TYPES
FUNCTIONS¶
- SQL FUNCTIONS
- SQL AVG()
- SQL COUNT()
- SQL FIRST()
- SQL LAST()
- SQL MAX()
- SQL MIN()
- SQL SUM()
- SQL GROUP BY
- SQL HAVING
- SQL EXISTS
- SQL UCASE()
- SQL LCASE()
- SQL MID()
- SQL LEN()
- SQL ROUND()
- SQL NOW()
- SQL FORMAT()
- SQL QUICK REFERENCE
- SQL HOSTING
- SQL SUMMARY