MariaDB and MySQL Common Table Expressions and Window Functions Revealed

Covers two of the most compelling and yet underrated new features in MariaDB 10.2 and MySQL 8.0
Helps readers to not only know how to apply the features, but also to recognize when to apply them
Provides readers the needed technical information in a clear and concise manner, without extra bloat

Autorentext
Daniel Bartholomew has been using Linux since 1997 and databases since 1998. In addition to this book, he has written MariaDB Cookbook and Getting Started with MariaDB (1st and 2nd editions), and dozens of articles for various magazines, including The Linux Journal, Linux Pro, Ubuntu User, and Tux. Daniel became involved with the MariaDB project shortly after it began in early 2009, and continues to be involved to this day. He currently works for MariaDB, Inc., where he splits his time between managing MariaDB releases, writing new documentation, and maintaining the various bits and pieces that keep the MariaDB project running smoothly. Daniel is currently the official Release Manager for the MariaDB database.

Inhalt

Part I: Common Table Expressions.- 1. Basics of Common Table Expressions.- 2. Non-Recursive Common Table Expressions.- 3. Recursive Common Table Expressions.- Part II: Window Functions.- 4. Basics of Window Functions.- 5. Recognizing Opportunities for Window Functions.- 6. Window Functions in Practice.- 7. Combining Window Functions and CTEs.