1^st lesson free

Pragya

5 (1 review)

Rate $24
Response 1h

5 (1 review)

$24/h

1^st lesson free

Python
Computer languages
SQL

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

Python
Computer 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 come from relatives, friends and acquaintances of the tutor.

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.
View more recommendations

Rates

Rate

Pack rates

5 h: $122
10 h: $245

free lessons

This first lesson offered with Pragya will allow you to get to know each other and clearly specify your needs for your next lessons.

45min

online

$24/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

Pack rates

free lessons

online

Other tutors in Python

Coding tutor for kids, beginners and career changers | python, javascript, java, c/c++, react, ai & more | software & ml engineer, 7+ years tutoring

Seasoned programming tutor with 8+ years experience teaches python, java, c/c++ for all levels. ace your exams and assignments with expert assistance.

Master python, c++, java, vb.net, javascript, oop, algorithm design & software engineering with a phd engineer and professor | 25+ years’ expertise| beginner to university, research and professionals

Computer programming - phd in software engineering, experienced university instructor with more than 15 years of experience in programming. my research focuses on artificial intelligence and nlp, llm.

University of toronto computer science graduate: expert programming tutor (beginner to advanced)

Expert coding tutor (12+ yrs) in python, matlab, c/c++, java, javascript, sql, ai, data science and web development

Prof. trainer of python, java, javascript (sp prog. classes for kids | ap | ccc | coding competitions) learn web development: html/css, node.js, mysql, javascript (mern) stack from beginner to advance

Software developer giving java, javascript and python classes for students and professionals in vancouver!

Video game developer with 7 years of experience. video game development with unity, unreal engine or pygame. you choose! all levels. pc and mobile game development.

Seasoned software engineer teaching computer science and programming to students of all levels

Learn the art of python programming with personalized lessons from a seasoned tutor!

Coding! software! algorithms! hardware design! - uwaterloo masters graduate and intel software engineer here to help (all levels welcome)!

Experienced software engineer with 9 years tutoring—clear explanations, patient guidance, real results

Circuits, signals & control systems, analog and digital electronics, semiconductors, engineering math and physics

8+ years of proven programming expertise helping students succeed. learn python, java, and c/c++ at any level with clear, engaging guidance designed to boost your confidence and help you excel in exam

Phd student at sfu teaching c/python/matlab programming basic to advanced in burnaby, vancouver (pst timezone)

Class of learning how to have fun with python (easy to learn)

Master's in electrical engineering from mcmaster university | matlab, c, python & more | 7+ years experience in teaching

Phd, gives matlab and python class for university, college and high school students.

Software engineer with 2+ years industry experience. passionate about guiding students to success, offering tailored lessons and mentorship from beginner to advanced levels.

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

Pack rates

free lessons

online

Other tutors in Python

Coding tutor for kids, beginners and career changers | python, javascript, java, c/c++, react, ai & more | software & ml engineer, 7+ years tutoring

Seasoned programming tutor with 8+ years experience teaches python, java, c/c++ for all levels. ace your exams and assignments with expert assistance.

Master python, c++, java, vb.net, javascript, oop, algorithm design & software engineering with a phd engineer and professor | 25+ years’ expertise| beginner to university, research and professionals

Computer programming - phd in software engineering, experienced university instructor with more than 15 years of experience in programming. my research focuses on artificial intelligence and nlp, llm.

University of toronto computer science graduate: expert programming tutor (beginner to advanced)

Expert coding tutor (12+ yrs) in python, matlab, c/c++, java, javascript, sql, ai, data science and web development

Prof. trainer of python, java, javascript (sp prog. classes for kids | ap | ccc | coding competitions) learn web development: html/css, node.js, mysql, javascript (mern) stack from beginner to advance

Software developer giving java, javascript and python classes for students and professionals in vancouver!

Video game developer with 7 years of experience. video game development with unity, unreal engine or pygame. you choose! all levels. pc and mobile game development.

Seasoned software engineer teaching computer science and programming to students of all levels

Learn the art of python programming with personalized lessons from a seasoned tutor!

Coding! software! algorithms! hardware design! - uwaterloo masters graduate and intel software engineer here to help (all levels welcome)!

Experienced software engineer with 9 years tutoring—clear explanations, patient guidance, real results

Circuits, signals & control systems, analog and digital electronics, semiconductors, engineering math and physics

8+ years of proven programming expertise helping students succeed. learn python, java, and c/c++ at any level with clear, engaging guidance designed to boost your confidence and help you excel in exam

Phd student at sfu teaching c/python/matlab programming basic to advanced in burnaby, vancouver (pst timezone)

Class of learning how to have fun with python (easy to learn)

Master's in electrical engineering from mcmaster university | matlab, c, python & more | 7+ years experience in teaching

Phd, gives matlab and python class for university, college and high school students.

Software engineer with 2+ years industry experience. passionate about guiding students to success, offering tailored lessons and mentorship from beginner to advanced levels.

Share

Verified tutor profile

levels

All languages in which the lesson is available

Review

Reviews

Recommendations

free lessons

Report this ad