6 System defined vs User defined database functions | Aggregate Functions

Hi All,

Another video part of database series. In this lecture, i explained what is the difference between system defined vs user defined database functions. I also explained the example of aggregate functions like Count, Max, Min, Sum & Avg

Also covered practical example using oracle live sql.

Video
00:00 System defined vs user defined database functions
02:08 What is database function
3:08 Aggregate Functions
3:48 Count Function
4:34 Sum Function
4:49 Avg Function
5:08 Max Function
5:18 Min Function
5:35 Group By and Having clause
6:45 User Defined Function with Example

WhiteBoard Link

Web

Facebook

Instagram

Twitter

Medium

Query

#function #databasefunction #userdefinedfunction