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

12DISTINCT operator

16COUNT & DISTINCT

19Select multiple data

29Combining data from columns

30Handling NULL

31GROUP BY - with COUNT

32GROUP BY - with other aggregate functions

34GROUP BY - multiple columns

35GROUP BY - GROUP_CONCAT

37JOINS - OUTER JOIN

38JOINS - SELF JOIN

39JOINS - Multiple tables

40JOINS - Filtering and Ordering

41JOINS - Grouping

42JOINS - Complex grouping

45INTERSECT and EXCEPT

47Subqueries in FROM clause

52Executing multiple statements

54Column constraints - DEFAULT and CHECK

56PRIMARY KEY - AUTOINCREMENT

57Table constraints - FOREIGN KEY

61Renaming and deleting tables

63VIEWS