Session 36 - Window Functions in SQL | DSMP 2023 скачать в хорошем качестве

Session 36 - Window Functions in SQL | DSMP 2023

Session 36 - Window Functions in SQL | DSMP 2023 ------------------------------------------------------------------------------------------------------------------------------------------------------- Dataset Link - https://drive.google.com/drive/folder... Code - https://docs.google.com/document/d/1P... Task 36 - https://colab.research.google.com/dri... 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/prev... YouTube Playlist -    • CampusX Data Science Mentorship Program 20...   ------------------------------------------------------------------------------------------------------------------------------------------------------- SQL Operators - https://drive.google.com/file/d/13Cu0... InfyTQ ANimation Course Link -https://infytq.onwingspan.com/web/en/... -------------------------------------------------------------------------------------------------------------------------------------------------------- SQL SubQuery session's PDF: https://drive.google.com/file/d/11efq... --------------------------------------------------------------------------------------------------------------------------------------------------------- SQL Windows Function Session PDF: https://drive.google.com/file/d/1Yn9D... ---------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------- | 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