Description

Learn how to drastically improve the performance of your Laravel applications by pushing more work to the database, all while still using the Eloquent ORM.
What you’ll learn

   The three key metrics to better database performance
   The incredible power of sub queries
   When to use joins vs sub queries
   Using sub queries to select related data
   Using sub queries to build dynamic relationships
   Using sub queries to order by related data
   Calculating totals using conditional aggregates
   Running authorization policies in the database
   Building complex search filters
   Extending the query builder using macros
   Demystifying database indexes
   Introducing complex queries without sacrificing Eloquent’s API
   Leveraging vendor-specific (MySQL, Postgres, etc.) features
   Caching and database denormalization
   How to safely write raw database queries
   Configuring Laravel to make N+1 issues impossible
   Extending Eloquent to support ordering with NULLS LAST and NULLS FIRST
   Getting the distance between two geographic points
   Filtering by geographic distance
   Ordering by geographic distance
   Querying records within a physical area using geospatial shapes