from72.55SAR/ 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 72.55 SAROnline via webcam
from 85.36 SARAt 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
- 1 repeat student
- 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 72.55 SAROnline via webcam
from 85.36 SARAt 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.
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
Abdelrhman
Computer programming in Python, artificial intelligence, and machine learningBy the end of this lesson, the learner will be able to:
Getting to know the Python language
Understand what Python is and its most important uses.
Distinguishing Python from other programming languages.
Preparing the work environment
Install and run a Python development environment (such as Python IDLE or VS Code).
Running your first Python program.
Dealing with variables and data types
Defining and dealing with variables.
Understanding different types of data
Use input and output operations (input() and print()).
Perform arithmetic and logical operations.
Understanding the basic structures of programming
Using if-else statements.
Applying loops (for, while).
Working with functions in Python
Following naming and commenting conventions in Python.
Huzaifa Muhammad
LATEST Next-Gen Python-3 Programming: From Fundamentals to MasteryABOUT THE LESSONS
- Tailored according to your skill level
- Latest version of python
- Extremely interactive
TAKEAWAYS
- Well-structured Notes
- Programming Problems of all levels with Solutions
- Lecture Recording
- Complete Roadmap
ABOUT ME
- Five years of experience in Python Programming
- Worked on several real-world Python projects
- Have the ability to break down complex Python concepts in simple words
- Have the ability to explain Python on any level
PYTHON
I can teach you:
- concepts at a deep level of understanding
- how to use python for practical applications
- how to solve programming problems using python
- data structures and algorithms in python
Albert
Mathematics, Physics & Programming Tutorials, High School + UndergraduatesAre you a high school or high school student and have difficulty understanding and solving math or physics problems? Then I am someone who would like to help you with that. I often see that in standard classroom teaching is succinctly taught. As a result, the student misses out on the whole picture, making the teaching material and the problems vague and unclear. My goal is to take the time for each student to complete the whole picture and guide them through complex problems, so that the student can not only take tests and exams with ease, but also enjoy learning the material.
Oussama
Python Programming for All Levels: From Fundamentals to Advanced Libraries and FrameworksWhat You Will Learn:
Core Principles: Introduction to programming, algorithms, and data structures to build a strong foundation.
Advanced Libraries and Frameworks: NumPy, Pandas, and Django to create web applications and perform efficient data analysis.
Practical Projects: Real-world applications to strengthen your skills and build an impressive portfolio.
How You Will Benefit:
Students: Gain the necessary skills to excel in academic projects and lay the groundwork for your career.
Self-Taught Learners: Avoid common mistakes and fast-track your progress with clear, hands-on guidance.
Professionals: Enhance your skill set to meet industry demands and open up new career opportunities.
Why Choose My Courses?:
Personalized Approach: Each course is customized to your level and learning pace, ensuring tailored guidance and support.
Theory and Practice: You’ll combine theoretical concepts with hands-on exercises for a comprehensive and lasting understanding.
Solving Real-World Problems: Learn how to tackle the common challenges faced in programming, from debugging to performance optimization.
Baia
Python & Django Development – From Beginner to Web App Developer🚀 Learn Python and Django to Build Powerful Applications 🚀
Want to master Python and develop real-world web applications with Django? Whether you're a beginner or looking to enhance your coding skills, this course will guide you step by step!
What You’ll Learn:
✅ Python Basics & Advanced Concepts – Learn syntax, data structures, OOP, and algorithms
✅ Django Framework – Build dynamic and scalable web applications
✅ Databases & APIs – Work with PostgreSQL, SQLite, and REST APIs
✅ Project-Based Learning – Apply concepts through hands-on coding and real projects
✅ Debugging & Best Practices – Learn clean coding principles and error handling
🔹 Who is this course for?
Complete beginners who want to start coding with Python
Developers looking to transition into backend or full-stack development
Students and professionals who want to build their own web applications
💻 Class Format:
- Live online sessions via Google Meet
- Interactive coding exercises & projects
- Personalized guidance based on your level
📩 Contact me to start your Python & Django journey today!
Mohamed
Database (SQL Server, PostgreSQL, MySQL): From Fundamentals to Distributed SystemsDive into the world of SQL databases with this comprehensive course designed for learners of all levels. Whether you are new to databases or seeking to expand your expertise to advanced concepts like distributed systems, this course has you covered.
What You can Learn:
- Fundamentals of relational databases and SQL syntax.
- Designing robust databases using normalization and entity relationships.
- Writing complex queries, joins, and subqueries.
- Database optimization techniques for performance tuning.
- Implementing stored procedures, triggers, and views.
- Managing transactions and ensuring data integrity.
- Understanding and working with distributed database systems like Distributed PostgreSQL
Rony
Learn App Development for Teens! Features three fun beginner, intermediate and advanced levels!Empower young minds to create their own mobile apps with this fun and interactive course! Designed for children aged 9 to 13, this course introduces app development using MIT App Inventor, a beginner-friendly platform that makes coding easy and exciting. Students will learn the basics of programming, user interface design, and problem-solving as they build their own functional Android apps. Through hands-on projects and creative challenges, they will develop logical thinking and digital skills while bringing their ideas to life. No prior experience is needed—just curiosity and a passion for technology!
Gaëlle
Code Your Way to Success: A Fun and Interactive Introduction to Programming for KidsIn 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
Master Python at All Levels with Personalized Lessons - SUP SPE Program includedStart with the fundamentals like variables, loops, and conditionals, and progress to more advanced concepts including manipulating files, images, and using Python libraries like Numpy, Scipy, Pandas, and Matplotlib. Also explore the fundamentals of object-oriented programming.
Why choose this Course?
By opting for these courses, you will have the opportunity to consolidate your knowledge through practical exercises and concrete mini-projects which will strengthen your Python skills. Each session will be interactive, allowing you to ask questions and receive constructive feedback on your code.
You will be able to benefit from personalized support. Lessons are tailored to your level, whether you're looking to pursue a career in programming or just want to learn for fun. Sessions are tailored to your goals, and ongoing support is provided to overcome any challenges you may encounter.
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! 😉
Mahmoud
Explaining the basics of programming and artificial intelligence for children using Scratch and PythonExplaining the basics of programming and artificial intelligence for children using Scratch and Python
To teach kids the basics of programming and artificial intelligence using Scratch and Python, start with simple concepts with fun applications:
Scratch:
Introduce kids to visual programming using colorful blocks.
Start with projects like creating an interactive story or a simple game.
Teach them concepts like loops, variables, and conditions using animations.
Python:
Python is introduced as an introduction to scripting.
Use easy libraries like turtle to draw or random to create random games.
Introduce them to AI with a library like Teachable Machine to easily classify images or sounds.
Practical example:
Create a simple game in Scratch, then use Python to develop a similar game to illustrate the difference between visual and textual programming.