SQL for Data Science - Window Functions
Learn the window functions of SQL for Data Science. Hands on Exercises. Covers theory and complete python code implementation.
- Learn the window functions of SQL for Data Science
- Hands on Exercises
- Covers theory and complete python code implementation
Prabhakaran SPrincipal Data Scientist
Included in All-Access, one membership for every course.
- Lessons
- 9, in 3 chapters
- Video
- 1 h 6 min
- Free to watch
- 1 lesson
- Certificate
- On completion
What you'll be able to do
- Introduction to Window Functions
- Winodw Functions types
- Syntax and Usage
- Advanced Examples
- Best Practices
Course content
3 chapters · 9 lessons · 1 h 6 min · 1 free to preview
01SQL Window Functions7 lessons · 59 min
- Understanding Window FunctionsPreview21:16
- Download Resources1:00
- Window Functions – Type 1 Ranking11:03
- Window Functions - Type 2 Comparing boundaries with Offsets5:00
- Offset Functions – Example 28:08
- Window Functions - Type 3 Rolling Aggregates with ROWS BETWEEN clause11:36
- Course Review1:00
02Self Assessment Test1 lesson · 5 min
- Window Functions Assignments5:06
03Pivoting Data in SQL1 lesson · 4 min
- Pivoting Data in SQL3:52
What you need
- Basics of Python
- Foundational knowledge of Data Science
- High school maths
Who this course is for
- Data Science Aspirants
- Data Science Professionals
- Software/Data engineers interested in quantitative analysis
- Professionals working with large datasets
- Data analysts, economists, researchers
Your instructor
Prabhakaran S
Principal Data Scientist
My name is Selva, and I am super excited to mentor you on this course!
I head the Data Science team for a global Fortune 500 company and over the last 10 years of my data science experience I've deployed 20+ global products. I'm also the Founder and Chief Author of Machine Learning Plus, which has over 4M annual readers.
I specialize in covering the in-depth intuition and maths of any concept or algorithm. And based on my existing student requests, I've put up the series of courses and projects with detailed explanations, just like on-the-job experience. Hope you love it!
- from 3,965 ratings
- 4.92
- learners
- 57K+
- courses
- 85
Questions
How do I get this course?
It is part of All-Access: one membership that opens all 85 courses. The plans and prices are on our course site. You can watch the free preview lessons before you join.
Can I get a refund?
Yes. If the membership is not right for you, ask for a refund within 30 days of your first payment.
Can I learn on my phone?
Yes. Lessons play in the browser on any phone, tablet or computer, and your place is saved for the next device.
I am already a member. Where are my courses?
On our course site, edu.machinelearningplus.com. Sign in there with the email you joined with. The courses move to this site later, with your access, and you will not pay again.
