This is Part 1 of Get Started: get your laptop ready to write SQL. Choose Windows or Mac, pick the one-command installer or step by step, and verify everything works.
Open in Present mode · Next: Meet RetailMart · Try the playground
Jo video mein bola, yahan nukte mein likha hai.
What I said in the video, written here as key points.
Pehle laptop tayyar karo, phir query likhenge.
This is Part 1 of Get Started: get your laptop ready to write SQL. Every step below has its own page and video in Nukte.
practice=# promptNot sure? Take the one-command install. You can always come back and do it manually.
Not sure which one to take? Choose the one-command install. It downloads and configures PostgreSQL, pgAdmin 4, VS Code and Git automatically with the course defaults.
On Windows, download install_windows.ps1 and run it in PowerShell. On Mac, download install_mac.sh and run it in Terminal. See each step-by-step page for full instructions.
| Tool | Windows | Mac |
|---|---|---|
| Step by step (manual) | ||
| Homebrew | not needed on Windows | Install Homebrew |
| PostgreSQL | PostgreSQL and pgAdmin 4 | Install PostgreSQL |
| pgAdmin 4 | comes with PostgreSQL installer | Install pgAdmin 4 |
| VS Code | Install VS Code | VS Code and Git |
| Git | Install Git | same page as VS Code |
| Verify | Verify everything | Verify everything |
Full control over each tool · Every step has its own guide and video.
Every tool has its own dedicated step-by-step Nukte page and video guide with screenshots and terminal instructions.
Char zaroori tools. That's all you need for this entire SQL course.
These four tools form your local SQL development environment. No cloud subscriptions or paid software needed. Everything runs right on your computer.
Three version numbers and a practice=# prompt mean you're ready.
Open a new Terminal (Mac) or Git Bash (Windows) window and verify all tools. If all return version numbers and you can connect to the practice database, setup is complete.
Laptop tayyar hai! Now meet the database, then load it.
Once the tools are installed and verified, meet the database in Part 2 · Meet RetailMart, then load the 55 tables onto your laptop in Part 3 · Load the dataset.