1st lesson free
Ayan's profile, diploma and contact details have been verified by our experts
Ayan
- Rate TSh 13,887
- Response 1h
TSh 13,887/hr
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
- Primary school
- Ordinary Level
- Form 5
- +14
levels :
Primary school
Ordinary Level
Form 5
Form 6
Ordinary Diploma
Tertiary Education
Adult Education
Bachelor’s Degree
Master’s Degree
PhD / Doctorate
PGDLP
MBA
Nursery
Beginner
Intermediate
Advanced
Children
- English
All 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 come from relatives, friends and acquaintances of the teacher
1
Ayan is a really good tutor. We are both into teaching. He is really patient and approachable.
Very knowledgeable tutorView more recommendations
See more
Rates
Rate
- TSh 13,887
Pack prices
- 5h: TSh 65
- 10h: TSh 130
free lessons
The first free lesson with Ayan will allow you to get to know each other and clearly specify your needs for your next lessons.
- 1hr
online
- TSh13,887/h
Similar SQL teachers in Bengaluru
João
London, United Kingdom & Online
- TSh 106,943/hr
- 1st lesson free
Reza
Brooklyn, United States & Online
- TSh 105,648/hr
- 1st lesson free
Reihane
Guelph, Canada & Online
- TSh 94,664/hr
- 1st lesson free
Michael
New York, United States & Online
- TSh 132,060/hr
- 1st lesson free
Esmaeil
New York, United States & Online
- TSh 79,236/hr
- 1st lesson free
Robert
London, United Kingdom & Online
- TSh 352,913/hr
- 1st lesson free
Thomas
Paris, France & Online
- TSh 91,629/hr
- 1st lesson free
Arun
Melbourne, Australia & Online
- TSh 74,653/hr
- 1st lesson free
João
New York, United States & Online
- TSh 79,236/hr
- 1st lesson free
Bryan
Santa Ana, United States & Online
- TSh 66,030/hr
Adi Teja
Liverpool, Australia & Online
- TSh 93,317/hr
- 1st lesson free
STHEFANIE
San Antonio, United States & Online
- TSh 198,090/hr
Andrei
Berlin, Germany & Online
- TSh 244,344/hr
- 1st lesson free
Piyush
Brooklyn, United States & Online
- TSh 92,442/hr
- 1st lesson free
Massimiliano
Ancona, Italy & Online
- TSh 91,629/hr
- 1st lesson free
Antônio
Bela Vista, Brazil & Online
- TSh 31,153/hr
- 1st lesson free
Jyoti
Mumbai, India & Online
- TSh 16,647/hr
Kunika
Mumbai, India & Online
- TSh 24,971/hr
- 1st lesson free
Mohamed
Marseille 1er, France & Online
- TSh 88,575/hr
- 1st lesson free
Mudita
, United Kingdom & Online
- TSh 160,415/hr
- 1st lesson free
-
See SQL tutors
