Advanced SQL ? Window Functions/ with Ami Levin.

Format:

Video

Author/Creator:

Levin, Ami, speaker.

Contributor:

linkedin.com (Firm)

Language:

English

Genre:

Instructional films.

Educational films.

Video recordings.

Physical Description:

1 online resource

polychrome

Place of Publication:

Carpenteria, CA: linkedin.com, 2020.

System Details:

Latest version of the following browsers: Chrome, Safari, Firefox, or Internet Explorer. Adobe Flash Player Plugin. JavaScript and cookies must be enabled. A broadband Internet connection.

Summary:

Learn how aggregate, rank, offset, and distribution window functions work? how to implement them efficiently, and how to solve the toughest SQL challenges elegantly.

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.

Participant:

Presenter: Ami Levin

Notes:

5/28/2020

Access Restriction:

Restricted for use by site license.