In this course we’ll dive into advanced SQL concepts like aggregate functions and summary statistics. These concepts are key in helping learners perform a variety of useful functions to gain insights from extensive datasets.

This course focuses on the following points:

• Establishing a foundation in computing statistics in SQL.
• Building proficiency employing and combining aggregate functions and clauses.
• Excelling in writing complex, impactful and real-world SQL queries.

The Program

1. Aggregate Functions with SQL.
2. Summary Statistics with SQL.
3. Group Summary Statistics with SQL.
4. Multiple Group Summary Statistics.

What will you learn

• How to employ SQL to compute statistics.
• How to filter results over groups.
• How to provide statistics by group.