Learn SQL
Learn SQL by actually writing SQL code
Table of Contents

12DISTINCT operator

16COUNT & DISTINCT

19Select multiple data

30Combining data from columns

31Handling NULL

32GROUP BY - with COUNT

33GROUP BY - with other aggregate functions

35GROUP BY - multiple columns

36GROUP BY - GROUP_CONCAT

38JOINS - OUTER JOIN

39JOINS - SELF JOIN

40JOINS - Multiple tables

41JOINS - Filtering and Ordering

42JOINS - Grouping

43JOINS - Complex grouping

46INTERSECT and EXCEPT

48Subqueries in FROM clause

53Executing multiple statements

55Column constraints - DEFAULT and CHECK

57PRIMARY KEY - AUTOINCREMENT

62Renaming and deleting tables

64VIEWS