Pragya's email address and phone number have been validated.
Pragya
- Rate Ksh. 2,285
- Response 1h
Ksh. 2,285/hr
See Pyhton tutors
Unfortunately, this tutor is unavailable
- Pyhton
- Programming Languages
- SQL
Monash Master of Data Science Graduate | SQL & Database Tutor | Taught Undergrad & Postgrad Units at University | MySQL, PostgreSQL, Query Writing, Normalisation
- Pyhton
- Programming Languages
- SQL
Lesson location
About Pragya
I'm a Master of Data Science graduate from Monash University, and I've spent the a year post graduation, teaching database subjects to both undergraduate and postgraduate students at the university.
That teaching experience shapes how I tutor. Sitting in consultation hours with dozens of students, you learn quickly that most people don't struggle with SQL syntax, they struggle with the model underneath it. They can write a SELECT statement but can't picture what a join is actually doing to the rows, so the moment a question changes shape, they're stuck. I teach the mental model first and the syntax second, which is why students tend to stop needing me sooner than they expect.
I now tutor SQL online, working with university students, career changers moving into data roles, and professionals who need to query their own company's database without waiting on an analyst.
See more
About the lesson
- Lower Primary
- Upper Primary
- Lower Secondary
- +11
levels :
Lower Primary
Upper Primary
Lower Secondary
Tertiary
Adult Education
Masters
Diploma
Doctorate
Pre-Primary
Beginner
Intermediate
Advanced
Professional
Children
- English
All languages in which the lesson is available :
English
Who I work with
University students (undergraduate and postgraduate) taking database or data management units, career changers preparing for data analyst roles, and working professionals who need SQL for their day-to-day job.
What we cover
• SQL fundamentals — SELECT, WHERE, ORDER BY, aggregate functions, GROUP BY and HAVING
• Joins — inner, outer, self-joins, and why the wrong join silently gives you the wrong number
• Subqueries, CTEs and window functions
• Database design — ER modelling, keys, relationships, normalisation to 3NF/BCNF
• Stored procedures, triggers, views and indexing
• Query performance and reading an execution plan
• MySQL, PostgreSQL, SQL Server and SQLite
• Interview preparation — the SQL questions that actually come up in data analyst and data engineer screens
How a lesson runs
We start with what you're stuck on, not with a fixed syllabus. I'll usually ask you to attempt a query out loud before I show you anything — it's the fastest way for both of us to find the exact point where your understanding breaks. Then we work on live queries against a real database rather than reading slides. You keep the queries and notes afterwards.
On assignments
I'm glad to help with coursework, and I'll work through it with you — explaining the concepts, checking your logic, and helping you debug. I don't complete assignments on a student's behalf. If that's what you need, I'm not the right tutor. If you want to understand the material well enough to defend your own answer, I'm exactly the right tutor.
First lesson
The first session is free. We'll talk through what you're studying, where you're getting stuck and what timeline you're working to, and I'll tell you honestly how many sessions I think it'll take.
See more
Rates
Rate
- Ksh. 2,285
Pack prices
- 5h: Ksh. 11,423
- 10h: Ksh. 22,847
online
- Ksh. 2,285/h
Similar Pyhton teachers in Melbourne
Patience
Nyeri & Online
- Ksh. 500/h
- 1st lesson free
Kelvin
Kisumu & Online
- Ksh. 2,500/h
- 1st lesson free
Geoffrey
Nairobi & Online
- Ksh. 2,500/h
- 1st lesson free
Samuel
Nairobi & Online
- Ksh. 1,500/h
- 1st lesson free
Ron
Nairobi & Online
- Ksh. 4,000/h
- 1st lesson free
Faith
Ruiru & Online
- Ksh. 800/h
- 1st lesson free
Sylvester
Nairobi & Online
- Ksh. 2,500/h
- 1st lesson free
Rose
Nairobi & Online
- Ksh. 2,500/h
- 1st lesson free
Denis
Konza & Online
- Ksh. 500/h
- 1st lesson free
Joseph
Githurai & Online
- Ksh. 2,000/h
- 1st lesson free
Reza
Brooklyn, United States & Online
- Ksh. 5,175/h
- 1st lesson free
Ilian
Paris 8e, France & Online
- Ksh. 3,731/h
- 1st lesson free
Reza
London, United Kingdom & Online
- Ksh. 6,109/h
- 1st lesson free
ADAM
Paris 12e, France & Online
- Ksh. 7,461/h
- 1st lesson free
João
London, United Kingdom & Online
- Ksh. 5,236/h
- 1st lesson free
Massimiliano
Ancona, Italy & Online
- Ksh. 4,477/h
- 1st lesson free
Mourad
Paris 12e, France & Online
- Ksh. 5,969/h
- 1st lesson free
Ammar
Montréal, Canada & Online
- Ksh. 2,787/h
- 1st lesson free
Esmaeil
New York, United States & Online
- Ksh. 3,881/h
- 1st lesson free
Reihane
Guelph, Canada & Online
- Ksh. 4,645/h
- 1st lesson free
-
See Pyhton tutors
