From the course: Advanced SQL – Window Functions
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Tools and demo database - SQL Tutorial
From the course: Advanced SQL – Window Functions
Tools and demo database
- [Instructor] I'll be using the PostgreSQL relational database management system for all demos and challenges. To save my throat and your time, I'm going to use the term database instead of relational database management system, and Postgres instead of PostgreSQL. Postgres offers one of the richest window function support among all mainstream databases. And I reserve the right to mention other databases whose implementation differences may be a value or just to publicly shame them. I'll be using Microsoft Azure data studio integrated development environment with a Postgres extension. If you don't have access to an instance of Postgres, you can still use an online query service. These services requires zero installation, they're 100% a web based, and even the server is hosted by the service providers. You might be familiar with some of these like SQL Fiddle, DB Fiddle and Rextester to name a few. My favorite one, however…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.