Getting Started
To use this tutorial, you need to prepare the following:
- Project source — Download from GitHub (Git or ZIP)
- Python 3.10+ — Required to run the data generator
- Database — SQLite (no installation needed), MySQL, PostgreSQL, Oracle, or SQL Server
- SQL tool — A program to open the generated database and run queries
Just want to read the docs?
You can read the entire tutorial on the web at GitHub Pages without any installation. However, you really need to practice querying to learn SQL.
Follow the 5 steps below. Even for beginners, 30 minutes is enough.
-
Get the source from GitHub. Choose between Git or ZIP
~2 min
-
Pick the right DB for you from SQLite, MySQL, PostgreSQL, Oracle, or SQL Server
~1 min
-
Install your chosen DB. SQLite requires no installation — you can skip this step
~5-10 min
-
Install Python and run the generator to create the database
~10 min
-
Detailed options for data size, language, noise, config files, etc. (optional)
As needed
-
Open the database in a SQL tool and run your first query
~5 min
Installation Summary by OS and DB
| Software | For SQLite | + MySQL | + PostgreSQL |
|---|---|---|---|
| Git | Required | Required | Required |
| Python | Required | Required | Required |
| MySQL Server | — | Required | — |
| PostgreSQL | — | — | Required |
| DBeaver (recommended) | Recommended | Recommended | Recommended |
| Software | For SQLite | + MySQL | + PostgreSQL |
|---|---|---|---|
| Git | Included | Included | Included |
brew install python@3.12 |
Required | Required | Required |
brew install mysql |
— | Required | — |
brew install postgresql@16 |
— | — | Required |
| DBeaver (recommended) | Recommended | Recommended | Recommended |
| Software | For SQLite | + MySQL | + PostgreSQL |
|---|---|---|---|
sudo apt install git |
Required | Required | Required |
sudo apt install python3 python3-pip |
Required | Required | Required |
sudo apt install mysql-server |
— | Required | — |
sudo apt install postgresql |
— | — | Required |
| DBeaver (recommended) | Recommended | Recommended | Recommended |
If Using SQLite Only
You only need to install Git + Python. No DB server installation needed, making it the fastest way to get started.
Detailed installation instructions for each step are provided on the respective pages.