Learn the most valuable skill for data analysis with our free, interactive SQL course in PushMetrics.
Learn SQL in PushMetrics's interactive Notebook. Make use of the demo database to learn SQL on a live connection and realistic data. Chapter 01 - What is SQL, SQL vs Spreadsheet, Relational Databases, Basic Datatypes.
To follow along the SQL tutorial and practice exercises, you need a PushMetrics workspace and your o
Let's dig into the basics of the SQL query syntax by querying a table called invoices. Each row in
Sorting dataLet's now introduce another SQL feature: sorting. As the name implies, it enables us to
Grouping data enables us to create an overview of some relevant dimensions of the underlying data, w
Up until now we have been querying a single table containing all the data related to our invoices:
Subqueries are, as the name suggests, queries nested within other queries and they can have several
Unions enable us to collect related data from multiple tables. Let’s explain its use case and synta
Window functions add another tool to our data analysis tool belt, enabling us to perform aggregatio
Sign up and start using PushMetrics for free.
Or schedule a demo and discuss your use case.