Advanced SQL – Window Functions
With Ami Levin
Liked by 1,194 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
-
-
Divyaman Singh Rawat
Divyaman Singh Rawat
Data science graduate from Monash University, former Software Developer at SAP
-
Jean Jacques Espoir Mboumba
Jean Jacques Espoir Mboumba
IT - Network, Systems and Database Administrator
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