I’m very excited to announce that my new book on Common Table Expressions (CTEs) and Window Functions in MariaDB 10.2+ and MySQL 8.0+ is now out! Please check it out and spread the word.
These two new features have been requested often over the years and they’re finally here. So I did what any reasonable person would do and wrote a book about them.
The book is filled with practical examples that you can follow along with, or not, at your leisure. By the end of the book you will have a solid understanding of what CTEs and Window Functions are, how to use them, and why they’re both awesome.
The publisher’s page for the book is here. The source code for the book is here. The page for the book on this site is here (you can also find it in the sidebar).