1st lesson free
The profile of Matteo and their contact details have been verified by our experts
Matteo
- Rate £30
- Response 1h
£30/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
- Online
-
at your home or in a public place : will travel up to 20 km from London
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
- All Levels
- 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
- £30
Pack prices
- 5h: £150
- 10h: £300
online
- £30/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
Robert
London & Online
- £99/hr
- 1st lesson free
Juneyt (MA, MSc Oxford)
London & Online
- £110/hr
Priyanshu
London & Online
- £40/hr
- 1st lesson free
João
London & Online
- £30/hr
Yas
London & Online
- £55/hr
Alexander
London & Online
- £70/hr
Orestes
London & Online
- £65/hr
Claire
London & Online
- £30/hr
- 1st lesson free
Lloyd
London & Online
- £40/hr
Ana
London & Online
- £75/hr
- 1st lesson free
Elliott
London & Online
- £45/hr
Marat
London & Online
- £50/hr
- 1st lesson free
Ashish
London & Online
- £30/hr
- 1st lesson free
Margarita
London & Online
- £35/hr
- 1st lesson free
Aarohi
London & Online
- £26/hr
- 1st lesson free
Emmanuel
London & Online
- £35/hr
Radu
London & Online
- £20/hr
Akshat
London & Online
- £15/hr
- 1st lesson free
Carlos
& Online
- £150/hr
- 1st lesson free
Kaartick
London & Online
- £24/hr
- 1st lesson free
-
See Computer programming tutors
