SQL in PushMetrics

To follow along the SQL tutorial and practice exercises, you need a PushMetrics workspace and your own copy of the "Learn SQL" Notebook.

PushMetrics is a collaborative data workspace in which you can write and execute SQL queries (and more) in intuitive, GoogleDoc-like notebook documents.

If you haven't created a free PushMetrics account or signed in, you can do so here.

Open the Learn SQL Notebook.

What you will find is the public version of the Notebook in view mode.
To copy the Notebook, simply click the copy to own Workspace button on the top right:

Once copied, you will be able edit all blocks and run all SQL queries.

Executing a SQL-block

To run SQL query, simple click he play-button on the SQL block:

Note: SQL-blocks always have to be connected to a database.

Browse data

Navigate to the Data-tab to browse your Schemas, Tables, and Columns.
The Schema relevant to this tutorial is named learnsql .

Create your own SQL blocks

Use the 'add-block' menu or type the corresponding hotkeyinto an empty block.
The hotkey for SQL-blocks is --