Cours Base du langage SQL et des bases de données gratuit en PDF

• SQL SELECT, DISTINCT, AS (alias), WHERE
• SQL AND & OR, IN, BETWEEN, LIKE
• SQL IS NULL / IS NOT NULL, GROUP BY
• SQL HAVING, ORDER BY, LIMIT, CASE
• SQL UNION, UNION ALL, INTERSECT
• SQL EXCEPT / MINUS, INSERT INTO
• SQL ON DUPLICATE KEY UPDATE
• SQL UPDATE, DELETE, MERGE
• SQL TRUNCATE TABLE, CREATE DATABASE
• SQL DROP DATABASE, CREATE TABLE
• SQL ALTER TABLE, DROP TABLE
• Jointure SQL, SQL INNER JOIN, CROSS JOIN
• SQL LEFT JOIN, RIGHT JOIN, FULL JOIN
• SQL SELF JOIN, NATURAL JOIN, Sous-requête
• SQL EXISTS, ALL, ANY / SOME, Index SQL, CREATE INDEX
• SQL EXPLAIN, Commentaires en SQL