High-Performance SQL - Online Edition
Get the most out of your relational database system
Watch Promo Enroll in Course
The High-Performance SQL training is aimed to level up your SQL skills with techniques such as Lateral Join, Recursive CTE queries, Semi Joins, Derived Tables, JSON processing, and many other database querying features supported by Oracle, MySQL, PostgreSQL, and SQL Server.
Created By
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.
Course Curriculum
-
StartSource Code
-
StartJoin Types (44:03)
-
StartJoin Performance (26:37)
-
StartSubqueries (34:52)
-
StartDerived Tables and CTE (20:50)
-
StartRecursive CTE and Hierarchical Queries (31:58)
-
StartWindow Functions (54:32)
-
StartUpsert and Merge (13:51)
-
StartPivot and Unpivot (11:09)
-
StartSQL Operation Order (26:41)
-
StartPagination (27:15)
-
StartJSON (86:20)