Session 36 - Window Functions in SQL | DSMP 2023

Session 36 - Window Functions in SQL | DSMP 2023
-------------------------------------------------------------------------------------------------------------------------------------------------------
Dataset Link - drive.google.com/drive/folders/1xCNbO_LJIkr7bi9YDa…

Code - docs.google.com/document/d/1PyAU4tBcBxUR5Vn4GEZngP…

Task 36 - colab.research.google.com/drive/1EuxChezFh9H772RPJ…

CREATE TABLE marks (
student_id INTEGER PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(255),
branch VARCHAR(255),
marks INTEGER
);

INSERT INTO marks (name,branch,marks)VALUES
('Nitish','EEE',82),
('Rishabh','EEE',91),
('Anukant','EEE',69),
('Rupesh','EEE',55),
('Shubham','CSE',78),
('Ved','CSE',43),
('Deepak','CSE',98),
('Arpan','CSE',95),
('Vinay','ECE',95),
('Ankit','ECE',88),
('Anand','ECE',81),
('Rohit','ECE',95),
('Prashant','MECH',75),
('Amit','MECH',69),
('Sunny','MECH',39),
('Gautam','MECH',51)
-------------------------------------------------------------------------------------------------------------------------------------------------------
Enroll in this Programme from our Website - learnwith.campusx.in/

Course Website Link - campusx1040.graphy.com/s/preview/courses/CampusX-D…

YouTube Playlist -    • CampusX Data Science Mentorship Program 20...…
-------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Operators - drive.google.com/file/d/13Cu0VUqbENcUX76bx_aoBS0EA…
InfyTQ ANimation Course Link -infytq.onwingspan.com/web/en/app/toc/lex_auth_0127…
--------------------------------------------------------------------------------------------------------------------------------------------------------
SQL SubQuery session's PDF: drive.google.com/file/d/11efqFezqmghTq3wvbPkTFUDHU…

---------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Windows Function Session PDF: drive.google.com/file/d/1Yn9DWTuzLr4uCbZXSOn-9wgz_…
----------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------
| Time stamp |
-----------------------
00:00:00 - Session Start
00:04:06 - Agenda
00:05:46 - What are Window Functions?
00:11:41 - Aggregate Function with OVER() (Example #1)
00:15:52 - Example #2
00:21:21 - Doubt clearance
00:22:43 - Example #3
00:26:17 - RANK()
00:31:15 - DENSE_RANK()
00:33:08 - ROW_NUMBER()
00:37:05 - Short summary for the above 3 window functions
00:37:52 - Example #4
00:45:42 - Doubt clearance
00:47:15 - FIRST_VALUE()
00:51:20 - LAST_VALUE()
00:52:31 - Concept of Frames
01:05:02 - Doubt clearance
01:06:18 - NTH_VALUE()
01:08:21 - Example #5
01:15:29 - Have to paste the right result
01:18:14 - LAG()
01:20:39 - LEAD()
01:21:57 - Example #6
01:28:07 - Summary of the session
01:29:04 - Doubt clearance & Session end

#datanalytics #Database #DBMS #SQL #DML #sqlgroupby #groupby #sqlwindow