Want to run your data access layer at high speeds?
1. DATABASE ESSENTIALS
Do you know how a relational database systems works behind the scenes?
Do you know how the JDBC Driver executes statements and how you can configure it to boost application performance?
3. JPA AND HIBERNATE
Adding JPA and Hibernate annotations is fairly easy. But, do you know the performance implications of each JPA or Hibernate feature your application makes heavy use of?
This course is meant to mind the gap between Java developers and database programming. Most often, Java developers are very skilled when it comes to programming languages, design patterns, frameworks and everything that's related to their programming language of choice.
However, the database is still uncharted territory, usually treated as a black box that we throw queries at and expect it to respond in no time.
With this workshop, I want to get Java developers to know more about RDBMS so that they can design their application data access layer accordingly. After attending this workshop, you'll know all sorts of tips that you can readily apply to your current enterprise project.
This workshop is for any Java developer that happens to develop software that interacts with a relational database system.
Although we are going to cover many aspects related to database systems, JDBC, JPA and Hibernate, it is best if the attendees have at least one or two years experience working with these technologies since the information provided by this training is much easier to be assimilated by middle and senior developers.
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 this training. It is expected that attendees are familiar with Java, Maven, IDE systems like IntelliJ IDEA or Eclipse, as well as database systems like MySQL, PostgreSQL or in-memory databases like HSQLDB.
The attendees can set up the test environment we are going to use during the training by following the instructions provided in this GitHub repository.
Types and Identifiers
Batching and Statement Caching
Transactions and Concurrency Control
Database, Application and Hibernate Caching
Mastering the underlying data access framework is of paramount importance when it comes to designing a high-performance application. However, sometimes, the best way to address a data-intensive task is to write the proper SQL query. SQL has changed tremendously over the years, yet many Java developers lag behind when it comes to advanced SQL query capabilities. By taking this SQL Master Class for Java Developers course, you will learn very useful SQL features such as Lateral Join, Cross Apply, Window Functions, CTE, Recursive queries, Pivot, JSON, and even more. The course covers Oracle, SQL Server, PostgreSQL, and MySQL,
so, not only it's going to help you with your current project, but it will be useful for future projects as well.