facebook
    Szymon
    Trusted teacher
    FavouritesAdd to Wish List
    FavouritesAdd to Wish List
    Trusted teacher
    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.

    Extra information

    Bring your own laptop with PostgreSQL installed!

    Location

    At student's location: Around Antwerp, Belgium
    Online via webcam

    |
    Use ⊞+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.js

    About 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?"

    Availability of a typical week

    (GMT -05:00) New York
    MonTueWedThuFriSatSun
    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.

    Online reputation

    • Instructor since October 2024
    • 1 repeat student
    • Phone number verified
    • Google connected
    • Linkedin connected

    Availability of a typical week

    (GMT -05:00) New York
    MonTueWedThuFriSatSun
    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


    Han
    Programming, data analysis, and statistics courses by a French master's graduate
    Graduated 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 Welcome
    Master 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.

    Mohammed Shan
    Computer Science Fundamentals and Exam Preparation
    📌 What You’ll Learn: ✅ Core Computer Science concepts (Operating Systems, Databases, Networks) ✅ Data Structures & Algorithms (Sorting, Searching, Graphs, Trees, etc.) ✅ Exam preparation (GCSE, A-Level, University courses) ✅ Hands-on problem-solving 🖥️ Teaching Style: I provide interactive lessons with clear explanations, real-world examples, and coding exercises to ensure conceptual clarity. Sessions are structured based on individual learning needs, whether for academic success or competitive exam prep. 📅 Class Format: Mode: Online (Zoom/Google Meet) Duration: Flexible scheduling Group & 1-on-1 sessions available Materials provided: Notes, problem sets, practice questions

    Hamza
    Maîtrisez Python avec un Expert en Programmation et Data Science
    Découvrez la puissance de Python avec un formateur expérimenté en informatique ! Je suis Hamza, un développeur passionné et mentor chevronné avec une vaste expérience dans l'enseignement de la programmation. Mon approche pédagogique unique vous permettra d'acquérir rapidement des compétences solides en Python, tout en découvrant ses applications concrètes dans le monde professionnel. Ce que vous apprendrez : Fondamentaux de Python (variables, structures de contrôle, fonctions) Programmation orientée objet avancée Analyse et visualisation de données avec pandas et matplotlib Développement d'interfaces graphiques avec PyQt Projets pratiques inspirés de cas réels en entreprise Pourquoi me choisir ? Plus de 5 ans d'expérience en formation et mentorat Méthode pédagogique adaptée à tous les niveaux Approche hands-on basée sur des projets concrets Passion contagieuse pour le code et l'innovation technologique Que vous soyez débutant cherchant à vous lancer dans la programmation ou professionnel souhaitant monter en compétences, ce cours vous ouvrira de nouvelles perspectives passionnantes dans le monde du développement logiciel et de la data science. Rejoignez-moi pour un voyage captivant au cœur du langage de programmation le plus polyvalent et demandé du marché ! Réservez maintenant et faites le premier pas vers la maîtrise de Python. Votre carrière en tant que développeur Python commence ici !

    Hasmik
    Class of statistics, computer programming, R programming
    I am a graduate in data science with R programming skills. I am able to help the students with assignments, and analysis with their master thesis. My approach is very student-oriented and I explain the subjects in a detailed way so that the students understand the main idea.

    Brahim
    Introduction to NoSQL DataBase MongoDB by Pratique
    Do not deal with the manual with terms of reference statements and basic documents that cannot be obtained in order to avoid the MongoDB problem. Please include the connection to one of the MongoDB données base, comment on simple CRUD operations and sujets clés que l'agrégation, l'indexation, la mode des données et les Transaction. 1- Install MongoDB 2- Implement MongoDB 3- Use of documents and collectibles 4 - Leadership Committee 5- Execute CRUD commands (create, read, update, delete) avec mongo shell 6- Type the register in a MongoDB database 7- Reset the base to remonter specific documents depuis mongo shell. 8- Lagrégation 9- Indexing 10- Amending institutions and transactions

    Gaëlle
    Code Your Way to Success: A Fun and Interactive Introduction to Programming for Kids
    In this class, kids will learn the fundamentals of programming and computer science in a fun and engaging way, and discover how these hard and soft skills can be used in their personal and future professional lives. Through interactive lessons and hands-on projects, kids will explore the world of code and create their own digital creations. Throughout the course, they will: Learn the basic concepts and terminology of programming Experiment with different programming languages and platforms Create simple programs and apps using code Collaborate with peers and share their creations Develop problem-solving skills, logical thinking, and other valuable skills that will be useful in any field By the end of the class, your children will have the knowledge and confidence to continue exploring the exciting world of programming and computer science and will understand how code can be a powerful tool for achieving success in any field. They'll be able to choose the job they want in the future or even build their own company. So, join us and code your way to success!

    Younes
    Scratch, Roblox: Code for Fun - A Fun Adventure for Kids and Beginners!
    With Scratch and Roblox, programming becomes child's play! Learn how to create animations, games, and interactive stories using colorful, easy-to-manipulate blocks of code. No complex language here, just a visual and intuitive approach to make learning as fun as possible. Whether you are a parent wanting to introduce your children to the language of programming or a beginner curious to discover the world of coding, this training is suitable for all ages. No prerequisites necessary, just a dose of curiosity and a desire to have fun while learning. As a trainer, I am committed to creating a caring and creative learning environment. I will use teaching methods adapted to each child, promoting positive interaction and encouraging the free expression of creativity. The goal is to make each lesson an engaging and enriching experience.

    Antonio
    Marketing, Promotion, Digital Optimization, and SEO
    The course module is adapted to the student. You will earn: ▪️ An integrated digital marketing strategy based on your own organizational context. ▪️ Skills to effectively analyze and leverage data to make breakthrough data-driven decisions. ▪️ A future perspective on marketing and an overview of how to use emerging digital channels and technologies, such as artificial intelligence (AI) and chatbots, within your organization. ▪️ Accept the challenges and opportunities of disruptive technology in your digital marketing strategy.

    Alper
    Automating the Internet: Python, Selenium, Intro to Web-Scraping
    Are you interested in automating the boring stuff on the internet? Would you like to have your computer handle the boring tasks you spend your time on? Would you like to save websites to your PC for later viewing? You can learn to access, manipulate and save data from the internet to your PC by taking this class! It will teach you how to use Selenium with Python to automate basic tasks in your web browser. You can simply sit back and allow your computer handle the tedium. You can save your favourite recipes, pictures and stories from the web to your PC for later viewing. Anything you can do with your own time, the scripts we will write together can do on their own!

    Benito
    Python and/or Machine/Deep Learning Classes at your place or Online!
    I am currently working as an independent consultant, technical writer, online teacher 🧑‍🏫 and course content developer in Python, and a wide range of Machine/Deep Learning topics 🧑‍💻. My experience enables me to offer lessons ranging from beginner to advanced levels. I can tailor the classes to your specific needs and schedule, providing a well-structured learning path 🚀. What do you get from me? 👉 Learn at your own pace without any pressure 👉 Well-documented tutorials What topics do I usually cover at the beginning for people without Python experience? ✔️ Understanding the basic concepts (variables & types) ✔️ Math & Statistics (explained easily) ✔️ Data Manipulation (data cleaning, preprocessing...) What topics do I cover for people with Python experience? ✅ Classic libraries: Pandas, NumPy, Scikit-learn, TensorFlow ✅ Data Analytics/Visualization: Plotly, Seaborn, Matplotlib ✅ Domains: Regression, Classification, NLP, LLM, RAG, Computer Vision, Neural Networks, Ensemble Methods, Clustering, Dimensionality Reduction ✅ MLOps: MLflow, Prefect, GCP, AWS Whether you are new to the field, seeking to enhance your skills, or require assistance with a work/school project, feel free to reach out to me! 😉

    Volodymyr
    Statistics and R – from (Uni) classes to a Dissertation, by a Cambridge Grad
    Statistics provides a valuable framework for analysing data and formalising how to derive conclusions from it. It is based on a very mathematical fundament, but stretches out to out-of-the box methods available in every computer. For whom: - You have a School class in Statistics or R - You are writing a BSc/MSc Dissertation and you are lost: for example, you have a questionnaire and you need to analyse the data in there to write your thesis. - You have practicals or need Stats for work. You can learn: - If required, mathematical foundations, formulas and logic underlaying statistics - What is a p-value, what do all these words like factor analysis, normal distribution and test ACTUALLY MEAN and WHY do we need those? - How to import your dataset and analyse it with R.

    Mouad
    Support course in Python (For all levels, CPGE)
    Passionate about programming, we offer Python support courses adapted to all levels, from beginner to advanced. These courses are aimed at students in preparatory classes for grandes écoles (CPGE) as well as anyone wishing to acquire solid programming skills. The lessons cover the essential foundations of Python with a clear and accessible teaching approach. Whether you are new to programming or want to deepen your knowledge, you will benefit from structured and progressive teaching. With a focus on concrete concepts and practical examples, these courses aim to strengthen your skills in a tangible way. You will be guided through the nuances of Python, gaining a deep understanding that will benefit you both in your studies and in your future career. Join us to explore the fundamentals of Python programming and progress to more advanced levels. Together, we will build a solid foundation and develop the skills needed to succeed in the dynamic world of computer programming.

    Mathieu
    Wordpress private lesson - From beginner to expert
    With 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