AGGREGATE FUNCTIONS IN SQL AND RELATIONAL ALGEBRA IN DBMS | IN HINDI | DBMS PART 8 | JOA IT

Описание: Hello everyone welcome to Himachal exams.
i hope you all are well
In this video You will learn about most important topic in DBMS.
in this video you will learn about DBMS PART 8
AGGREGATE FUNCTIONS AND RELATIONAL ALGEBRA

Aggregate function
5 built in aggregate functions in SQL
AVG
SUM
MAX
MIN
COUNT

Relational Algebra
Fundamental Operation in Relational Algebra are:
SELECTION (σ)
PROJECTION(∏ )Pi
UNION (U)
Set Difference Operator (R-S)
Intersection (∩)
Cartesian Product (RXS)
This video is very important for competitive exams like JOA IT ,Computer operator,clerk ,programmer,pgt it ,kvs,nvs and other competitive exams which are related to computer science
#joait #RLATIONALALGEBRA #AGGREGATEFUNCTIONS