Window Functions in PostgreSQL | Online Course | Vertabelo Academy

Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Now you can order your window functions at will!

The final quiz should be a piece of cake for you!

32/32 Congratulations

1. Welcome to Practice Field

2. Table customer

4. Table review

5. Table single_rental

6. Table subscription

7. Table giftcard

8. OVER() – Summary

9. OVER() – Exercise 2

10. OVER() – Exercise 3

11. PARTITION BY – Summary

12. PARTITION BY – Exercise 2

13. PARTITION BY – Exercise 3

14. PARTITION BY – Exercise 4

15. Ranking functions – Summary

16. Ranking functions – Exercise 2

17. Ranking functions – Exercise 3

18. Ranking functions – Exercise 4

19. Window frame – Summary

20. Window frame – Exercise 2

21. Window frame – Exercise 3

22. Window frame – Exercise 4

23. Analytic functions – Summary

24. Analytic functions – Exercise 2

25. Analytic functions – Exercise 3

26. Analytic functions – Exercise 4

27. PARTITION BY ORDER BY – Summary

28. PARTITION BY ORDER BY – Exercise 1

29. PARTITION BY ORDER BY – Exercise 2

30. Ranking of platforms

31. Grouping by ntiles

32. Congratulations

Absolutely awesome! You managed to provide correct answers to ALL of our practice exercises. Congratulations!

You should now be ready to take our final quiz. See you in Part 10!

Click Next exercise to finish this part.

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.