Basic SQL & Visualization Class

Before joining the session, please prepare the following tools on your laptop.

🟢 1. SQLite GUI (Portable)

We will use DB Browser for SQLite (no installation required).

👉 Download here:
https://sqlitebrowser.org/dl/

Choose:

• Windows → ZIP (no installer)
• Linux → AppImage

Run:

• Windows: extract → double click DB Browser for SQLite.exe
• Linux:

🔵 2. Metabase (Visualization Tool)

👉 Download Metabase JAR:
https://www.metabase.com/start/oss/jar.html

Save the file as:

🟡 3. Java (Portable — No Install Required)

Metabase requires Java to run.

👉 Download Java (ZIP version):
https://adoptium.net/

Choose:

• Version: Java 17 or 21 (LTS)
• Package: ZIP (NOT installer)

📁 Recommended Folder Setup

Create a folder like this:

▶️ 4. Run Metabase (Windows)

Create file run.bat inside metabase/:

Then double click:

Open in browser:

✅ Checklist (Before Class)

Make sure you can:

• Open DB Browser for SQLite
• Run Metabase (http://localhost:3000)
• No errors when running Java

🎯 What We Will Learn

• SQL basics (SELECT, JOIN, GROUP BY)
• Data processing (replace Excel formulas)
• Data visualization using Metabase

If you have any issue during setup, please ask before the session 👍