Advanced SQL – Window Functions
With Ami Levin
Liked by 1,156 users
Duration: 2h 6m
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.Skills you’ll gain
Earn a sharable certificate
Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.
LinkedIn Learning
Certificate of Completion
-
Showcase on your LinkedIn profile under “Licenses and Certificate” section
-
Download or print out as PDF to share with others
-
Share as image online to demonstrate your skill
Meet the instructor
Learner reviews
-
Robert Remington
Robert Remington
-
Izzy Jones-McAuley
Izzy Jones-McAuley
Publishing Graduate @2K | Junior Narrative Designer, Limit Break Mentee, IG50 Winner 2022 | Msc Design Thinking for Sustainability | Costumier for…
-
Sargis Iskandaryan
Sargis Iskandaryan
Data Engineering | Data Analysis | Data Scientists | Machine Learning
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