1st lesson free
Ayan's profile and their contact details have been verified by our experts
Ayan
- Rate ₱336
- Response 1h
₱336/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
- Elementary School
- Junior High School
- Senior High School
- +14
levels :
Elementary School
Junior High School
Senior High School
Technical Vocational Education And Training
Professional
Adult Education
Bachelor
Master
Doctoral
Other
MBA
Early Childhood Education
Beginner
Intermediate
Advanced
others
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
- ₱336
Pack rates
- 5h: ₱1680
- 10h: ₱3360
free lessons
This first lesson offered with Ayan will allow you to get to know each other and clearly specify your needs for your next lessons.
- 1hr
online
- ₱336/h
Other tutors in SQL
-
![]( "teacher_picture")
Alberto
Makati & online- New
Online tutoring. programming teacher with over 15 years experience. i have experience teaching computer science subjects in the philippines and in france. i teach python, java, and sql.
- ₱1,000/h
- 1st lesson free
-
![]( "teacher_picture")
Yaacob
Malolos & online- New
Learn programming the right way: 8+ years professional developer teaches core concepts that apply to any language
- ₱600/h
- 1st lesson free
-
![]( "teacher_picture")
Teofilo jr
Tampakan & online- Experienced
4th year it student and former dost full-stack developer intern teaches web development and programming online.
- ₱500/h
- 1st lesson free
-
![]( "teacher_picture")
Jean paul
Pasig & online- New
Licensed professional teacher | ibdp & igcse computer science teacher & google certified educator level 1 & 2
- ₱1,000/h
- 1st lesson free
-
![]( "teacher_picture")
Roberto
Manila & online- New
Full-stack web developer and ai-agentic workflow instructor | software engineer and college faculty with 16 years of experience in software engineer and 1 year experience in teaching.
- ₱800/h
- 1st lesson free
-
![]( "teacher_picture")
Adrian joseph
Quezon City & online- New
I help people build their computer science skills, confidence, and problem-solving abilities at their own pace.
- ₱750/h
- 1st lesson free
-
![]( "teacher_picture")
Francisco
Larena- New
Experienced information technology professional with extensive expertise in technical support, systems administration, it operations, and academic technology management.
- ₱800/h
- 1st lesson free
-
![]( "teacher_picture")
John
London & online- Ambassador
C# & .net developer tutor: 6 years, 1000+ students, 150+ five-star reviews. learn c# from scratch to real projects, online
- ₱2,529/h
- 1st lesson free
-
![]( "teacher_picture")
Robert
London & online- Ambassador
Experienced london ai & machine learning tutor recommended by google - king's college 1st class graduate - executive training & students [msc ai, epqs] - neural networks, python, deep learning
- ₱8,345/h
- 1st lesson free
-
![]( "teacher_picture")
Reza
Brooklyn & online- Ambassador
Expert coding tutor (12+ yrs) java, python, c, sql, ai, web dev & more
- ₱2,524/h
- 1st lesson free
-
![]( "teacher_picture")
João
New York & online- Ambassador
Tutoring lessons with python, artificial intelligence, data science, c#, c++, java, sql, databases, game development
- ₱1,262/h
- 1st lesson free
-
![]( "teacher_picture")
Fabio
Castel di Sangro & online- Ambassador
Gis and geomatics specialist, author of qgis courses: i help university students of all scientific fields and levels pass exams, theses, and projects with practical and targeted support.
- ₱2,321/h
- 1st lesson free
-
![]( "teacher_picture")
Reihane
Guelph & online- Ambassador
Computer programming - phd in software engineering, experienced university instructor with more than 15 years of experience in programming. my research focuses on artificial intelligence and nlp, llm.
- ₱2,235/h
- 1st lesson free
-
![]( "teacher_picture")
Michael
New York & online- Ambassador
1-on-1 ai tutor: automate your work and build real projects with claude code, cowork, codex and cursor
- ₱3,787/h
- 1st lesson free
-
![]( "teacher_picture")
Esmaeil
New York & online- Ambassador
Sql & database expert: postgresql, mysql, cloud dbs and data engineering — master's cs
- ₱1,578/h
- 1st lesson free
-
![]( "teacher_picture")
Thomas
Paris & online- Ambassador
Trainer expert in php, python, java, symfony, mysql, html, ... 1st free course; )
- ₱2,110/h
- 1st lesson free
-
![]( "teacher_picture")
Piyush
Brooklyn & online- Super Prof
Prof. trainer of python, r, java, javascript (sp prog. classes for kids | ap | coding competitions) learn web development: html/css, node.js, mysql, javascript (mern) stack, django, flask from beginne
- ₱2,209/h
- 1st lesson free
-
![]( "teacher_picture")
Bryan
Cheektowaga & online- Ambassador
Tutor / developer with 6+ years of experience in tutoring javascript, react, node, python, sql & computer science
- ₱1,578/h
-
![]( "teacher_picture")
Sthefanie
San Antonio & online- Ambassador
Doing phd, graduate in software engineer with hard skills in programming language, logic, data structure, big data and researching artificial intelligence technologies.
- ₱6,311/h
-
![]( "teacher_picture")
Andrei
Berlin & online- Ambassador
Python programming for statistics, data analysis, machine learning. for your university course or for self-study. i speak english and live in berlin.
- ₱5,628/h
- 1st lesson free
-
See SQL tutors
