SQL Window Functions for Analytics

提供方
Coursera Project Network
在此指导项目中,您将:

Understand how SQL window functions work and how to use them

Manipulate data in tables using SQL SELECT statements together with window functions

Use different SQL windows to get database insights

Clock2 hours
Advanced高级设置
Cloud无需下载
Video分屏视频
Comment Dots英语(English)
Laptop仅限桌面

Welcome to this project-based course SQL Window Functions for Analytics. This is a hands-on project that will help SQL users use window functions extensively for database insights. In this project, you will learn how to explore and query the project-db database extensively. We will start this hands-on project by retrieving the data in the table in the database. By the end of this 2-hour-and-a-half-long project, you will be able to use different window functions to retrieve the desired result from a database. In this project, you will learn how to use SQL window functions like ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), and LAST_VALUE() to manipulate data in the project-db database. Also, we will consider how to use aggregate window functions. These window functions will be used together with the OVER() clause to query this database. By extension, we will use grouping functions like GROUPING SETS(), ROLLUP(), and CUBE() to retrieve sublevel and grand totals.

您要培养的技能

  • Data Manipulation
  • CTE
  • Subqueries
  • Postgresql
  • Window Function

分步进行学习

在与您的工作区一起在分屏中播放的视频中,您的授课教师将指导您完成每个步骤:

  1. Getting Started

  2. Window Functions - Refresher

  3. Ranking

  4. Paging: NTILE()

  5. Aggregate Window Functions - Part One

  6. Aggregate Window Functions - Part Two

  7. Window Frames - Part One

  8. Window Frames - Part Two

  9. GROUPING SETS(), ROLLUP(), & CUBE()

指导项目工作原理

您的工作空间就是浏览器中的云桌面,无需下载

在分屏视频中,您的授课教师会为您提供分步指导

常见问题

常见问题

还有其他问题吗?请访问 学生帮助中心