What is a resource resolver in AEM and how to use query builder API to query in the JCR and get the content is explained in detail in this video.
AEM Tutorial for Beginner Playlist
https://www.youtube.com/watch?v=Xns5rnr0oyU&list=PL5l69Ui6w3V_4naQpzfOC-enLOzcxHm-H
Previous Video:
https://youtu.be/wXrIB3wLao4
Introduction to Sling Models:
https://youtu.be/Cb52_lbuUqg
References:
------------------
http://localhost:4502/libs/cq/search/content/querydebug.html
https://experienceleague.adobe.com/docs/experience-manager-64/developing/platform/query-builder/querybuilder-api.html?lang=en
00:00 - Introduction
00:48 - Recap
03:36 - Query Builder UI
09:54 - Factory Design Pattern
19:10 - Resource Resolver
22:30 - Query Builder API