Advanced  SQL – Window Functions Preview

Advanced SQL – Window Functions

With Ami Levin Liked by 1,101 users
Duration: 1h 56m Skill level: Advanced Released: 5/28/2020

Start my 1-month free trial

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

Meet the instructor

Learner reviews

4.7 out of 5

655 ratings
  • 5 star
    Current value: 535 81%
  • 4 star
    Current value: 84 12%
  • 3 star
    Current value: 23 3%
  • 2 star
    Current value: 5 <1%
  • 1 star
    Current value: 8 1%

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

Similar courses

Download courses

Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.