Finish SQL studies

Intro to SQL at Khan Academy

1. 1.1 Welcome to SQL

2. 1.2 Creating a table and inserting data

3. 1.3 Challenge: Book list database

4. 1.4 Querying the table

5. 1.5 Challenge: Box office hits database

6. 1.6 Aggregationg data

7. 1.7 Challenge: TODO list database stats

8. 1.7 S-Q-L or SEQUEL?

9. 1.8 Project: Design a store database

10. 2.1 More complex queries with AND/OR

11. 2.2 Challenge: Caraoke song selector

12. 2.3 Querying IN subqueries

13. 2.4 Challenge: Playlist maker

14. 2.5 Restricting grouped results with HAVING

15. 2.6 Challenge: The wordiest author

16. 2.7 Who issues SQL queries?

17. 2.8 Calculating results with CASE

18. 2.9 Challenge: Gradebook

19. 2.10 Project: Data big

20. 3.1 Splitting data into repated tables

21. 3.2 JOINing related tables

22. 3.3 Challenge: Bobby's Hobbies

23. 3.4 Joining related tables with left outer joins

24. 3.5 Challenge: Customers orders

25. 3.6 Joining tables to themselves with self-joins

26. 3.7 Challenge: Sequel in SQL

27. 3.9 Combining multiple joins

28. 3.10 Challenge: FriendBook

29. 3.11 Project: Famous People

30. 3.12 More efficient SQL with query planning and optimization

31. 4.1 Using SQL to update a database

32. 4.2 Changing rows with UPDATE and DELETE

33. 4.3 Challenge: Dynamic documents

34. 4.4 Altering tables after creation

35. 4.5 Challenge: Closing alterations

36. 4.6 Make your SQL safer

37. 4.7 Project: App an impersonator

SQL excercises at sql-tutorial.ru