High-Performance SQL Pagination
Get the most out of your relational database system
The High-Performance SQL training is aimed at leveling up your SQL skills with techniques such as Window Functions, recursive queries, Pivoting, JSON processing, and many other database query features supported by Oracle, SQL Server, MySQL, or PostgreSQL.
In this workshop, I'm going to show what is the best way to store JSON data and how you can query it efficiently when using Oracle, SQL Server, PostgreSQL, and MySQL.
Therefore, we are going to cover the following topics:
- Pagination best practices
- Offset and Keyset Pagination
- Streaming vs. Pagination
This online workshop is for any developer that happens to develop software that interacts with a relational database system.
After attending this workshop, you'll know all sorts of tips that you can readily apply to your current enterprise project.
Vlad Mihalcea is a Java Champion and one of the top Hibernate ORM project committers. He created the Hypersistence Optimizer tool which scans your application configuration and mappings and tells you what changes you need to do to speed up your data access layer.
He's been answering thousands of questions about Hibernate and JPA on StackOverflow for which he's got gold badges for Hibernate, Java, and JPA tags.
Whenever he finds something interesting, he likes to share it on his personal blog. He believes in Open Source Software, and he thinks every developer should get involved, one way or the other.
If he doesn’t find a suitable tool for a job, he takes initiative and starts a new open source project, like Hibernate Types or FlexyPool.