As experienced professionals in the field of SQL, senior developers face unique challenges and responsibilities when it comes to their technical expertise and problem-solving abilities. This page aims to provide a concise and insightful collection of SQL interview questions specifically tailored for senior developers. By exploring a range of advanced SQL topics and scenarios, I…
Read More SQL Interview Questions for Senior DevelopersIf you’re starting your journey in the world of SQL and preparing for an interview, you’ve come to the right place. In this page, we will provide a collection of essential SQL interview questions tailored for beginners. Whether you’re seeking your first SQL job or simply looking to enhance your SQL knowledge, these questions will…
Read More SQL Interview Questions for BeginnersThis Spring Data JPA tutorial will demonstrate how to use the LIKE % expression in a Native SQL Query. In an advanced SQL LIKE expression, the % sign represents zero, one, or multiple characters within the SQL query. Let’s take a look at a Native JPA SQL Query that employs an advanced SQL LIKE expression…
Read More LIKE % Expression in JPA SQL QueriesThis tutorial will teach you how to use the @Query annotation to execute custom SQL queries. Spring Data JPA provides many query methods that are ready to use, allowing us to perform basic CRUD(Create, Read, Update and Delete) operations. However, there may be situations where we need to execute a custom SQL query even though…
Read More Spring Data JPA Native SQL QueryThis tutorial will teach you how to create a JPA Native SQL Query to only select information from specific columns. You can find many more Spring Data JPA-related tutorials on this site. Some of the most popular tutorials are: One-to-One Mapping Hibernate/JPA Using Spring Boot and MySQL One-to-Many Mapping Hibernate/JPA Using Spring Boot and MySQL…
Read More Select Specific Columns with JPA Native QueryIn this tutorial, I will share how to make the Spring Boot application display Hibernate SQL Queries. If you are learning about Hibernate, you might also be interested in the following tutorials: One-to-One Mapping Hibernate/JPA Using Spring Boot and MySQL One-to-Many Mapping Hibernate/JPA Using Spring Boot and MySQL Many-to-Many Relationship in Spring Boot Rest +JPA…
Read More Show Hibernate SQL Query in Spring BootThis short Spring Data JPA tutorial will teach you how to write a Native UPDATE SQL query. Let’s assume you need to run the following SQL query: update users u set u.EMAIL_VERIFICATION_STATUS = ‘true’ where u.USER_ID = ‘5JwQBHd1mL73XEg8S2e2w4ITn9gOW4’ I assume you will not want to hardcode the values of EMAIL_VERIFICATION_STATUS and USER_ID into an SQL…
Read More Spring Data JPA Native UPDATE SQL QueryIn this tutorial, you will learn how to run an SQL query in your project, which uses Spring Data JPA Query Methods. You will learn how to annotate the Spring Data JPA Query method so that you can use it to perform a custom SQL query to SELECT, UPDATE or DELETE a record from a…
Read More SQL Query with JPQL in a Spring Data JPA Project