Aggregation: withAvg(), withMin() and withMax() Select Only What You Actually Need

Example Demo: Teachers and Students Dashboards

Repository for this lesson

Aggregation: withAvg(), withMin() and withMax() Select Only What You Actually Need

Course Content

Intro

01 About the Course: What's Inside?

N+1 Query Problem

02 What is N+1 Query: Typical Example, Debugbar and Eager Loading

03 N+1 Query: "Deeper" Examples - Packages and Count

04 Eager Loading with load() and $with

05 Detect and Prevent N+1 Query: With Package or Laravel 8.43+

Optimizing RAM Consumption

06 With() VS WithCount(): Out of RAM Memory?

07 Aggregation: withAvg(), withMin() and withMax()

08 Example Demo: Teachers and Students Dashboards

09 Select Only What You Actually Need

10 Collections: filter(), map() or DB Query?

11 API Return: Kilobytes Optimization

Optimizing CPU and Queries: Make the Database Work

12 Be Careful with Eloquent Accessors and Foreach

13 Eloquent vs Query Builder: whereHas vs join() vs Raw SQL

14 Example Demo: whereHas vs join() on DEEPER relationships

15 SubQueries and SubSelects: One Step Towards Raw SQL

16 Query Result Caching: With or Without Package

17 Faster Seeds with Insert and Chunk

Relationships to the Same Table

18 E-Shop with Three-Level Categories: Tree and Product List

19 E-Shop with Unlimited Subcategory Levels

20 Using Nested Set Package for Unlimited Subcategory Levels

What's Next

21 What if Your Queries are Still Slow?