High-Performance SQL - Online Workshop

Get the most out of your relational database system

  Enroll in Course

The High-Performance SQL training is aimed to level 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.

Date and Time

The next training is scheduled for the 14th of October, from 14:00 to 16:30 CET(Central European Time).

Agenda

In this online workshop, we are going to talk about the best way to use Subqueries when using Oracle, MySQL, PostgreSQL, and SQL Server.

Therefore, we are going to cover the following topics:

  • Join vs. Semi join
  • EXISTS, NOT EXISTS
  • IN, NOT IN
  • ANY, ALL
  • Subquery column expressions
  • Derived Tables
  • CTE (Common Table Expressions)

Target audience

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.

Technical requirements

It is recommended to bring your own notebook so that you can configure and run tests associated with the material we are going to go through in this training.

The online workshop is going to be run as a Zoom Meeting.

Payment options

You can buy the tickets directly from the website using a credit card or a PayPal account, or I can provide you a company invoice that you could pay via bank transfer. In case you want a company invoice, you can contact me at [email protected].


Created By


Vlad Mihalcea
Vlad Mihalcea

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


  Online Workshop
Available in days
days after you enroll

Frequently Asked Questions


When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Great workshop!

Vlad guides you from basics to very complex topics with ease. He explains everything in a very detailed way and does his best to answer all your questions.

- Giseth Johana Grimaldo, Software Developer - Universidad Tecnológica de Pereira


Get started now!