Micro Free Course — 100% Free Learning
All lessons in this module are free to learn. Sign in with Google to save your progress.
3
AGGREGATIONS & GROUP BY, ORDER BY
Aggregate functions, ORDER BY, GROUP BY, HAVING, LIMIT and Aliasing
Module Progress0% Complete
55 min total
17 Lessons
0 Completed
Module Content
AGGREGATE FUNCTIONS
Understand aggregate functions like COUNT, SUM, AVG etc.
12 minVideo
Start
QUIZ: AGGREGATE FUNCTIONS
AGGREGATE FUNCTIONS
15 minTutorial
Start
CODING: AGGREGATE FUNCTIONS
15 minAssignment
Start
ORDER BY
Understand ORDER BY clause for reordering result
2 minVideo
Start
GROUP BY ORDER BY
Understand GROUP BY and aggregation
11 minVideo
Start
QUIZ: GROUP BY and ORDER BY
GROUP BY AND ORDER BY
15 minTutorial
Start
CODING: GROUP BY ORDER BY
15 minAssignment
Start
HAVING CLAUSE AND WHERE
Understand filtering with GROUP BY and difference between HAVING and WHERE
4 minVideo
Start
QUIZ: HAVING CLAUSE
HAVING CLAUSE
15 minTutorial
Start
CODING: HAVING CLAUSE AND WHERE
15 minAssignment
Start
LIMIT AND ALIASING
Understand LIMIT Clause and aliasing
4 minVideo
Start
CODING: LIMIT and ALIASING
15 minAssignment
Start
QUIZ: LIMIT and ALIASING
LIMIT and ALIASING
15 minTutorial
Start
QUIZ: MODULE 3
Aggregation, grouping, filtering, aliasing, ordering, and pagination
20 minTutorial
Start
CODING: MODULE 3 - 1
15 minAssignment
Start
CODING: MODULE 3 - 2
15 minAssignment
Start
CODING: MODULE 3 - 3
15 minAssignment
Start