🗄️
SQL Tutorial
42 topics · Free · Certificate on completion
Master SQL — the universal language for talking to relational databases.
Your learning path
Learn how tables represent relationships, then practise filtering, grouping, joins, and transactions. Be explicit about NULL values and which rows each operation preserves.
Put the lessons into practice
Use a small sample dataset and predict the rows returned by a query. Check duplicates, missing matches, and ordering; work in a disposable database when changing data.
What you'll learn
01.SQL Introduction02.SQL Syntax03.SQL SELECT04.SELECT DISTINCT05.SQL WHERE06.SQL ORDER BY07.SQL INSERT INTO08.SQL UPDATE09.SQL DELETE10.SQL LIMIT / TOP11.SQL LIKE12.SQL IN & BETWEEN13.SQL NULL Values14.SQL Aliases15.SQL JOIN Overview16.INNER JOIN17.LEFT JOIN18.RIGHT JOIN19.FULL OUTER JOIN20.SQL UNION21.SQL GROUP BY22.SQL HAVING23.Aggregate Functions24.String Functions25.Date Functions26.SQL Subqueries27.SQL EXISTS28.CASE Expression29.CREATE TABLE30.ALTER TABLE31.DROP TABLE32.SQL Constraints33.PRIMARY KEY34.FOREIGN KEY35.SQL Indexes36.SQL Views37.SQL Transactions38.Stored Procedures39.SQL Triggers40.SQL Normalization41.SQL Injection Safety42.SQL Best Practices