Skip to content

00. Download the Project

This project manages all source code, the data generator, and documentation on GitHub.

Since the documentation is updated frequently, we recommend using Git to always stay up to date. If you're new to Git, refer to the instructions below.

What is Git?

Git is a version control system that tracks changes to files. For this tutorial, you only need to know two things:

  • git clone — Copy the project to your computer
  • git pull — Get subsequent updates with a single command

How to Install Git (click to expand)

Choose one of the following methods:

Option 1: Installer (most common)

Download and install from git-scm.com. Keep the default options during installation.

Option 2: winget (built into Windows 11)

winget install Git.Git

Option 3: Chocolatey

choco install git

After installation, verify in Command Prompt or Git Bash:

git --version

Type git --version in Terminal. If Git is not installed, a Command Line Tools installation dialog will appear automatically. Click "Install".

# This triggers the automatic install prompt if Git is missing
git --version

# Or install directly
xcode-select --install

Different from Homebrew's Git?

xcode-select --install provides Apple's stable Git version. Homebrew (brew install git) provides the latest version, but either works fine for this tutorial. If you haven't installed Homebrew yet, Command Line Tools alone is sufficient.

sudo apt update && sudo apt install git
git --version

# Fedora
sudo dnf install git

# RHEL / CentOS
sudo yum install git

git --version

Download Methods

git clone https://github.com/civilian7/sql-tutorial.git
cd sql-tutorial

When updates are available later:

git pull

If the command line is difficult, you can use GitHub Desktop.

  1. Install and launch GitHub Desktop
  2. Select File > Clone repository
  3. In the URL tab, enter https://github.com/civilian7/sql-tutorial.git
  4. Specify a local path and click Clone
  5. For updates: Click Fetch origin at the top, then Pull origin

You can start immediately without Git, but you'll need to re-download each time to get updates.

  1. Download ZIP from GitHub
  2. Extract the downloaded file
  3. Navigate to the extracted folder (sql-tutorial-main)

ZIP Limitations

ZIP is a snapshot from the time of download. You won't receive updates such as new lessons or bug fixes.

Verify the Download

If you see the following files in the project folder, everything is correct:

sql-tutorial/
├── requirements.txt     ← Python dependencies
├── config.yaml          ← Generation config
├── src/                 ← Generator, verifier, and utility source code
├── data/                ← Product/category master data
├── docs/                ← Tutorial documents
└── output/              ← (After generation) DB/SQL output

← Getting Started 01. Choose a Database →