SQL Fundamentals

Data Manipulation in SQL

3. Correlated Queries, Nested Queries, and Common Table Expressions

• 3.1. Correlated subqueries
• 3.2. Nested subqueries
• 3.3. Common Table Expressions(CTE)
• 3.4. Deciding on techniques to use

4. Window Functions

• 4.1. It’s OVER
• 4.2. OVER with a PARTITION
• 4.3. Sliding windows
• 4.4. Bringing it all together

PostgreSQL Summary Stats and Window Functions

1. Introduction to window functions

• 1.1. Introduction
• 1.2. ORDER BY
• 1.3. PARTITION BY

2. Fetching, ranking, and paging

• 2.1. Fetching
• 2.2. Ranking