1st lesson free
Pragya's email address and phone number have been validated.
Pragya
- Rate 63AED
- Response 1h
63AED/hr
Contact
1st lesson free
- Python
- Programming languages
- SQL
SQL & Database Tutor | Previously Taught Undergrad & Postgrad Unit at Monash University | MySQL, PostgreSQL, Query Writing, Normalisation
- Python
- 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
- All Levels
- 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
Recommendations
Recommendations come from relatives, friends and acquaintances of the teacher
1
Pragya has taught me countless subjects ranging from Python & SQL to Data warehousing, modeling and statistical modeling. She is very patient and explained with great depth, especially coding and statistical concepts. I call her my closest friend who has helped me through academics and personality development.
View more recommendations
See more
Rates
Rate
- 63AED
Pack prices
- 5h: 316AED
- 10h: 632AED
free lessons
The first free lesson with Pragya will allow you to get to know each other and clearly specify your needs for your next lessons.
- 45mins
online
- 63AED/h
Similar Python teachers in Melbourne
-
![]( "teacher_picture")
Maryam
Dubai & Online- Experienced
Data science student engineer teaching programming languages for beginners and advanced learners
- 100AED/h
- 1st lesson free
-
![]( "teacher_picture")
Sara
Sharjah & Online- Super tutor
Master python ai sql postgresql c# .net | 7+ years of experience | build confidence & secure your career
- 39AED/h
- 1st lesson free
-
![]( "teacher_picture")
Amdad
Dubai & Online- Experienced
Experienced computing and programming tutor helping students master coding concepts and exam success
- 100AED/h
- 1st lesson free
-
![]( "teacher_picture")
Abdelrahman bassem
Dubai & Online- Experienced
Space engineer teaching python, ai ,ml, math, robotics and stem to students
- 100AED/h
- 1st lesson free
-
![]( "teacher_picture")
Neha
Dubai & Online- Experienced
Expert coding & computer programming tutor for all levels: middle school, high school, & university ,learn with me
- 200AED/h
- 1st lesson free
-
![]( "teacher_picture")
Zein
& Online- Experienced
Computer engineer with real life experience in teaching ml and data analysis to all ages.
- 100AED/h
- 1st lesson free
-
![]( "teacher_picture")
Aryan
Dubai & Online- Experienced
Experienced professional coding instructor with over 3 years of teaching experience in both usa and the uae, working with adults, professionals, students, and children
- 56AED/h
- 1st lesson free
-
![]( "teacher_picture")
Tushar
Dubai & Online- New
Programming, computer science & ai mentor (grades 9–12) | logic, problem solving & real world technology learning and computational thinking
- 70AED/h
- 1st lesson free
-
![]( "teacher_picture")
Ali
Dubai & Online- New
Experienced professional coding instructor with over 9 years of teaching experience in both canada and the uae, working with adults, professionals, students, and children
- 200AED/h
- 1st lesson free
-
![]( "teacher_picture")
Toka
Abu Dhabi & Online- New
->graduate from helwan university faculty of computer engineering, egypt. ->teaches python, sql, machine learning, and fundamentals of artificial intelligence -> have experience in teaching python fo
- 70AED/h
- 1st lesson free
-
![]( "teacher_picture")
Ashmit
Abu Dhabi & Online- Experienced
Learn python and ai from scratch with an nyu abu dhabi computer science student — practical online lessons for adult beginners
- 50AED/h
- 1st lesson free
-
![]( "teacher_picture")
Salim ahmed
Dubai & Online- Experienced
It instructor having over 15 years of experience in teaching software programming languages.
- 70AED/h
- 1st lesson free
-
![]( "teacher_picture")
Atif
Abu Dhabi & Online- Experienced
Software engineer teaches programming, web development, and computer science for beginners and intermediate students online.
- 60AED/h
- 1st lesson free
-
![]( "teacher_picture")
Shakeel
Abu Dhabi & Online- New
Build real-world coding skills — python, java & ai foundations taught by an experienced it professional
- 84AED/h
- 1st lesson free
-
![]( "teacher_picture")
Fayyaz ahmed
Abu Dhabi & Online- New
Graduated from the university of arizona with a master's in data science and a bachelor's in computer science. i am willing to teach python programming language (bachelor's level), ai/ml concepts (bac
- 40AED/h
- 1st lesson free
-
![]( "teacher_picture")
Habiboulaye
Dubai & Online- New
Phd in artificial intelligence | university lecturer & speaker and expert in industry | 18+ years leading industry projects to make business impact| learn from a proven expert in machine learning
- 246AED/h
- 1st lesson free
-
![]( "teacher_picture")
Rafia
Fujairah & Online- Experienced
Learn programming in an easy way to improve your skills happy programming
- 65AED/h
- 1st lesson free
-
![]( "teacher_picture")
Chijindu
Dubai & Online- New
Software, coding & workplace ai coach for adults, professionals and practical career growth
- 350AED/h
- 1st lesson free
-
![]( "teacher_picture")
Kishore
Dubai & Online- New
Data scientist with 3+ years experience teaches python, ai, machine learning & data science for all levels
- 39AED/h
- 1st lesson free
-
![]( "teacher_picture")
Advaith
Dubai & Online- New
Peer tutor and student at the university of wollongong in dubai. programing languages i teach are python, c++, and java. i also teach machine learning as well, both concepts and code. feel free to
- 50AED/h
- 1st lesson free
-
See Python tutors
