week 3 IITM BS DBMS Mastering intermediate SQL

This instructional module from a Database Management Systems course outlines key concepts in SQL query construction, presented by Partha Pratim Das. The core topics covered are Set Operations, such as union, intersect, and except, along with their multiset variations, which are used to combine or compare the results of different queries. A significant focus is placed on handling Null Values, explaining that they denote unknown or non-existent data and necessitate the use of Three Valued Logic (true, false, unknown) because standard comparison operators fail. Finally, the module addresses Aggregate Functions (like avg, min, max, sum, and count), demonstrating their use with the Group By and Having clauses to perform calculations across grouped data, while also noting that aggregates typically ignore null values.

Видео week 3 IITM BS DBMS Mastering intermediate SQL канала Gireesh Bhat