Home Courses Interview Preparation Course Aggregate Functions: COUNT, MIN, MAX, AVG, SUM

Aggregate Functions: COUNT, MIN, MAX, AVG, SUM

Instructor: admin Duration: 8 mins

This content is restricted. Please Login

Prev
Next
Logical Operators
GROUP BY
1.1
Functional Dependencies
35 min
1.2
Attribute Closure, Keys and Solved problems
45 min
1.3
Functional Dependency Sets and Properties + Solved examples
34 min
2.1
Introduction to Normalisation + 1NF and 2NF +examples
40 min
2.2
3NF and BCNF
30 min
2.3
Solved problems + Properties of Normal Forms
44 min
3.1
Introduction to Databases

22 min
3.2
Why SQL?

15 min
3.3
Execution of an SQL statement.

7 min
3.4
IMDB dataset

12 min
3.5
Installing MySQL

11 min
3.6
Load IMDB data

3 min
5.1
Join and Natural Join
12 min
5.2
Inner, Left, Right and Outer joins
22 min
6.1
Sub Queries/Nested Queries/Inner Queries
23 min
7.1
INSERT
6 min
7.2
UPDATE , DELETE
5 min
8.1
CREATE TABLE
11 min
8.2
ALTER: ADD, MODIFY, DROP
3 min
8.3
DROP TABLE, TRUNCATE, DELETE
3 min
9.1
Data Control Language: GRANT, REVOKE
10 min
10.1
Learning resources
3 min
11.1
Solved problems-1
26 min
11.2
Solved Problems-2
13 min
11.3
Solved Problems-3
15 min