In this course, you will learn to query your SQL database using Structured Query Language or SQL for short. We will start by learning about the relational model and SQL before moving on to learning the basics of selecting and filtering your table data. Then we will move on to learn some powerful features like aggregate functions and the GROUP BY clause. You will also learn to combine data from multiple tables. Towards the end of this course, I will show you how you can leverage SQL in your Frappe instance to query your site database and make query reports!By the end of this course, you will have the foundational knowledge to write SQL queries that get you the information you are looking for.
Know More