1. All topics
  2. Business
  3. Business Software and Tools
  4. Data Analysis
Advanced SQL – Window Functions Preview

Advanced SQL – Window Functions

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

Start my 1-month free trial Buy for my team

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.

Sample certificate

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

4.7 out of 5

753 ratings
  • 5 star
    Current value: 615 82%
  • 4 star
    Current value: 97 13%
  • 3 star
    Current value: 24 3%
  • 2 star
    Current value: 6 <1%
  • 1 star
    Current value: 11 1%
  • Divyaman Singh Rawat Divyaman Singh Rawat

    Divyaman Singh Rawat

    Data science graduate from Monash University, former Software Developer at SAP

    5/5 January 26, 2025
    This is a great course. Strongly recommended for data analysts.
    Helpful · Report
  • Jean Jacques Espoir Mboumba Jean Jacques Espoir Mboumba

    Jean Jacques Espoir Mboumba

    IT - Network, Systems and Database Administrator

    4/5 January 6, 2025
    I hope you will make this kind of course about sql to talk about the joint, json etc .. Good job thank you great moment
    Helpful · Report
  • Randy Rosso Randy Rosso

    Randy Rosso

    Anti-poverty advocate and food program data expert

    5/5 November 29, 2024
    The instructor is very clear and engaging, somehow managing to make window functions entertaining! I appreciate his friendly and accessible demeanor as well as his clear-eyed examples and explanations.
    Helpful · Report

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.

Download on the App Store Get it on Google Play