from17.00EUR/ h
College SQL Exam Preparation - Learn Everything about PostgreSQL "SELECT" statements!
Are you preparing for your college SQL exams and want to excel in database querying? Join my SQL Exam Preparation course, where you’ll get expert guidance from an experienced tutor with a strong background in databases. (mainly PostgreSQL and mySQL) With 2 years of SQL experience, top scores in exams at KdG University, and over a year of tutoring, I’ll help you master SELECT statements and beyond.
What you’ll learn:
- Basics of SQL: tables, columns, rows
- Writing SELECT queries
- Filtering data using WHERE, LIKE, and logical operators
- Using ORDER BY and LIMIT for sorting and limiting results
- Aggregate functions: COUNT, SUM, AVG, MIN, MAX
- GROUP BY and HAVING clauses for data aggregation
- Joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
- Subqueries and nested SELECT statements
Who is this for? This course is ideal for anyone looking to strengthen their SQL skills, whether you're a beginner or preparing for college-level exams. We’ll cover core SELECT query concepts, ensuring you have the confidence to work with real-world data and ace your tests.
Looking for something more advanced? Check out my other course on CREATE and INSERT statements.
What you’ll learn:
- Basics of SQL: tables, columns, rows
- Writing SELECT queries
- Filtering data using WHERE, LIKE, and logical operators
- Using ORDER BY and LIMIT for sorting and limiting results
- Aggregate functions: COUNT, SUM, AVG, MIN, MAX
- GROUP BY and HAVING clauses for data aggregation
- Joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
- Subqueries and nested SELECT statements
Who is this for? This course is ideal for anyone looking to strengthen their SQL skills, whether you're a beginner or preparing for college-level exams. We’ll cover core SELECT query concepts, ensuring you have the confidence to work with real-world data and ace your tests.
Looking for something more advanced? Check out my other course on CREATE and INSERT statements.
Extra information
Bring your own laptop with PostgreSQL installed!Location
At student's location: Around Antwerp, Belgium
Online via webcam






|
Use ctrl + wheel to zoom!
General info
Age: | Teenagers (13-17 years old) Adults (18-64 years old) |
---|---|
Student level: | Beginner Intermediate |
Duration: | 60 minutes 120 minutes |
The class is taught in: | English, Polish |
About Me
Hi! I’m a skilled and dedicated developer with expertise in Java, Spring, JavaScript, Node.js/Express.js. I'm consistently recognized as a "programming wizard" by my friends, colleagues, and teachers. With many years of programming experience and a strong background in backend/bot development, I specialize in building robust applications and coding every silly idea that comes to my mind. I have also worked with frontend technologies like React, html+css, JavaFX, and Next.jsAbout a year ago, I have discovered my love for spreading my knowledge onto others. Since then I have been preparing students for exams, and teaching anything from beginner to advanced topics in multiple programming and database query languages.
Education
I have been taking every single class and course about computers and programming ever since I started elementary school. I have finished high school with an Honors Diploma and multiple recognitions in IT fields: robotics, coding, software engineering. After that, I started studying at KdG University, where I am still studying (currently year 2).Experience / Qualifications
I have written tens if not hundreds of programming projects both by myself and with teams of other developers. I've been programming in Java, Python, and JavaScript almost daily for the past 3 years. I have scored an average of 19.5/20 on my 4 University programming exams.Ready to dive into the world of JavaScript? Whether you're starting from scratch or want to level up your skills, this course will guide you through the core concepts of Vanilla JavaScript—the foundation of web development. By the end, you’ll be able to build interactive web pages, manipulate the DOM, and even create cool animations and games using HTML Canvas.
What you’ll learn:
- JavaScript fundamentals: variables, data types, functions, loops, and conditionals
- DOM manipulation: interacting with and modifying HTML elements
- Event handling: adding interactivity to your websites with events like clicks and keypresses
- JSON and data fetching: working with APIs to load dynamic content
- Asynchronous JavaScript: promises, async/await
- Best practices and clean coding
Bonuses:
- HTML Canvas: Create graphics, animations, and games!
- Local Storage: Save data in the browser for a persistent user experience
- JavaScript ES6+ Features: Stay up-to-date with the latest syntax and capabilities
Who is this for? This course is perfect for beginners who want to master the fundamentals of JavaScript, as well as developers looking to solidify their understanding of Vanilla JavaScript before moving into frameworks. We’ll focus on practical, hands-on learning to ensure you walk away with skills you can immediately apply.
Are you preparing for your college Java exams and want to ace them? Join my College Java Exam Preparation course to receive expert guidance from a seasoned Java programmer. With 3+ years of experience in Java, consistent top scores in programming exams at KdG University (average of 19.5/20), and over a year of tutoring experience, I’m here to help you master everything from foundational concepts to advanced topics.
What you’ll learn:
- Java basics: variables, data types, operators
- Control flow: loops, if/else, switch + break/continue
- Arrays and Strings
- Object-oriented programming (OOP): classes, methods, static keyword, constructors(and overloading),
- Advanced OOP: inheritance, polymorphism, encapsulation, abstraction, interfaces
- Collections, exceptions, file handling, and I/O
Who is this for? This course is perfect for students at any level of Java proficiency—whether you're just starting or looking to fine-tune your advanced skills before exams. We'll focus on core exam topics and work through real-world Java problems to make sure you feel confident and well-prepared.
Need something more advanced? Check out my other courses on JDBC (with SQL), JavaFX, Spring basics, and Spring Boot
Dive into the world of web development with my comprehensive HTML course, designed for beginners who want to build stunning, functional websites from the ground up. Whether you’re curious about how websites work or want to create your own, this course will take you step-by-step through the essentials of HTML and beyond, giving you the skills to develop real-world projects confidently.
What You'll Learn:
- HTML Basics: Learn the building blocks of the web by mastering tags, elements, attributes, and how to structure content.
- Interactive Forms: Create dynamic forms for login pages, surveys, and more, and handle user input effectively.
- Adding Media: Discover how to embed images, videos, and other multimedia to make your websites more engaging.
- Linking and Navigation: Build a fully connected website using hyperlinks, menus, and navigation best practices.
- Introduction to CSS: Apply basic styles to your HTML content, learning how to change fonts, colors, layouts, and more.
- Responsive Web Design: Ensure your websites look great on mobile, tablet, and desktop using modern techniques like Bootstrap.
- Semantic HTML: Understand the importance of clean, readable code with semantic tags that improve your website’s accessibility.
Course Features:
- Hands-on exercises for every topic to reinforce learning.
- Personal feedback and guidance on your projects.
- Practical examples and projects to help you apply your skills in real-world scenarios.
- Learn at your own pace, with flexible lessons tailored to your skill level.
Who is this course for?
This course is perfect for beginners with little to no coding experience. By the end, you’ll have a strong foundation in HTML and basic web development, empowering you to continue learning CSS, JavaScript, or dive into more advanced web development.
Ask a question
Send a message explaining your needs and Szymon will reply soon:
The more detail, the better.
Ex. "Hi, when are you available to meet for a lesson?"
Ex. "Hi, when are you available to meet for a lesson?"
Availability of a typical week
(GMT -04:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | Saturday at 8:00 | Sunday at 8:00 | |||||
9 | Saturday at 9:00 | Sunday at 9:00 | |||||
10 | Monday at 10:00 | Tuesday at 10:00 | Wednesday at 10:00 | Thursday at 10:00 | Friday at 10:00 | Saturday at 10:00 | Sunday at 10:00 |
11 | Monday at 11:00 | Tuesday at 11:00 | Wednesday at 11:00 | Thursday at 11:00 | Friday at 11:00 | Saturday at 11:00 | Sunday at 11:00 |
12 | Monday at 12:00 | Tuesday at 12:00 | Wednesday at 12:00 | Thursday at 12:00 | Friday at 12:00 | Saturday at 12:00 | Sunday at 12:00 |
13 | Monday at 13:00 | Tuesday at 13:00 | Wednesday at 13:00 | Thursday at 13:00 | Friday at 13:00 | Saturday at 13:00 | Sunday at 13:00 |
14 | Monday at 14:00 | Tuesday at 14:00 | Wednesday at 14:00 | Thursday at 14:00 | Friday at 14:00 | Saturday at 14:00 | Sunday at 14:00 |
15 | Sunday at 15:00 | ||||||
16 | Tuesday at 16:00 | Wednesday at 16:00 | Thursday at 16:00 | Friday at 16:00 | Saturday at 16:00 | Sunday at 16:00 | |
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from 17€Online via webcam
from 20€At student's home
100% Satisfaction Guarantee
Good-fit Instructor Guarantee
If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.
Online reputation
- Instructor since October 2024
- Phone number verified
- Google connected
- Linkedin connected
Availability of a typical week
(GMT -04:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | Saturday at 8:00 | Sunday at 8:00 | |||||
9 | Saturday at 9:00 | Sunday at 9:00 | |||||
10 | Monday at 10:00 | Tuesday at 10:00 | Wednesday at 10:00 | Thursday at 10:00 | Friday at 10:00 | Saturday at 10:00 | Sunday at 10:00 |
11 | Monday at 11:00 | Tuesday at 11:00 | Wednesday at 11:00 | Thursday at 11:00 | Friday at 11:00 | Saturday at 11:00 | Sunday at 11:00 |
12 | Monday at 12:00 | Tuesday at 12:00 | Wednesday at 12:00 | Thursday at 12:00 | Friday at 12:00 | Saturday at 12:00 | Sunday at 12:00 |
13 | Monday at 13:00 | Tuesday at 13:00 | Wednesday at 13:00 | Thursday at 13:00 | Friday at 13:00 | Saturday at 13:00 | Sunday at 13:00 |
14 | Monday at 14:00 | Tuesday at 14:00 | Wednesday at 14:00 | Thursday at 14:00 | Friday at 14:00 | Saturday at 14:00 | Sunday at 14:00 |
15 | Sunday at 15:00 | ||||||
16 | Tuesday at 16:00 | Wednesday at 16:00 | Thursday at 16:00 | Friday at 16:00 | Saturday at 16:00 | Sunday at 16:00 | |
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from 17€Online via webcam
from 20€At student's home
Good-fit Instructor Guarantee
If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.
Share
You are here
Similar classes
Han
Programming, data analysis, and statistics courses by a French master's graduateGraduated with a Master's degree in Applied Mathematics and Optimization, I offer tailored support to meet your needs (courses/projects/exams) in programming, analysis, and statistics.
Currently working in a field involving C++ programming, scripting, and mathematical modeling (constraint programming, linear/MIP programming, Branch and Bound, etc.), I can provide assistance ranging from installing different software to ongoing support for projects, whether for your academic studies or professional work.
Note (regarding statistics courses):
Please note that for statistics courses, I recommend contacting me at least four weeks in advance of your desired deadline (exams/projects) to ensure ample preparation time otherwise I systematically decline the requests. This will allow us to have productive and effective sessions tailored to your needs.
PROGRAMMING Languages:
C/C++, Java, VBA, etc...
STATISTICS Software:
Matlab, R, (Excel)
Courses can be conducted in French or English, depending on your preferences.
Siyavash
Teaching Python by PhD student.I am a Ph.D. student at the University of Antwerp in the field of regional economics and the economics of transportation.
Besides, I have a master's degree in civil engineering and my mathematic level is proficient.
Additionally, I attained 169/170 in GRE quantitative reasoning.
Salah Eddine
Master Python with Courses Suitable for All Ages and Levels! Beginners, Intermediates, Professionals, Everyone is WelcomeMaster Python with Personalized Courses
Discover the art of programming with Python courses tailor-made to meet your specific needs. Whether you are a beginner, intermediate or professional, my lessons are suitable for all levels.
Why Choose My Courses?
Personalized Teaching Approach: Each course is tailored to your skill level and individual goals.
Practical Experience: Learn by doing with real-world projects that build your understanding and skills.
Ongoing Support: Get unlimited email support for any questions you have between sessions.
As a Python expert, I have a passion for teaching and sharing my knowledge. My goal is to guide you effectively in your learning journey.
Book Your First Lesson:
Start your journey to Python mastery now by booking your first lesson. Whether you aspire to enter the development field or hone your existing skills, these courses are designed for you.
Baia
Master Front-End Development | Build Stunning Websites with HTML, CSS, JavaScript & ReactAre you ready to create interactive, visually appealing websites that stand out in today’s competitive market? In this course, you’ll master the essential front-end development skills:
✅ HTML, CSS, and JavaScript – Build responsive and modern web pages
✅ React & Vue.js – Learn cutting-edge frameworks for dynamic UIs
✅ Real-World Projects – Work on hands-on projects to strengthen your skills
✅ Problem-Solving & Creativity – Develop intuitive, user-friendly interfaces
🔹 Who is this course for?
- Beginners who want to break into web development
- Developers struggling with front-end concepts
- Anyone looking to level up their skills and build real projects
🚀 Stuck on a project? Want to learn high-income tech skills?
This course will help you gain confidence, land opportunities, and grow in the tech industry.
📩 Contact me for more details and start your front-end journey today!
Alex
Mathematics for students of all grades, IB and IGCSEMathematics is the best way to enhance your intellect but also work on your intuition and your ability to see patterns.
Good day, my name is Alex, I have been teaching math for over 10 years to hundreds of students. I will teach all grades from elementary school all the way to high school and IB/GCSE etc.
My philosophy revolves around these three values:
-Encouragement
-Inspiration
-Discipline
I specialize into teaching mathematics and programming, but in some occasions I teach physics too.
Feel free to contact me.
Arianit
MATLAB Programming (Modelling, Simulation, Control Systems)Struggling with MATLAB? Whether you're a beginner or tackling advanced simulations, our one-on-one online tutoring is here to help you master MATLAB step-by-step. We offer personalized lessons tailored to your level, covering:
Basics of MATLAB programming
Data analysis & visualization
Numerical methods & simulations
Signal processing & control systems
MATLAB for engineering, math, and science courses
Help with assignments, projects, and exam prep
Youssef
Analog and digital electronics, VHDL, FPGA, programmingdoctoral student in engineering sciences provides support courses in analog and digital electronics at any DEUG level and engineering schools. having scientific and technical knowledge, three years of experience in the field of teaching, pedagogy and a sense of listening and analysis, I am able to help pupils and students and train them in the chapters of which they are having difficulty. for more info please contact me
Hayat
Introduction to Data Science with Python OnlineThis course is designed for anyone interested in learning data science using Python. It provides a hands-on introduction to fundamental data analysis tools such as NumPy, pandas, matplotlib, and seaborn. You'll learn how to manipulate datasets, create visualizations, and lay the foundations for statistical analysis and machine learning.
The course combines theory and practical exercises for effective, practical progress. No prior programming experience is necessary: we'll start with the basics to build solid, usable skills quickly.
Pr YSF
Analog and digital electronics, VHDL, FPGA, programmingEngineer and senior professor of engineering sciences provides support courses in analog and digital electronics at all levels, engineering schools. having a scientific and technical knowledge, five years of experience in the field of teaching, teaching and a sense of listening and analysis, I am able to help pupils and students and train them in the chapters of which they have difficulties. for more info please contact me
Zakaria
Learn to program and code with Scratch while having fun* This digital training aims to introduce you to the Scratch tool and through the game world, and gradually, to discover programming concepts such as loops, conditions or variables. It is aimed at anyone who is new to Scratch and who wants to create games and animations.
* Learning programming will allow students to develop their skills and will certainly allow them to meet the expectations of the future working world and emerging careers.
* In addition, learning programming allows the development of algebraic, algorithmic and computational thinking. Programming also helps to improve and develop students' sequencing ability, as well as their communication skills. Thus, there are several advantages to teaching programming, but the important thing is to remember that this learning teaches students that digital is not only for entertainment, but that it is possible to become creators. active and creative content.
Khadija
Full Stack Web Development with Laravel & React.jsThis course will allow you to master the basics of Full Stack web development by combining Laravel for the backend and React.js for the frontend.
You will learn how to create dynamic, secure and high-performance applications.
The program covers the fundamentals of Laravel (routes, controllers, Blade, REST API, databases) as well as React.js (components, state management, API calls).
At the end of the course, you will be able to build a complete management application (like a blog or a store)
Mathieu
Wordpress private lesson - From beginner to expertWith 7 years of experience as a developer in a Factory, I now develop Wordpress websites for large groups.
In the training program, you will learn to:
- Install, configure, and deploy WordPress sites
- Develop custom Wordpress themes and plugins
- Use powerful tools like ACF Pro, Gravity Forms, WPML, AIOS Security, WP rocket...
- Create custom post types and tailor-made taxonomies
- Develop pages using the right methods in HTML, CSS, Javascript & PHP
- Administer and manage a site database
- Contribute to the good natural referencing (SEO) of your site
- Use WP-Cli to speed up the maintenance of your sites
- Use Docker to containerize your local/prod projects and facilitate their management
- Administer your WP sites the right way
- And much more...
For any questions, you can contact me by PM.
See you soon,
Matthew
Amin
Programming with Python, with C and database management (Introduction to machine learning)Looking to master programming and become a skilled developer? In this course, you'll learn the basics of Python and other programming languages, as well as how to use them to build machine learning models. We also offer specialized assistance for students in programming and database management using SQL (CPGE students).
Python is a powerful general-purpose language used in web development, data science, software prototyping, and more. Its simple and easy-to-use syntax makes it an excellent choice for beginners learning to program.
Additionally, upon request, we offer courses in other programming languages such as C, R, and MATLAB.
Classes can be conducted remotely or in person, and we tailor our instruction to meet individual or group needs.
If you have any questions, feel free to contact us.
Matías
Private coding / programming lessons with pythonPython is one of the best, if not the best, language to start learning programming. It is also one of the most widely used languages today, especially in cutting-edge areas such as machine learning.
This popularity means that Python is constantly evolving. It offers a wide range of tools and libraries, which are free and very varied.
As an aeronautical engineer, I like to share my knowledge and derive satisfaction from it by teaching and motivating others.
I'm used to working with people of different ages. I believe in the importance of segmenting learning, visualizing progress, setting concrete goals and practicing regularly.
Beyond these general principles, there is no magic rule or method. Some approaches work with some students but not with others. Adaptation to individual needs is therefore the main objective of private lessons. So I will do my best to find what motivates and helps my student.
Adam
Introduction to Python: Programming Basics and Simple ApplicationsThis course is designed for beginners who want to get started with programming in Python, one of the most popular and accessible languages today. No previous experience is necessary. In one session, students will learn the basics of programming and will be able to create their first Python applications. With clear explanations, practical exercises, and real-world examples, this course is an ideal gateway to exploring computer science and coding.
Online Course: Introduction to Python - Programming Basics and Simple Applications
Duration :
- 60 minutes: intensive format to learn fundamental concepts.
- 90 minutes: In-depth format with more time for practical examples and interactive questions.
---
Educational objectives
At the end of the course, participants will be able to:
1. Understand the basics of programming, including the concepts of variables, data types, conditional structures, and loops.
2. Write and run simple Python scripts.
3. Manipulate inputs and outputs to interact with the user.
4. Solve practical problems with short, functional programs.
---
Course syllabus
1. Introduction (10-15 min)
- Presentation of Python: Why this language?
- Installation and configuration of a programming environment (IDLE, Visual Studio Code, or Jupyter Notebook).
- First program: *"Hello, World!"*.
2. Python Basics (20-30 min)
- Variables and data types (integers, strings, lists).
- Mathematical operations and data manipulation.
- Conditional structures (if/else) and loops (for/while).
3. Practical exercises (20-35 min)
- Write a program to calculate the sum of two numbers provided by the user.
- Create a simple application, like a currency converter or password generator.
- Bonus for 90 min format: Fixed a more complex issue involving lists or loops.
4. Q&A and conclusion (5-10 min)
- Summary of the concepts covered.
- Suggestions for resources to continue learning.
- Feedback on the course.
---
Teaching methodology
- Interactive and engaging: the course combines theoretical explanations with practical exercises.
- Personalized approach: Sessions are tailored to the needs of participants. Students are encouraged to ask questions at any time.
- Learning by doing: examples and exercises are designed to help you assimilate concepts quickly.
---
Target audience
This course is ideal for:
- Complete beginners in programming.
- Students or professionals wishing to acquire skills in Python for their personal or professional projects.
- Anyone curious to discover a powerful and versatile tool for solving problems.
---
Benefits of this online course
- Teaching by an experienced and passionate trainer.
- Interactive sessions adapted to your learning pace.
- Access to educational materials and exercises to continue practicing after the course.
Join us now to discover programming and its applications using Python!
---