1^st lesson free

Ayan

5 (1 review)

Rate R87
Response 1h

5 (1 review)

R87/h

1^st lesson free

SQL
PostgreSQL

Join the Ultimate SQL Masterclass: Go From Zero to Query Hero Classes on Weekends | Self Paced | Learn via Implementation

SQL
PostgreSQL

Lesson location

- online

About Ayan

2+ years of Working Experience in a Fortune 500 product-based organization.

Mentoring since 4+ years internationally.

I believe students thrive when learning and implementation goes hand in hand.

> > What I offer as a mentor:

End-to-End Database Mastery: Mastering the workflow from database design to complex data architecture.

Tool Proficiency: In-depth training in SQL syntax, multi-table joins, subqueries, CTEs.

Performance Optimization: Practical knowledge in database indexing, query tuning, and reading execution plans.

Practical Mentorship: 1:1 sessions focused on "implementation," optimizing slow queries, and debugging together.

If you’re looking to transition into data or want to sharpen your technical edge with a structured backend roadmap, let's connect.

About the lesson

Classes on Weekends.
1 Hour Class

Topics :
1. Basics & Retrieval
[Syntax: SELECT, FROM, AS] [Filtering: WHERE, LIKE, IN, BETWEEN] [Sorting: ORDER BY, LIMIT]

2. Aggregation & Grouping
[Functions: COUNT, SUM, AVG, MIN, MAX] [Grouping: GROUP BY] [Filtering Groups: HAVING]

3. Joining Tables
[Core Joins: INNER, LEFT, RIGHT, FULL OUTER] [Self & Cross: Self Joins, CROSS JOIN] [Set Operations: UNION, UNION ALL]

4. Subqueries & CTEs
[Subqueries: Nested, Correlated] [CTEs: WITH clauses] [Logic: CASE WHEN conditionals]

5. Data Modification
[DML: INSERT, UPDATE, DELETE, TRUNCATE] [DDL: CREATE, ALTER, DROP] [Constraints: PRIMARY, FOREIGN KEY]

6. Optimization & Tuning
[Indexing: Clustered, Non-Clustered] [Performance: EXPLAIN plans, Tuning] [Transactions: COMMIT, ROLLBACK, ACID]

Recommendations

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

Annesha

Ayan is a really good tutor. We are both into teaching. He is really patient and approachable.
Very knowledgeable tutor
Read more

A
Annesha
Ayan is a really good tutor. We are both into teaching. He is really patient and approachable.
Very knowledgeable tutor
See more recommendations

Rates

Rate

Package rates

5h: R435
10h: R870

free lesson

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

online

R87/h

Join the Ultimate SQL Masterclass: Go From Zero to Query Hero Classes on Weekends | Self Paced | Learn via Implementation

Lesson location

About Ayan

About the lesson

Recommendations

Rates

Rate

Package rates

free lesson

online

Similar SQL tutor profiles

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

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

Helping you decode the data space, one query and line of code at a time sql, excel, javascript, html & css

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

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

Data engineer who has passion for database management, also does reporting and the tools that i use are sql server management studio, power bi, ssrs, ssis, and mds

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.

Professional web developer with 2+ years of experience | build real-world web projects (react, node.js, next.js, typescript) for all levels.

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

Business practitioner with almost 3 decades of experience, working in corporate as well as running my own businesses.

Learn coding from scratch with a software developer specialising in beginner-friendly programming lessons

Master sql with expert guidance from a veteran it professional and real-world data specialist

Become a coding star with my interactive lessons, start now with a free lesson

It & programming tutor | varsity college grad | patient, real-world focused lessons that inspire confidence

Certified it educator: engaging lessons in coding, networking & tech – 11+ years of proven experience

A final year student in information technology (majoring in computer science & informatics). high level innovative student, who is patient to teach beginners and anyone who wants to dive into the tech

Informatician graduate, who specializes in computer programming. programming language include sql, html, css, kotlin, python, php and javascript

It teacher offering programming courses in cape town, up to university level online.

Ict graduate with 2 years + of teaching experience. 1 year + software developer.

Join the Ultimate SQL Masterclass: Go From Zero to Query Hero Classes on Weekends | Self Paced | Learn via Implementation

Lesson location

About Ayan

About the lesson

Recommendations

Rates

Rate

Package rates

free lesson

online

Similar SQL tutor profiles

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

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

Helping you decode the data space, one query and line of code at a time sql, excel, javascript, html & css

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

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

Data engineer who has passion for database management, also does reporting and the tools that i use are sql server management studio, power bi, ssrs, ssis, and mds

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.

Professional web developer with 2+ years of experience | build real-world web projects (react, node.js, next.js, typescript) for all levels.

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

Business practitioner with almost 3 decades of experience, working in corporate as well as running my own businesses.

Learn coding from scratch with a software developer specialising in beginner-friendly programming lessons

Master sql with expert guidance from a veteran it professional and real-world data specialist

Become a coding star with my interactive lessons, start now with a free lesson

It & programming tutor | varsity college grad | patient, real-world focused lessons that inspire confidence

Certified it educator: engaging lessons in coding, networking & tech – 11+ years of proven experience

A final year student in information technology (majoring in computer science & informatics). high level innovative student, who is patient to teach beginners and anyone who wants to dive into the tech

Informatician graduate, who specializes in computer programming. programming language include sql, html, css, kotlin, python, php and javascript

It teacher offering programming courses in cape town, up to university level online.

Ict graduate with 2 years + of teaching experience. 1 year + software developer.

Share

Verified qualification

levels

Languages in which the lesson is available

Reviews

Évaluations

Recommendations

free lesson

Report this advert