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

13DISTINCT operator

17COUNT & DISTINCT

20Select multiple data

31Combining data from columns

32Handling NULL

33GROUP BY - with COUNT

34GROUP BY - with other aggregate functions

36GROUP BY - multiple columns

37GROUP BY - GROUP_CONCAT

39JOINS - OUTER JOIN

40JOINS - SELF JOIN

41JOINS - Multiple tables

42JOINS - Filtering and Ordering

43JOINS - Grouping

44JOINS - Complex grouping

47INTERSECT and EXCEPT

49Subqueries in FROM clause

54Executing multiple statements

56Column constraints - DEFAULT and CHECK

58PRIMARY KEY - AUTOINCREMENT

63Renaming and deleting tables

65VIEWS