SQL-Tutorial

SQL Einführung SQL Syntax SELECT SELECT DISTINCT WHERE ORDER BY AND OR NOT Operatoren Kommentare

INSERT INTO NULL-Werte UPDATE DELETE

SELECT TOP / LIMIT LIKE Wildcards IN BETWEEN Aliase CASE NULL-Funktionen

Aggregatfunktionen COUNT() SUM() AVG() MIN() MAX() GROUP BY HAVING

Joins (Überblick) INNER JOIN LEFT JOIN RIGHT JOIN FULL JOIN SELF JOIN UNION UNION ALL

EXISTS ANY ALL SELECT INTO INSERT INTO SELECT Stored Procedures

CREATE DATABASE DROP DATABASE BACKUP DATABASE CREATE TABLE DROP TABLE ALTER TABLE

Constraints NOT NULL UNIQUE PRIMARY KEY FOREIGN KEY CHECK DEFAULT CREATE INDEX AUTO INCREMENT Datumswerte Views

SQL Injection Parameter Prepared Statements SQL Hosting