Session 36 - Window Functions in SQL | DSMP 2023
Channel: CampusX
Date: 2023-02-27

Session 36 - Window Functions in SQL | DSMP 2023
-------------------------------------------------------------------------------------------------------------------------------------------------------
Dataset Link - https://drive.google.com/drive/folders/1xCNbO_LJIkr7bi9YDa7hUFYgJ-IZ01A-?usp=share_link

Code - https://docs.google.com/document/d/1PyAU4tBcBxUR5Vn4GEZngPJXkKArAHqUBZgCCu1fFk4/edit?usp=sharing

Task 36 - https://colab.research.google.com/drive/1EuxChezFh9H772RPJQvoeoO-aheCFAs_?usp=sharing

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 - https://learnwith.campusx.in/

Course Website Link - https://campusx1040.graphy.com/s/preview/courses/CampusX-Data-Science-Mentorship-Program#6376dbd8e4b065a4cadac4db

YouTube Playlist - https://www.youtube.com/playlist?list=PLKnIA16_RmvbAlyx4_rdtR66B7EHX5k3z
-------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Operators - https://drive.google.com/file/d/13Cu0VUqbENcUX76bx_aoBS0EAtzDPDrE/view?usp=share_link
InfyTQ ANimation Course Link -https://infytq.onwingspan.com/web/en/app/toc/lex_auth_01275806667282022456_shared/overview
--------------------------------------------------------------------------------------------------------------------------------------------------------
SQL SubQuery session's PDF: https://drive.google.com/file/d/11efqFezqmghTq3wvbPkTFUDHUBcG-SSF/view?usp=share_link

---------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Windows Function Session PDF: https://drive.google.com/file/d/1Yn9DWTuzLr4uCbZXSOn-9wgz_q18nGN-/view?usp=share_link
----------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------
| 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