Introduction to SQL Window Functions

Learn How Windowing Functions Works

Created by: Bluelime Learning Solutions
Making Learning Simple

What Will I Learn?

• Install Oracle database
• Install TOAD
• Install SQL Developer
• Connect TOAD and SQL Developer to Oracle
• Write syntax for analytic functions
• Use aggregate functions
• Use analytic functions
• Understand windowing clause
• Understand and use Partition By clause
• Understand and use Order By clause

Requirements

• Basic knowledge of SQL
• Basic knowledge of relational databases

Target audience

• Beginner data scientist
• Beginner data analyst
• Beginner DBA
• Anyone who wants to learn about SQL Window Functions