Learn SQL with Metabase
Get set up with Metabase and start querying.
Get up and running with Metabase
- Download the free, open-source version of Metabase.
- Sign up for a free trial of Metabase Cloud.
Start a new SQL question
To follow along in Metabase with the examples in these tutorials, open up Metabase, click on the + New button and select SQL query. For the data source, select Sample Database. See the SQL editor.
Why learn SQL with Metabase
- Metabase is free forever. (Though if you want to sign up for a free 14-day Metabase Cloud trial, you’ll need an email and credit card).
- It has a graphical query builder that shows you the SQL it generates, so you can learn as you go.
- It ships with a Sample Database you can play around with.
- You can connect Metabase to your own database, or upload CSV files to explore your data. If you’re on a Cloud plan with Storage, you can connect Metabase to a Google Drive folder to sync Google Sheets.
Even SQL experts often prefer the query builder because it’s faster, and questions built with it produce interactive charts that people can drill through. And if you want to noodle on the code it generates, you can always convert the question to a SQL query.
SQL to get data
SQL to filter data
Working with SQL
- Best practices for writing SQL
- Working with dates in SQL
- Calculating customer lifetime value (LTV) with Metabase
- Using common table expressions (CTEs)
- Types of SQL joins
- How to join tables in SQL
- SQL syntax reference
Debugging SQL
- Debugging SQL logic
- Fixing missing data in SQL results
- Fixing duplicated data in SQL results
- Debugging SQL syntax errors
More tutorials coming soon!
Stay tuned.
Next: SQL querying tables
Learn how to use SQL SELECT, FROM, LIMIT, ORDER BY, and AS to query and sort tables.
Next article