Umesh Kumar Busa’s Post

While working with the Spring Boot we often rely on Spring Data JPA and repository methods without writing explicit SQL queries. However, to build efficient and reliable applications, it's important to understand what happens behind the scenes - especially how SQL joins work at the database level. A strong foundation in SQL helps not only when optimizing JPA queries, but also when working directly with databases like PostgreSQL. Understanding joins deeply makes debugging, performance tuning, and data modeling much easier. Continuous learning at the fundamentals always pays off. #SpringBoot #SpringDataJPA #SQL #PostgreSQL #BackendDevelopment #Java #Microservices #Learning #SoftwareEngineering

🚀 Day 24/100 - spring-boot-starter-data-jpa To avoid writing SQL again and again, and managing connections manually... Here comes, spring-boot-starter-data-jpa👇 ➡️ What is spring-boot-starter-data-jpa? It enables Spring Data JPA to work with relational databases in a clean and powerful way. ➡️ What does it include? 🔹Spring Data JPA (Repository abstraction, CRUD made easy) 🔹Hibernate (JPA implementation (ORM)) 🔹Spring ORM (Seamless integration between Spring and JPA) ➡️ Why developers love it - No boilerplate DAO code - No SQL for basic operations - Automatic query generation - Works perfectly with PostgreSQL, MySQL, Oracle, etc. Define a repository interface, and Spring does the rest 🚀 Next post: https://lnkd.in/dTKwTxpz Previous post: https://lnkd.in/d8VVj8_U #100Days #SpringBoot #JPA #Hibernate #BackendDevelopment #Java #WebDevelopment #SoftwareEngineering

🚀 Spring Boot REST API with MyBatis & PostgreSQL When you need fine-grained control over your SQL — for complex joins, optimized queries, or transparent data mapping — MyBatis is a perfect choice. Unlike heavy ORMs, it keeps your SQL clean, explicit, and performance-oriented. This post walks you through building a Spring Boot REST API using MyBatis + PostgreSQL, keeping database interactions simple, predictable, and production-ready. 🧩 Stack: Spring Boot 4 • Java 21 • MyBatis ✅ Full SQL control ✅ Production-grade setup 💡 Learn how to combine Spring Boot’s developer productivity with MyBatis’ SQL precision for total transparency over your database layer. 👉 Read the full article here: https://lnkd.in/eRtXVpmZ #SpringBoot #MyBatis #Java21 #PostgreSQL #BackendDevelopment #CleanCode #APIDesign #Liquibase #SQL #DevCommunity

🚀 Day 35/100 - Spring Boot - Spring JDBC (JdbcTemplate) While Spring Data JPA is powerful, sometimes you need more control over SQL queries❗ That’s where we use JdbcTemplate👇 ➡️ What is JdbcTemplate? JdbcTemplate is a Spring class that simplifies working with JDBC by: 🔹Handling connection management 🔹Managing exceptions 🔹Reducing boilerplate code It allows you to write raw SQL queries while still benefiting from Spring’s infrastructure. ➡️ Example: See attached image 👇 ➡️ How it works? 🔹@Repository marks the class a data access component 🔹JdbcTemplate executes the SQL query 🔹Lambda function maps each row to your desired object ➡️ When to use JdbcTemplate? 🔹Complex SQL queries 🔹Performance-critical operations 🔹Stored procedures 🔹When you need full SQL control 👉 A bit about: JPA vs JDBC? 🔹JPA → Faster development, less SQL 🔹JDBC → More control, more flexibility Both are correct, you can choose based on your project needs❗ Next post: https://lnkd.in/dHeumY83 Previous post: https://lnkd.in/d6SyjS7C #100Days #SpringBoot #Java #JDBC #JdbcTemplate #BackendDevelopment #Database #WebDevelopment #SoftwareEngineering

🚀 SQL Journey Started parallel with Core java | Learning Fundamentals Step by Step 🚀 I’ve officially started learning SQL, and over the last two days I’ve been building a strong foundation in database concepts and queries. 📘 What I learned so far: 🔹 Database Basics Difference between DBMS and RDBMS Understanding what SQL is and why it’s used How relational databases work 🔹 Core SQL Commands SELECT – fetching data from tables USE – selecting a database SHOW DATABASES / SHOW TABLES CREATE DATABASE – creating databases from scratch 🔹 Filtering & Operators (with Sakila DB) WHERE clause IN / NOT IN BETWEEN LIKE operator with % and _ Pattern matching and real-world queries 🧠 Practicing all queries hands-on using MySQL (Sakila database) and platforms like SQLZoo to strengthen logic, not just syntax. This is just the beginning — next goal is to dive deeper into: 👉 JOINs, GROUP BY, HAVING, and advanced queries. 📈 Consistency > Speed Excited to keep learning and growing every day. #SQL #DBMS #RDBMS #MySQL #LearningJourney #FullStackDevelopment #Consistency #Javadeveloper

The repository pattern is a design method that allows for abstraction between business logic and the data of an application. This allows for retrieving and saving/updating objects without exposing the technical details of how that data is stored in the main application. In this blog, we will use Spring Boot with MongoDB in order to create a repository pattern-based application. What you'll learn: * How the MongoDB Spring repository can be used to abstract MongoDB operations * Ensuring data access is separate from core application logic * Why you should avoid save() and saveAll() functions in Spring * Why schema and index design still matters in this case Read the full tutorial here 👉 https://lnkd.in/gNbcET83

The repository pattern is a design method that allows for abstraction between business logic and the data of an application. This allows for retrieving and saving/updating objects without exposing the technical details of how that data is stored in the main application. In this blog, we will use Spring Boot with MongoDB in order to create a repository pattern-based application. What you'll learn: * How the MongoDB Spring repository can be used to abstract MongoDB operations * Ensuring data access is separate from core application logic * Why you should avoid save() and saveAll() functions in Spring * Why schema and index design still matters in this case Read the full tutorial here 👉 https://lnkd.in/gZ_YuAQv

The repository pattern is a design method that allows for abstraction between business logic and the data of an application. This allows for retrieving and saving/updating objects without exposing the technical details of how that data is stored in the main application. In this blog, we will use Spring Boot with MongoDB in order to create a repository pattern-based application. What you'll learn: * How the MongoDB Spring repository can be used to abstract MongoDB operations * Ensuring data access is separate from core application logic * Why you should avoid save() and saveAll() functions in Spring * Why schema and index design still matters in this case Read the full tutorial here 👉 https://lnkd.in/eSB9Ewaz

The repository pattern is a design method that allows for abstraction between business logic and the data of an application. This allows for retrieving and saving/updating objects without exposing the technical details of how that data is stored in the main application. In this blog, we will use Spring Boot with MongoDB in order to create a repository pattern-based application. What you'll learn: * How the MongoDB Spring repository can be used to abstract MongoDB operations * Ensuring data access is separate from core application logic * Why you should avoid save() and saveAll() functions in Spring * Why schema and index design still matters in this case Read the full tutorial here 👉 https://lnkd.in/esr-pEQJ

The repository pattern is a design method that allows for abstraction between business logic and the data of an application. This allows for retrieving and saving/updating objects without exposing the technical details of how that data is stored in the main application. In this blog, we will use Spring Boot with MongoDB in order to create a repository pattern-based application. What you'll learn: * How the MongoDB Spring repository can be used to abstract MongoDB operations * Ensuring data access is separate from core application logic * Why you should avoid save() and saveAll() functions in Spring * Why schema and index design still matters in this case Read the full tutorial here 👉 https://lnkd.in/ehZ-vGVT