#10 Aggregate Functions in SQL | Database Management | Class 12 CBSE Computer Science and IP
Welcome to the Part 10 of the Unit on Database Management by Bhargab Kakati for CBSE Class 12 Computer Science (083) and Informatics Practices (IP) Examination. In this part, i have discussed about various aggregate functions in SQL as per the syllabus.
If you haven't watched other parts of this unit , you may watch from the links below :
👉 Part 1 - Introduction to Databases
• #1 Introduction to Database Concepts | Dat...
👉 Part 2 - Keys and Its Types - Primary , Candidate , Alternate and Foreign Key
• #2 Keys and Its Types - Primary,Candidate,...
👉 Part 3 - Introduction to SQL
• #3 Introduction to SQL | Class 12 CBSE Com...
👉 Part 4 - Getting Started with SQL
• #4 Getting Started with SQL | Class 12 CBS...
👉 Part 5 - Data Filtering in SQL
• #5 Data Filtering in SQL | Database Manage...
👉 Part 6 - delete vs drop in SQL
• #6 Delete vs Drop in SQL | Database Manage...
👉 Part 7 - Pattern matching in SQL | like operator
• #7 Pattern Matching in SQL | like operator...
👉 Part 8 - Data Manipulation in SQL | alter vs update
• #8 Data Manipulation in SQL | alter vs upd...
👉 Part 9 - Sorting Data in SQL | order by
• #9 Sorting Data in SQL | order by | Databa...
👉 Part 10 - Aggregate Functions in SQL
• #10 Aggregate Functions in SQL | Database ...
👉Part 11 - Grouping Results in SQL | group by
• #11 Grouping Results in SQL | group by | D...
👉Part 12 - Joins in SQL | Equi Join and Natural Join
• #12 Joins in SQL | Equi Join and Natural J...
👉Part 13 - Constraints in SQL | Not Null , Unique , Primary Key and Default Constraint
• #13 Constraints in SQL | Not Null , Primar...
👉Part 14 - Foreign Key Constraint in SQL
• #14 Foreign Key Constraint in SQL | Class ...
This video is a part of my e- learning initiative during the days of novel Corona Virus .
Topics Covered:
Concept of Aggregate Functions
sum( ) in SQL
avg( ) in SQL
max( ) and min( ) in SQL
count( ) and count(*) in SQL
practical demonstration of all the SQL functions mentioned above.
Connect on these social media Handles:
👉 Instagram: / bhargab_kakati
👉 LinkedIn : / bhargabkakati
👉 Twitter : / bhargab008
#Database #SQL #Class12 #ComputerScience #MySQL #IP #AggregateFunctions
Bhargab Kakati
PGT (Computer Science)