Laravel Course - The PHP Framework > Laravel - Database

Laravel Query Builder - Aggregate Functions

15.9k

An aggregate function computes on a set of values and returns a single value. With the exception of COUNT(*), aggregate functions disregard null values. Aggregate functions are frequently used in conjunction with the SELECT statement's GROUP BY clause.

Laravel includes aggregate functions such as max, min, count, average, and total. Following the construction of our query, we can call any of these functions.

AVG is a function that computes the average of a set of values. COUNT – counts the number of rows in a given table or view. MIN – returns the lowest value in a set of values. MAX – returns the highest value from a set of values. SUM – computes the value sum.

In your data set searches, you may get fast, dynamic analytics for any Currency, Number, or Percentage field. See the overall value picture for fields like Annual Revenue, ARR, or Employee Count, then switch between Sum, Average, Minimum, and Maximum to gain a different perspective on the data.

Learner's Ratings

4.4

Overall Rating

  • 81%
  • 3%
  • 6%
  • 6%
  • 4%

Reviews

A
Abdul Sattar
5

Please update course

A
Ali Haidar
5

awesome

M
Muzammal
5

Best Experience Ever

J
Jatin
5

this tutorial help me to learn laravel .. Outstanding Course

G
gautam metaliya
5

good experiance

B
bokhtiar toshar
5

Thank you so much,

A
Anuj Tyagi
5

Thank you so much. You are doing a good job and your way of teaching is very good.

M
mohit mistry
5

Sir, very good explanation in video but sir which screen recoder you used for making this kind of video???

R
RUPESH MISHRA
5

sir please make a video how to use bootstap in laravel without cdn link..

Y
YSK Developer
5

informative

Show More
Recommended Courses
Course Content

  1. Introduction to Laravel Framework
    13m 3s

  1. Prerequisite to Learn Laravel
    15m 26s
  2. Composer
    13m 44s
  3. Installation of Laravel
    12m 46s
  4. Folder and File Structure of Laravel
    19m 46s
  5. Sample Laravel Application
    10m 44s

  1. Laravel Routing - Basic Routing and Redirect Routes
    15m 28s
  2. Laravel Routing - View Routes, Named Routes, Route Parameters and Route Caching
    21m 34s
  3. Assignment: Laravel Routing
    3m 26s

  1. Introduction to Laravel Controller
    11m 11s
  2. Routing Controllers in Laravel
    8m 43s
  3. Resource Controllers in Laravel
    18m 23s
  4. Assignment: Laravel Controller
    3m 28s

  1. Introduction to Middleware
    11m 35s
  2. Global Middleware in Laravel
    12m 25s
  3. Group Middleware in Laravel
    13m 33s
  4. Route Middleware in Laravel
    10m 32s
  5. Controller Middleware in Laravel
    11m 4s
  6. Assignment: Laravel Middleware
    5m 12s

  1. Laravel Views
    17m 48s
  2. Passing Data to Views
    18m 48s
  3. Assignment: Laravel Views
    2m 28s

  1. Introduction to Blade Template
    14m 23s
  2. Blade Directives - Conditional Statements
    22m 46s
  3. Blade Directives - Iterative Statements
    19m 9s
  4. Laravel Components
    15m 57s
  5. Assignment: Laravel Blade Template
    2m 45s

  1. Laravel Helpers
    8m 2s
  2. Laravel Helpers - Array and Object Methods
    16m 8s
  3. Laravel Helpers - Path Methods
    7m 9s
  4. Laravel Helpers - String Methods
    18m 10s
  5. Laravel Helpers - Fluent String Methods
    12m 15s
  6. Laravel Helpers - URL Methods
    14m 3s
  7. Laravel Helpers - Miscellaneous Methods
    18m 13s
  8. Laravel Custom Helpers
    23m 58s
  9. Assignment: Laravel Helpers
    1m 20s

  1. Laravel HTTP Client
    18m 53s
  2. Laravel HTTP Request Methods
    19m 23s
  3. Laravel HTTP Request Methods Demo
    13m 42s
  4. Assignment: Laravel HTTP Client
    2m 38s

  1. Laravel Session
    13m 47s
  2. Laravel HTTP Session Handling
    18m 35s
  3. More About Laravel HTTP Session Handling
    15m 31s
  4. Session Flash Data in Laravel
    27m 46s

  1. Introduction to Laravel Database
    14m 8s
  2. Laravel Database - Running SQL Queries
    23m 24s
  3. Laravel Query Builder - Retrieving Data
    18m 40s
  4. Laravel Query Builder - Aggregate Functions
    13m 32s
  5. Laravel Query Builder - Select Statements
    15m 50s
  6. Laravel Query Builder - Joins and Unions
    16m 16s
  7. Laravel Query Builder - where and wherebetween Queries
    17m 45s
  8. Laravel Query Builder - whereIn, whereNull, whereDate and whereColumn Queries
    18m 7s
  9. Laravel Query Builder - Ordering
    8m 34s
  10. Laravel Query Builder - Grouping
    7m 29s
  11. Laravel Query Builder - Limit and Offset
    7m 57s
  12. Laravel Query Builder - Insert, Update and Delete Statements
    22m 13s
  13. Laravel Database - Migrations
    17m 44s
  14. Laravel Database - Migration Commands
    14m 24s
  15. Laravel Database - Seeding
    20m 2s
  16. Assignment: Laravel Query Builder
    2m 17s

  1. Laravel Eloquent ORM - Introduction & Models
    20m 15s
  2. Laravel Eloquent ORM - One To One Relationship
    25m 40s
  3. Laravel Eloquent ORM - One To Many Relationship
    4m 45s
  4. Laravel Eloquent ORM - Many To Many Relationship
    12m 15s
  5. Laravel Eloquent ORM - Has One Through Relationship
    30m 46s
  6. Laravel Eloquent ORM - Has Many Through Relationship
    13m 10s
  7. Laravel Eloquent ORM - One to One Polymorphic Relationship
    25m 33s
  8. Laravel Eloquent ORM - One to Many Polymorphic Relationship
    4m 30s
  9. Laravel Eloquent ORM - Many to Many Polymorphic Relationship
    21m 40s
  10. Laravel Eloquent ORM - Accessors
    13m 36s
  11. Laravel Eloquent ORM - Mutators
    8m 10s
  12. Assignment: Laravel Eloquent ORM
    2m 32s

  1. Laravel Route Model Binding - Implicit Binding
    21m 30s
  2. Laravel Route Model Binding - Explicit Binding
    12m 54s
  3. Assignment: Laravel Route Model Binding
    1m 12s

  1. Laravel - Basics of Localization
    20m 16s
  2. Laravel - More About Localization
    11m 43s
  3. Laravel - Localization Example
    27m 45s
  4. Assignment: Laravel Localization
    1m

  1. Laravel CRUD Operations - Initialization
    17m 55s
  2. Laravel CRUD Operations - Create Operation
    22m 39s
  3. Laravel CRUD Operations - Image Upload
    7m 58s
  4. Laravel CRUD Operations - Read Operation
    10m 21s
  5. Laravel CRUD - Show Operation
    16m 48s
  6. Laravel CRUD - Update Operation
    14m 7s
  7. Laravel CRUD - Delete Operation
    4m 13s
  8. Laravel CRUD - Pagination
    7m 7s

  1. Laravel Validations
    23m 37s
  2. Assignment: Laravel Validations
    1m 47s

  1. Laravel - Mail
    32m 44s
  2. Assignment: Laravel Mail
    1m 36s

  1. Laravel - Queues and Jobs
    14m 44s
  2. Laravel - Queues and Jobs Example
    19m 1s
  3. Assignment: Laravel Jobs and Queues
    1m 37s

  1. Laravel - Events
    24m 10s
  2. Assignment: Laravel Events
    1m 51s

  1. Laravel - Artisan Console
    12m 33s
  2. Laravel - Artisan Console Closure Commands
    9m 24s
  3. Laravel - Artisan Console Input Expectations
    12m 32s
  4. Laravel - Artisan Console Command I-O
    22m 12s
  5. Laravel - Artisan Console Programmatically Executing Command
    13m 15s
  6. Laravel - Artisan Console Task Scheduling
    12m 14s
  7. Assignment: Laravel Artisan Console
    2m 10s

  1. Laravel - Introduction to API
    12m 18s
  2. Laravel API CRUD Operations - Read Operation
    13m 43s
  3. Laravel API CRUD Operations - Create Operation
    18m 54s
  4. Laravel API CRUD Operations - Update Operation
    11m 8s
  5. Laravel API CRUD Operations - Delete Operation
    9m 32s

  1. Introduction and Basic Internal Changes in Laravel - 9
    21m 5s
  2. Controller Route Group in Laravel - 9
    8m
  3. Full-Text Indexes and Where Clauses in Laravel - 9
    14m 4s
  4. Accessors and Mutators in Laravel - 9
    10m 53s
  5. Enum Eloquent Attribute Casting in Laravel - 9
    11m 53s
  6. Implicit Route Binding with Enum in Laravel - 9
    6m 1s
  7. Rendering Inline Blade Templates in Laravel - 9
    6m 3s
  8. New Helpers in Laravel - 9
    10m 21s

  1. Laravel Project - Template Integration
    15m 29s
  2. Laravel Project - User Registration
    44m 20s
  3. Laravel Project - Authentication
    18m 34s
  4. Laravel Project - Manage User Profile
    24m 37s
  5. Laravel Project - Forgot Password
    33m 16s
  6. Laravel Project - Admin Panel Integration
    25m 23s
  7. Laravel Project - Manage Users Module
    50m 26s
  8. Laravel Project - Manage Brands Module
    41m
  9. Laravel Project - Manage Products Module
    49m 49s
  10. Laravel Project - Insert Product Data Using Faker
    12m 54s
  11. Laravel Project - Show Products on the Home Page
    40m 2s
  12. Laravel Project - Manage Product List with Filters
    28m 9s
  13. Laravel Project - Manage Cart Functionality
    38m 36s
  14. Laravel Project - Store Order Functionality
    29m 8s
  15. Laravel Project - List Order Functionality
    42m 59s

  1. Course Summary
    10m 22s

  1. Interview Questions Part 1
    22m 2s
  2. Interview Questions Part 2
    28m 13s

  1. Career Guidelines
    14m 56s
Enroll For Free