Learn the most valuable skill for data analysis with our free, interactive SQL course in Query.me.
Learn SQL in Query.me'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 Query.me Workspace and your own
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