Mode is a collaborative data platform that combines SQL, R, Python, and visual analytics in one place. Connect, analyze, and share, faster.

This is the bread and butter of Mode—it's where you'll be able to use all the skills you learn in this tutorial. From the Query Editor, you can run queries against all of the data in Mode.

Sign into Mode using your email or username

Lesson 1 Using SQL in Mode Learn to use Mode's Query Editor to run SQL queries against data in a relational database. Start Now

The entire tutorial is meant to be completed using Mode, an analytics platform that brings together a SQL editor, Python notebook, and data visualization builder.

Mode is a modern, powerful and flexible data analytics platform that is easy to set up in a short time frame. It uses familiar SQL, Python, and R languages so analysts can get up and running …

Mode is a data analysis platform that combines a powerful, web-based SQL editor with charting and sharing tools. Connect your database and run, save, and share analyses.

You can check out a complete list of window functions in Postgres (the syntax Mode uses) in the Postgres documentation. If you're using window functions on a connected database, you …

Build your own modern reporting, backed up by governed datasets and metrics Build custom internal tools for thousands of data and business team needs Share the insights you find …

The Intermediate SQL Tutorial Welcome to the Intermediate SQL Tutorial! If you skipped the Basic SQL Tutorial, you should take a quick peek at this page to get an idea of how to use …