1^st lesson free

Pragya

5 (1 review)

Rate $31
Response 1h

5 (1 review)

$31/hr

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 come from relatives, friends and acquaintances of the teacher

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 prices

5h: $156
10h: $311

free lessons

The first lesson with Pragya will allow you to get to know each other and discuss your needs for future lessons.

45mins

online

$31/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 prices

free lessons

online

Similar Python tutors in Melbourne

Hi there, i am a graduate of the university of auckland, majoring in computer science. i teach programming-related skills remotely and have experience working as a web developer.

Master coding, python, ai, sql, postgresql & visual basic | 6+ years experience | become a skilled coder

Master python, artificial intelligence, sql and c++ with a 5+ years experienced tutor in auckland

I have a decade of teaching experience in computer programming for graduate students. have experience delivering lectures in online & offline mode. love to handle data structures python programming

Experienced python, sql & ai tutor for all levels – offering online lessons in new zealand with phd expertise

Assist in assignments, reports, exams, dissertations in any data analysis, programming, etc related subjects

Ncea level 2 excellence endorsement in digital technology, i teach python, html, css, games on godot

"coperate trainer and university-level educator with 10+ years’ experience teaches c, c++, java, python, dsa, aws & azure online " azure az900 ai900 dp900 az104 az102 aws solution architect artificial

Auckland python & c++ tutor – practical ai, sql, r and programming help for university assignments, quizzes and projects

10 years in it industry and teaches computer science and coding and currently enrolled in phd (auckland university of technology).

Need data science help with tools like excel, powerbi , python, sql, sas viya. does it involve machine learning, models , reports? i'm your guy for the job!!

Master artificial intelligence, python, sql, and programming languages with a seasoned machine learning engineer | 5+ years of industry & teaching experience | personalized online lessons tailored to

Computer professional with decades of software development experience offering in-depth c/c++ lessons in auckland or online

Engineering graduate teaches programming language for c cpp java python data structure and algthm in auckland

Graduate from manukau institute of technology with bachelor degree. personalized teaching methods to meet individual needs

I have almost 12+ years of working experience as assistant professor/teacher (tutor) and researcher at university and engineering college level. and i earned my philosophy of doctorate (ph.d.) from in

Experienced university tutor and computer science graduate. teaches video game development and computer science at ncea, tertiary and industry levels.

Coach assisting with school and university students' coding assignments, labs, and exams

Graduate teaching assistant at the university of auckland, teaching master’s and bachelor’s students, with a master of information technology and over 10 years of industry experience.

Experienced teacher of cambridge computer science and digital technologies ncea with expertise in c++, c, python, oops and html, php ,css for web development. international school experienced curre

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 prices

free lessons

online

Similar Python tutors in Melbourne

Hi there, i am a graduate of the university of auckland, majoring in computer science. i teach programming-related skills remotely and have experience working as a web developer.

Master coding, python, ai, sql, postgresql & visual basic | 6+ years experience | become a skilled coder

Master python, artificial intelligence, sql and c++ with a 5+ years experienced tutor in auckland

I have a decade of teaching experience in computer programming for graduate students. have experience delivering lectures in online & offline mode. love to handle data structures python programming

Experienced python, sql & ai tutor for all levels – offering online lessons in new zealand with phd expertise

Assist in assignments, reports, exams, dissertations in any data analysis, programming, etc related subjects

Ncea level 2 excellence endorsement in digital technology, i teach python, html, css, games on godot

"coperate trainer and university-level educator with 10+ years’ experience teaches c, c++, java, python, dsa, aws & azure online " azure az900 ai900 dp900 az104 az102 aws solution architect artificial

Auckland python & c++ tutor – practical ai, sql, r and programming help for university assignments, quizzes and projects

10 years in it industry and teaches computer science and coding and currently enrolled in phd (auckland university of technology).

Need data science help with tools like excel, powerbi , python, sql, sas viya. does it involve machine learning, models , reports? i'm your guy for the job!!

Master artificial intelligence, python, sql, and programming languages with a seasoned machine learning engineer | 5+ years of industry & teaching experience | personalized online lessons tailored to

Computer professional with decades of software development experience offering in-depth c/c++ lessons in auckland or online

Engineering graduate teaches programming language for c cpp java python data structure and algthm in auckland

Graduate from manukau institute of technology with bachelor degree. personalized teaching methods to meet individual needs

I have almost 12+ years of working experience as assistant professor/teacher (tutor) and researcher at university and engineering college level. and i earned my philosophy of doctorate (ph.d.) from in

Experienced university tutor and computer science graduate. teaches video game development and computer science at ncea, tertiary and industry levels.

Coach assisting with school and university students' coding assignments, labs, and exams

Graduate teaching assistant at the university of auckland, teaching master’s and bachelor’s students, with a master of information technology and over 10 years of industry experience.

Experienced teacher of cambridge computer science and digital technologies ncea with expertise in c++, c, python, oops and html, php ,css for web development. international school experienced curre

Share

Tutor profile verified

levels

All languages in which the lesson is available

Reviews

Reviews

Recommendations

free lessons

Report this listing