Summary

This chapter discussed the use of window functions in SQL, which allow for inter-row operations within datasets. Unlike simple functions that operate on a single row, window functions consider the position of data points within the dataset to produce results such as ranks and running totals. With these topics, you will be able to identify the position of a row within its dataset, and its relationships with other rows within the same dataset.

So far, you have learned about the SQL statements for all four operations in the CRUD (create, read, update, delete) data life cycle. You have also learned how to move data in and out of databases and files, as well as accessing databases from Python. Furthermore, you have learned how to use different functions for data transforms or information extraction. At this point, you are already fully equipped to handle common database questions.

Starting from the next chapter, you will dive into advanced topics. You will learn how to...