1st lesson free
Ayan's profile and contact details have been verified by our team
Ayan
- Rate R86
- Response 1h
R86/h
Contact
1st 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
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.
See more
About the lesson
- All levels
- English
Languages in which the lesson is available :
English
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]
See more
Recommendations
Recommendations are written by the tutor's friends, family, and acquaintances.
1
Ayan is a really good tutor. We are both into teaching. He is really patient and approachable.
Very knowledgeable tutorSee more recommendations
See more
Rates
Rate
- R86
Package rates
- 5h: R430
- 10h: R860
online
- R86/h
free lesson
The free first lesson with Ayan allows you to get to know the tutor and discuss your needs and expectations.
- 1h
Similar SQL tutor profiles
Oleksandr
Randburg & online
- R349/h
- 1st lesson free
Itumeleng
Randburg & online
- R110/h
- 1st lesson free
Happy
Cape Town & online
- R300/h
- 1st lesson free
Khomotjo
Thokoza & online
- R250/h
- 1st lesson free
Senzosenkosi
Johannesburg & online
- R230/h
- 1st lesson free
Armandt
Pretoria & online
- R300/h
- 1st lesson free
Satish
Sandton & online
- R300/h
- 1st lesson free
Bharath
Midrand & online
- R100/h
- 1st lesson free
Sabata
Kimberley & online
- R226/h
- 1st lesson free
Tendani
Johannesburg & online
- R150/h
- 1st lesson free
Aryan
& online
- R280/h
- 1st lesson free
Haritha
Pretoria & online
- R10/h
- 1st lesson free
Cole
Cape Town & online
- R300/h
- 1st lesson free
Angelo
Roodepoort & online
- R250/h
- 1st lesson free
Mfanomutsha
Midrand & online
- R350/h
- 1st lesson free
Shaun
Johannesburg & online
- R100/h
- 1st lesson free
Ayibongwe
Brakpan & online
- R200/h
- 1st lesson free
Jonathan
Cape Town & online
- R400/h
- 1st lesson free
Oratile
Kempton Park & online
- R200/h
- 1st lesson free
Hamilton
Cape Town & online
- R180/h
- 1st lesson free
-
See SQL tutors
