Every app has a database. Every company stores data. And the way you talk to databases? SQL. It's not a programming language like others – it's a query language. And it's actually pretty fun once you get it.
Hour 1 – Asking Questions to Databases:
Think of SQL as just asking questions. "Give me all users." "Show me orders from last month." "Who spent the most money?"
We'll:
-
Set up a simple database (SQLite – no installation headaches)
-
Learn SELECT – the most important word
-
Filter with WHERE – get only what you need
-
Sort with ORDER BY – oldest first? highest first? your choice
We'll practice on real datasets – movies, cricket players, your imaginary e-commerce store.
Hour 2 – Joins and Real Queries:
Now the good stuff:
-
Combine data from multiple tables (JOIN) – like matching orders with customers
-
Group data (GROUP BY) – total sales by month, average marks by class
-
Update and delete (carefully!)
We'll build queries for real scenarios: "Find top 3 customers", "Products never ordered", "Students who improved this semester".
Who is this for? Beginners in data. Developers who've avoided databases. Anyone applying for jobs – SQL questions come up everywhere.
What you'll leave with: SQL skills that work in MySQL, PostgreSQL, any database. Ability to pull your own data. Confidence for interview questions.
Bring laptop. No database experience needed.