Advanced SQL – Window Functions
With Ami Levin
Liked by 1,101 users
Duration: 1h 56m
Skill level: Advanced
Released: 5/28/2020
Course details
Window functions are one of the most radical, fundamental enhancements to modern SQL. They allow access to neighboring rows without using subqueries, thus enabling amazing opportunities for concise, elegant, high-performing solutions.
This course teaches the foundations and intricacies of window function processing and how to use it to implement practical solutions to everyday challenges. You can learn how to use different constructs and advanced solution techniques and how to utilize the declarative and composable nature of SQL and its processing order. By the end of the course you’ll better understand the fundamental pros and cons of each method.
This course was created by Ami Levin. We are pleased to offer this training in our library.
This course teaches the foundations and intricacies of window function processing and how to use it to implement practical solutions to everyday challenges. You can learn how to use different constructs and advanced solution techniques and how to utilize the declarative and composable nature of SQL and its processing order. By the end of the course you’ll better understand the fundamental pros and cons of each method.
This course was created by Ami Levin. We are pleased to offer this training in our library.
Skills you’ll gain
Meet the instructor
Learner reviews
-
Adam L.
Adam L.
Data Enthusiast
-
Tuul Purevjav
Tuul Purevjav
Master of Applied Statistics Student at Colorado State University
-
Niketa Raman
Niketa Raman
Senior Data Scientist @ Prodapt | Data Science | Gen AI | Google Cloud Certified | Snowflake | Machine Learning | NLP | Deep Learning | AWS
Contents
What’s included
- Practice while you learn 1 exercise file
- Test your knowledge 5 quizzes
- Learn on the go Access on tablet and phone