Learn that JPA has it's own query language, which is similar to SQL but only applicable to the logical model.
- [Instructor] The final topic I want to introduce…before jumping into Spring Data JPA…is the Java Persistence Query Language.…We use JPQL to interact with entities…and their persistent state.…The queries are portable to any relational…database management system.…The syntax is similar to SQL,…but it references entities and attributes…instead of tables and columns.…Let's compare them in a real world example.…First in SQL.…This SQL query looks up all the students in the database.…
We see that there are three students,…Jane, Bob, and Patrick.…This SQL query fetches Jane's details…as well as the courses she's taking.…It accesses all four tables…to pull in seven columns of information.…The first four are from the student table.…Course_id is from the enrollment table.…Course-name is from the course table…and dept_name is from the department table.…This query is pretty messy and difficult to maintain…and we still need a lot of coding…to map it from the physical model to the logical model.…
Now let's try that again in the logical world…
AuthorMary Ellen Bowman
In this course, learn how to easily implement JPA-based repositories using Spring Data JPA. Mary Ellen Bowman describes the Spring Data umbrella project, and helps you understand JPA for object-relational mapping. She also covers querying, and dives into other Spring Data Commons features such as QueryDSL and auditing.
- Spring Data Commons
- Using JPA for object-relational mapping
- Declaring Spring Data Repositories
- Creating query methods with property expressions and @Query
- Query by example
- QueryDSL Spring Data Extension
- Spring Data REST
- Introduction to Spring Data Mongo
- Common pitfalls
Skill Level Intermediate
Java Database Access with Hibernatewith Peggy Fisher1h 28m Intermediate
1. The Spring Data Umbrella Project
Spring Data Commons2m 39s
2. Understanding JPA for Object-Relational Mapping
3. Introduction to Spring Data JPA
4. Querying with Spring Data
5. More Repository Types
6. Special Features
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.