CampusX Data Science Mentorship Program 2022-23 - Session 36 - Window Functions in SQL | DSMP 2023

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