Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
4 Hour(s) 16 Minute(s)
Language
English
Taught by
Arkadiusz Fronc
Rating
2 views
Course Overview
Identifying and fixing performance bottlenecks in database and Hibernate. SQL tuning, indexes, eager fetching and more.
Have you ever wondered why database operations in your application are slow? Is it because of the database or Hibernate or both? Is there anything that can be done to improve that? What are those mysterious database indexes? Does using Hibernate leave me no field for performance optimization?
During this course I will teach you performance optimization techniques that will give you a huge advantage in the Java programmers world.
No, you will not have to give up on Hibernate. It is a great tool. I like it too! Most performance issues with it are caused by inefficient usage, not by Hibernate itself. You can still let it do the dirty job for you and have a highly performant application at the same time.
Java developers too often avoid database topics. But some database knowledge can make your life incredibly easier. In this course, I focus on the aspects that will let you make a significant impact on a database performance with the lowest effort.
Let me show you how to take the best from Hibernate using some database knowledge to achieve high speed of database operations.
After this course, you will know how to combine database tricks with Hibernate best practices to build lightning speed software.
Course Content
- 8 section(s)
- 35 lecture(s)
- Section 1 Performance optimization intro
- Section 2 Database design
- Section 3 Unnecessary queries
- Section 4 Indexes
- Section 5 Basic Hibernate tuning
- Section 6 Basic query tuning
- Section 7 Overused entities
- Section 8 Summary
What You’ll Learn
- Know how to approach optimization
- Use Query Execution Plan
- Know which data types and why are preferred in a database for better performance
- Avoid unnecessary type conversions in SQL queries
- Efficiently use dictionary tables
- Configure Hibernate to see executed database queries
- Avoid reading data which is not needed
- Eliminate n+1 problem in Hibernate
- Understand a trade off when implementing flexible solutions
- Properly implement data paging in Hibernate
- Efficiently count rows and aggregating data
- Update and delete multiple rows with a single request
- Learn index structure and its impact on query performance
- Choose the right index for a query
- Use of multi column indexes
- Learn the process of executing queries by a database
- Take advantage of query parameters binding in Hibernate
- Avoid long transactions
- Restructure queries for better performance
- Use indexes to support sorting rows and joining
- Know when it is better to avoid Hibernate entities and how to use alternatives
Reviews
-
MMatthew Wilder
Wasn't much for hibernate optimizations and mostly just focused on direct db performance improvements (query optimization, execution plans, indexes, etc; and not how to better use hibernate). Lots of normal RDMS content that isn't new if you took a proper RDMS class. He does a fine job teaching, but the content that was covered was underwhelming in regards to Hibernate.
-
LLuis Hernan Espinosa Llanos
It's good, sometimes a bit traumatic because of the way of teaching (like acting) and the camera jejej, don't get me wrong, it's just different. But thanks for such advices and tricks.
