1st lesson free
The profile of Matteo and their contact details have been verified by our experts
Matteo
- Rate Ksh. 5,182
- Response 1h
Ksh. 5,182/hr
Contact
1st lesson free
- Computer Programming
- SQL
- PostgreSQL
SQL & PostgreSQL Expert: Master Databases, Data Analysis & Query Optimisation for University and Professional Careers
- Computer Programming
- SQL
- PostgreSQL
Lesson location
About Matteo
I am a professional Geodata Scientist working in the aerospace industry, where I use SQL and PostgreSQL every day to manage, analyse and optimise large-scale geospatial and satellite databases.
My teaching philosophy goes beyond learning SQL syntax. I help students develop the analytical mindset required to work confidently with real databases and solve practical data problems.
Whether you're preparing for university exams, technical interviews, a dissertation, or looking to improve your professional data skills, lessons are fully tailored to your goals.
My professional experience combines database management, data analysis, GIS, and Python automation, allowing me to explain not only how SQL works, but why different solutions are chosen in real-world projects.
Lessons are suitable for complete beginners as well as students and professionals wishing to improve their database expertise.
See more
About the lesson
- Lower Primary
- Upper Primary
- Lower Secondary
- +14
levels :
Lower Primary
Upper Primary
Lower Secondary
Senior School
Tertiary
Adult Education
Masters
Diploma
Doctorate
Advocates Training Programme
MBA
Pre-Primary
Beginner
Intermediate
Advanced
Professional
Children
- English
- Italian
All languages in which the lesson is available :
English
Italian
Interactive Online Lessons with Digital Whiteboard
Lessons are delivered online using screen sharing and a professional digital whiteboard.
Every explanation is built step by step, and at the end of each lesson you'll receive a PDF containing all notes, diagrams and examples created during the session.
Rather than memorising commands, you'll learn how to think like a database professional.
Topics include:
• SQL fundamentals (DDL, DML, SELECT, INSERT, UPDATE, DELETE)
• Filtering, sorting and advanced querying
• Complex JOINs and relational database design
• GROUP BY, HAVING and aggregate functions
• Window Functions
• Common Table Expressions (CTEs)
• Views and indexes
• Query optimisation and performance tuning
• PostgreSQL fundamentals
• Database design and normalisation
• PostgreSQL administration basics
• Real-world business datasets
• Technical interview preparation
• University coursework and dissertation support
• Optional introduction to PostGIS for spatial databases
Every lesson is practical and adapted to your current level.
We'll work on real databases and realistic scenarios so that you develop skills directly applicable in both academic and professional environments.
See more
Recommendations
Recommendations come from relatives, friends and acquaintances of the teacher
1
I've known Matteo for some time and have always been impressed by both his technical expertise and his ability to explain complex topics clearly.
He has a strong professional background in GIS, Python and SQL, and what stands out most is his practical approach to teaching. He focuses on helping students truly understand the concepts rather than simply memorising commands, making lessons engaging and effective.
Matteo is patient, well organised and always willing to adapt his explanations to the student's level and objectives. I would highly recommend him to anyone looking for a knowledgeable and supportive tutor.
View more recommendations
See more
Rates
Rate
- Ksh. 5,182
Pack prices
- 5h: Ksh. 25,912
- 10h: Ksh. 51,824
online
- Ksh. 5,182/h
free lessons
The first free lesson with Matteo will allow you to get to know each other and clearly specify your needs for your next lessons.
- 1hr
Details
My hourly rate reflects specialised one-to-one database training based on professional industry experience.
Each lesson includes:
• Fully personalised learning based on your objectives
• Exercises using realistic SQL databases
• University coursework, dissertation and project support
• Technical interview preparation
• SQL scripts and practice datasets after each lesson
• PDF lesson notes for independent revision
• Guidance on writing clean, efficient and scalable SQL queries
• PostgreSQL best practices used in professional environments
• Optional integration with Python, GIS and PostGIS where relevant
Whether you're learning SQL for the first time, preparing for exams, improving your career prospects or working with complex databases, every lesson is designed to provide practical skills that you can immediately apply in real-world situations.
Similar Computer Programming teachers in London
Prof Shitanda
Nairobi & Online
- Ksh. 450/h
- 1st lesson free
Patience
Nyeri & Online
- Ksh. 500/h
- 1st lesson free
Samuel
Nairobi & Online
- Ksh. 500/h
- 1st lesson free
Mutai
Nairobi & Online
- Ksh. 2,000/h
- 1st lesson free
Kelvin
Kisumu & Online
- Ksh. 2,500/h
- 1st lesson free
Ezekiel
Thika & Online
- Ksh. 3,000/h
- 1st lesson free
Alice
Kisii & Online
- Ksh. 100/h
- 1st lesson free
Joy
Nairobi & Online
- Ksh. 2,500/h
- 1st lesson free
Geoffrey
Nairobi & Online
- Ksh. 2,500/h
- 1st lesson free
Caleb
Nairobi & Online
- Ksh. 1,200/h
- 1st lesson free
Methusela
Kilifi & Online
- Ksh. 500/h
- 1st lesson free
Brian
Nairobi
- Ksh. 1,500/h
- 1st lesson free
Ron
Nairobi & Online
- Ksh. 4,000/h
- 1st lesson free
PURITY
Thika & Online
- Ksh. 2,000/h
- 1st lesson free
Faith
Ruiru & Online
- Ksh. 800/h
- 1st lesson free
Sylvester
Nairobi & Online
- Ksh. 2,500/h
- 1st lesson free
Rose
Nairobi & Online
- Ksh. 2,500/h
- 1st lesson free
Mohamed
Nairobi & Online
- Ksh. 2,200/h
- 1st lesson free
Denis
Konza & Online
- Ksh. 500/h
- 1st lesson free
Rhoda
Kakamega & Online
- Ksh. 1,500/h
- 1st lesson free
-
See Computer Programming tutors
