1^st class free

Pragya

5 (1 review)

Rate ₹1,638
Response 1h

5 (1 review)

₹1,638/hr

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

Class 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 class

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

₹1,638

Pack prices

5h: ₹8,189
10h: ₹16,379

free classes

This first free class with Pragya will allow you to get to know each other and to specify the exact learning requirements for the upcoming classes.

45mins

online

₹1,638/hr

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

Class location

About Pragya

About the class

Recommendations

Rates

Rate

Pack prices

free classes

online

Similar Python teachers in Melbourne

Agent harness | ms @ cmi | bs @ iit madras | agentic architecture | ai infrastructure | ml

Unlock the world of programming, ai & computer skills with ease! learn from a pro with 16+ years of real-world experience – start your journey today!

Senior data analytics engineer || iiit-d m.tech cse(ai) || gate: 99+%ile|| c/c++, java, python, dbms, os, computer networks, ml, data analysis || projects and assignments ||5+ year of exp.

Looking for a coding tutor who understands your child's unique learning needs? you've come to the right place! hi my name is kunika. i have taught coding to more than 100 students in the last 6 years.

An ex-data analyst with 6 years of teaching experience, struggling with cs/python in your cbse/gcse/igcse, ocr/ed-excel/cambridge exams or some specific topic? i can help you score excellent marks.

Python | data science | machine learning | coding for beginners to advanced | hands-on projects & 1-on-1 guidance

Professional with 21 years of experience as computer lecturer. iit kanpur python certification. teaching computer coding to students of different age groups.focus on conceptual understanding

18y mnc lead genai ml llm datascience dataanalyst pytorch dsa leetcode hackerrank systemdesign fullstack webdev angular reactjs nodejs springboot azure aws microservice selenium sql docker

Senior software engineer || 7+ years of experience || java, python, kotlin, spring, spring boot, kafka, kubernetes, grpc, sql, nosql, azure, aws, microservices, elasticsearch, dbms

M.tech from iiit-b in data science || with 4 years of teaching experience. i'll guide you through exams, assignments, and projects. master python from basics to advanced levels

Dsa & hld || python/c/c++ || core computer science || iiit delhi mtech || gate 98.1%ile || nit srinagar btech || jee 99%ile || software engineer at ibm labs || 1:1 classes & interview prep || 6+ yoe

A programming languages teacher for more than 10 years. teaching core python/java, automation with python, web development with python, etc. additionally, i teach java with full stack too. covering a

Hello all, i am a software engineer, and i used to teach subjects like python, big data, and programming languages. i am teaching these subjects in a totally practical way.

Play way learning of python with maximum examples. you learn and you never forget.give it a try !!

Full stack developer | 4+ years exp | javascript | java | python | c++ | projects and assignments | finance | nodejs | freelancing | coding | programming fundamentals

From novice to ninja: excel in c++, python, and mern stack || data structures & algorithms || computer science || btech iit/jee || 1:1 classes & interview prep || 6+ yoe

Learn computer programming the easy way! solve numerous challenging programs and strengthen your basics.

Ugc net qualified tutor offering computer science and programming classes maximum results- minimum time. personalized learning. 1800+ sessions and counting.

Python / c / c++ / javascript programming, web development, game development & software architecture & programming

A computer science ph.d. candidate with over 10years of teaching and research experience, actively involved in mentoring isc, icse, and cbse students in maths, chemistry, physics, and computer science

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

Class location

About Pragya

About the class

Recommendations

Rates

Rate

Pack prices

free classes

online

Similar Python teachers in Melbourne

Agent harness | ms @ cmi | bs @ iit madras | agentic architecture | ai infrastructure | ml

Unlock the world of programming, ai & computer skills with ease! learn from a pro with 16+ years of real-world experience – start your journey today!

Senior data analytics engineer || iiit-d m.tech cse(ai) || gate: 99+%ile|| c/c++, java, python, dbms, os, computer networks, ml, data analysis || projects and assignments ||5+ year of exp.

Looking for a coding tutor who understands your child's unique learning needs? you've come to the right place! hi my name is kunika. i have taught coding to more than 100 students in the last 6 years.

An ex-data analyst with 6 years of teaching experience, struggling with cs/python in your cbse/gcse/igcse, ocr/ed-excel/cambridge exams or some specific topic? i can help you score excellent marks.

Python | data science | machine learning | coding for beginners to advanced | hands-on projects & 1-on-1 guidance

Professional with 21 years of experience as computer lecturer. iit kanpur python certification. teaching computer coding to students of different age groups.focus on conceptual understanding

18y mnc lead genai ml llm datascience dataanalyst pytorch dsa leetcode hackerrank systemdesign fullstack webdev angular reactjs nodejs springboot azure aws microservice selenium sql docker

Senior software engineer || 7+ years of experience || java, python, kotlin, spring, spring boot, kafka, kubernetes, grpc, sql, nosql, azure, aws, microservices, elasticsearch, dbms

M.tech from iiit-b in data science || with 4 years of teaching experience. i'll guide you through exams, assignments, and projects. master python from basics to advanced levels

Dsa & hld || python/c/c++ || core computer science || iiit delhi mtech || gate 98.1%ile || nit srinagar btech || jee 99%ile || software engineer at ibm labs || 1:1 classes & interview prep || 6+ yoe

A programming languages teacher for more than 10 years. teaching core python/java, automation with python, web development with python, etc. additionally, i teach java with full stack too. covering a

Hello all, i am a software engineer, and i used to teach subjects like python, big data, and programming languages. i am teaching these subjects in a totally practical way.

Play way learning of python with maximum examples. you learn and you never forget.give it a try !!

Full stack developer | 4+ years exp | javascript | java | python | c++ | projects and assignments | finance | nodejs | freelancing | coding | programming fundamentals

From novice to ninja: excel in c++, python, and mern stack || data structures & algorithms || computer science || btech iit/jee || 1:1 classes & interview prep || 6+ yoe

Learn computer programming the easy way! solve numerous challenging programs and strengthen your basics.

Ugc net qualified tutor offering computer science and programming classes maximum results- minimum time. personalized learning. 1800+ sessions and counting.

Python / c / c++ / javascript programming, web development, game development & software architecture & programming

A computer science ph.d. candidate with over 10years of teaching and research experience, actively involved in mentoring isc, icse, and cbse students in maths, chemistry, physics, and computer science

Share

Tutor profile verified

levels

All languages in which the class is available

Review

Reviews

Recommendations

free classes

Report this posting