SQL

Imagine having a tool that can automatically detect JPA and Hibernate performance issues. Wouldn’t that be just awesome?

Well, Hypersistence Optimizer is that tool! And it works with Spring Boot, Spring Framework, Jakarta EE, Java EE, Quarkus, or Play Framework.

So, enjoy spending your time on the things you love rather than fixing performance issues in your production system on a Saturday night!

While doing my High-Performance Java Persistence training, I realized that many Java developers lag behind when it comes to SQL skills.

For way too many application developers, SQL equates that SQL-92 they learned in college. However, SQL has seen many additions over the past 25 years.

Even if the NoSQL movement stormed onto the development scene 10 years ago, it never got to overthrow relational database systems.

In fact, the latest trend is called NewSQL, and it embraces both SQL and ACID guarantees.

In these tutorials, we are going to see what present-day SQL looks like and learn new SQL tricks that even the DBAs will be impressed with.

Basic concepts

Database modeling

JOIN

Join Algorithms

Subqueries

Derived Tables and CTE

ORDER BY

Window Functions

Upsert

Pivot

Execution Plans

Indexing

Batching

Fetching

JSON

Security

Transactions and Concurrency control

Stored procedures

Audit logging

Monitoring and Profiling

Statement Caching

Logging

Testing

Importing and Exporting data

Transactions and Concurrency Control eBook