PostgreSQL Summary Stats and Window Functions

Name: PostgreSQL Summary Stats and Window Functions
Brand: Careervira
Price: 149 USD
Availability: InStock
Rating: 5.0 (3 reviews)

DataCamp

(3)

Course Report

Find detailed report of this course which helps you make an informed decision on its relevance to your learning needs. Find out the course's popularity among Careervira users and the job roles that would find the course relevant for their upskilling here. You can also find how this course compares against similar courses and much more in the course report.

Visit Course Report

Course Features

Duration

4 hours

Delivery Method

Online

Available on

Limited Access

Accessibility

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Teaching Type

Self Paced

Video Content

4 hours

Course Description

Wondering how data professionals use SQL to solve business problems such as deduplicating data and creating rankings? Or calculating running totals or moving averages? If you're familiar with SQL, this course will teach you how to select, filter, join, join and group data. By the end of the course, you will be able write queries like a pro! You will learn how to use window functions, the SQL secret tool, to create queries for data engineering or analytics. It will be easy to learn how windows functions work and how flexible and efficient they can be used with flights data.

Course Overview

Virtual Labs

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Intermediate SQL

What You Will Learn

Learn how to create queries for analytics and data engineering with window functions, the SQL secret weapon!

You will learn how to create queries for analytics and data engineering with window functions, the SQL secret weapon!

Using flights data, you will discover how simple it is to use window functions, and how flexible and efficient they are

Course Content

Expand all sections

Module 1: Introduction to window functions

Module 2: Fetching, ranking, and paging

Module 3: Aggregate window functions and frames

Module 4: Beyond window functions

Course Instructors

Fernando Gonzalez Prada

Data Science Consultant

Fernando is a data science professional with over 20 years of experience in databases, data integration, machine learning, and business intelligence. He designs analytics solutions with Microsoft Dat...

Michel Semaan

Data Scientist

Michel is a data scientist who's worked at leading Middle-Eastern startups like Bookwitty (e-commerce) and Anghami (music streaming). He loves using open-source technologies like Python, R, and SQL to analyze data, optimize KPIs, and solve problems.

Course Reviews

Average Rating Based on 3 reviews

5.0

100%