Five places matter: the course, the Setup page, Nukte (these notes), the playground and the database explorer. This page shows where everything is.
Jo video mein bola, yahan nukte mein likha hai.
What I said in the video, written here as key points.
Sab kuch ek jagah. A quick tour of where things are.
This is a complete tour of sql.theshiraverse.com, the home of this free SQL course. Five places matter: the course, the Setup page, Nukte (these notes), the playground and the database explorer.
The first is the hub. The second is the SQL course.
theshiraverse.com is the hub: everything TheShiraverse makes. sql.theshiraverse.com is the free SQL course. The menu at the top of the SQL site has a link back to the hub.
The home page shows the whole curriculum. Start at the top and go down.
The home page shows the full curriculum: a Get started section, then six modules, from Foundations to real analyst patterns. Topics are organised by subject, and each one is as long as it needs to be.
One page that tells you what to do, and where to find each step.
The Setup page is the map. It lists the four tools, the four steps, the installer downloads for Mac and Windows, and a link to the step-by-step Nukte page and video for each one. The detailed steps live in Nukte only.
Jo video mein bola, yahan nukte mein likha hai. What I said in the video, written here as key points.
Nukte has a notes page for every video, in the same order as the course. Each page has the key points, the commands to copy, and the fixes for common problems. Watch the video, then keep the page open beside you.
A quick taste, with nothing to install. Real practice happens on your own laptop.
The playground runs SQL in your browser on the real RetailMart data. It is a quick taste, useful when you do not have your laptop. For real practice, use your own PostgreSQL.
Look before you write a query.
The database explorer shows all 55 tables, their columns, real sample rows and an ER diagram with search. Use it whenever you wonder "which table has this?".
Stuck? Ask. Koi sawaal chhota nahi hota. No question is too small.
Questions go in the WhatsApp Community or on Discord. Get new-video alerts in the WhatsApp Channel. The videos are on YouTube.
Ek ek karke. One step at a time.
Go in this order: Meet RetailMart, then set up your laptop, load the dataset, and tour the database. Then Module 1.
Tell me in the comments. Milte hain agli video mein. Next: Module 1, Foundations.
Free SQL course and the Setup page, which maps every step. Join the WhatsApp Community, the Channel or Discord.