1^st lesson free

Pragya

5 (1 review)

Rate R294
Response 1h

5 (1 review)

R294/h

1^st 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

- online

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.

About the lesson

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.

Recommendations

Recommendations are written by the tutor's friends, family, and acquaintances.

O

Ounam

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.
Read more

O
Ounam
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.
See more recommendations

Rates

Rate

R294

Package rates

5h: R1469
10h: R2938

free lesson

The free first lesson with Pragya allows you to get to know the tutor and discuss your needs and expectations.

45min

online

R294/h

SQL & Database Tutor | Previously Taught Undergrad & Postgrad Unit at Monash University | MySQL, PostgreSQL, Query Writing, Normalisation

Lesson location

About Pragya

About the lesson

Recommendations

Rates

Rate

Package rates

free lesson

online

Similar Python tutor profiles

Information technology (it) delphi tutor | grade 8 - 12 | 8 years experience & proven track record

It graduate & experienced programming tutor | specializing in python, java, c#, and javascript | lessons for university/college students

Python for data analysis training, real business projects, dashboards, machine learning and analytics

Software engineer: teaching aspiring developers how to read and write code for working programmes. simplicity is better than complex, i explain concepts in the simplest way to help one understand.

Expert full-stack engineer & mentor: 5+ years teaching software development and data science from basics to advanced.

Senior in computer language more than 12 certificates achieved taught in more than 38+ schools

Former up cos 110 teaching assistant (2019) and uj csc3 teaching assistant (2025). i help anyone in need of understanding programming basics

Experienced software engineer & programming instructor | teaching computer programming in various languages (python, c#, java, javascript, html, css, and more) in your preferred learning style.

Computer science graduate offering programming and physics lessons online from eastern cape

Qualified and experienced python tutor helping beginners build strong coding foundations with patience and clarity.

Certified full stack developer with java, python, js, html/css, flutter end-to-end development

C programming- introduction and master level, from beginner to advanced level you will get impressive home works too.

Software engineer who teaches programming and problem solving skills,my lessons are made to meet individuals as we don't all learn the same

Software developer and uct alumni offering valuable expertise as well as a bootcamp to programming.

Computer programming expert with a personalized teaching approach, your coding journey is bound for success.

Programming like a pro: tutoring with a focus on practical applications for all skill levels!

Computer science & mathematics major, five years programming experience, three years teaching programming to beginners. engaging lessons and simple but practical explanations of concepts.

Software engineer & stellenbosch computer science graduate | programming, computer science & mathematics tutor (up to 3rd year)

Python programming instructor for 5 years. requirements, design, analysis code, test & deploy. join my zoom sessions and face to face sessions.

Computer science students who would love to learn python and become a pro.

SQL & Database Tutor | Previously Taught Undergrad & Postgrad Unit at Monash University | MySQL, PostgreSQL, Query Writing, Normalisation

Lesson location

About Pragya

About the lesson

Recommendations

Rates

Rate

Package rates

free lesson

online

Similar Python tutor profiles

Information technology (it) delphi tutor | grade 8 - 12 | 8 years experience & proven track record

It graduate & experienced programming tutor | specializing in python, java, c#, and javascript | lessons for university/college students

Python for data analysis training, real business projects, dashboards, machine learning and analytics

Software engineer: teaching aspiring developers how to read and write code for working programmes. simplicity is better than complex, i explain concepts in the simplest way to help one understand.

Expert full-stack engineer & mentor: 5+ years teaching software development and data science from basics to advanced.

Senior in computer language more than 12 certificates achieved taught in more than 38+ schools

Former up cos 110 teaching assistant (2019) and uj csc3 teaching assistant (2025). i help anyone in need of understanding programming basics

Experienced software engineer & programming instructor | teaching computer programming in various languages (python, c#, java, javascript, html, css, and more) in your preferred learning style.

Computer science graduate offering programming and physics lessons online from eastern cape

Qualified and experienced python tutor helping beginners build strong coding foundations with patience and clarity.

Certified full stack developer with java, python, js, html/css, flutter end-to-end development

C programming- introduction and master level, from beginner to advanced level you will get impressive home works too.

Software engineer who teaches programming and problem solving skills,my lessons are made to meet individuals as we don't all learn the same

Software developer and uct alumni offering valuable expertise as well as a bootcamp to programming.

Computer programming expert with a personalized teaching approach, your coding journey is bound for success.

Programming like a pro: tutoring with a focus on practical applications for all skill levels!

Computer science & mathematics major, five years programming experience, three years teaching programming to beginners. engaging lessons and simple but practical explanations of concepts.

Software engineer & stellenbosch computer science graduate | programming, computer science & mathematics tutor (up to 3rd year)

Python programming instructor for 5 years. requirements, design, analysis code, test & deploy. join my zoom sessions and face to face sessions.

Computer science students who would love to learn python and become a pro.

Share

Verified tutor profile

levels

Languages in which the lesson is available

Reviews

Évaluations

Recommendations

free lesson

Report this advert