from26.03CAD/ 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 ⊞+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 -05:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from C$26.03Online via webcam
from C$30.63At 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 -05:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from C$26.03Online via webcam
from C$30.63At 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.
Amin
Statistical Analysis with Python and R (Rstudio) - Intro to Data ScienceBy delving deep into the practical applications of statistics and data science, this course is designed to set you up for success.
Learn from real-world examples: Instead of spending hours on theoretical material and trying to relate it to practical issues, we will focus solely on applied statistics. Programming will allow you to apply theory to real-world problems, equipping you with the knowledge and skills you need to succeed.
We won’t be spending hours solving math problems by hand for reinforcement, as this isn’t school. Instead, we’ll use cutting-edge methods and code libraries that leverage the latest software releases to maximize productivity and efficiency.
If you have any further questions, please do not hesitate to contact us.
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.
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
Brahim
Introduction to NoSQL DataBase MongoDB by PratiqueDo 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 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!
Mohamed
Artificial Intelligent _ Machine Learning _ Neural Networks using MatlabNeural Network is a powerful machine learning tool used for classification & prediction. It works as function approximation from experienced data of inputs and outputs entered to the training process to create the model. The concept of neural network can be thought theoretically by mathematics, but the course will include also a practical coding using Matlab Software.
Pr YSF
Electronics, Control of industrial systems, C/C++ VHDL programming, digital and analog electronics, MATLAB simulationHello, I am a doctoral student in electrical engineering and associate professor in engineering sciences, experienced in the field of electrical engineering, I offer support courses in the subjects of engineering sciences (Electronics, automatics, electrical engineering, automation, programming).
Digital electronics
Analog electronic
electromagnetism (propagation of high frequency waves)
Automatic (continuous, sampled)
electrical engineering (transformers, electrical machines, switching power supply)
C / c ++ programming, Assembler, ARM, STM32
renewable energy (wind, PV)
engineering Sciences
RDM
Python,VHDL
PIC Microprocessor and Microcontroller
Signal processing and data acquisition
Engineering Sciences
These courses allow the student to get up to speed and regain confidence in all scientific subjects, just as they prepare him effectively for the Baccalaureate, the Preparatory Classes or various examinations of the engineering classes.
COURSE OBJECTIVES AND PEDAGOGICAL APPROACH
Resumption and deepening of fundamental concepts through exercises with course reminders.
Put the student in a situation of questioning and research.
Respond to individual issues and questions
Exercise training in order to achieve real mastery of the content.
Learn to build theoretical reasoning from observable facts or hypotheses.
Specific preparation for higher education requirements (in-depth content, increase in work capacity, enrichment of scientific background)
This educational approach is effective since it has often led me to interesting results with my students.
Associate professor provides support courses in electrical engineering
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.
Driss
Private Tutoring in Computer Science and Web Development 💻(🔴 ENGLISH TEXT)
Areas taught :
- Programming languages: C, C# 💻
- Web development: HTML, CSS, Sass, Bootstrap 🌐, JavaScript 🧀, Typescript, jQuery, PHP 🐘
- Frameworks: Laravel, Angular 🔴
- Databases: SQL 🛖
Experience: Teaching and professional practice since 2016
============================================================
(🔵 TEXTE EN FRANÇAIS)
Domaines enseignés :
- Langages de programmation : C, C# 💻
- Développement web : HTML, CSS, Sass, Bootstrap 🌐, JavaScript 🧀, Typescript, jQuery, PHP 🐘
- Frameworks : Laravel, Angular 🔴
- Bases de données : SQL 🛖
Expérience : Enseignement et pratique professionnelle depuis 2016
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
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.
Join
Academic support: Mathematics from secondary to Bachelor and Fundamentals of programming in C and C++ for beginners and intermediates.Discover our comprehensive academic support program, offering in-depth expertise in crucial areas of mathematics, from secondary to Bachelor, as well as the fundamentals of programming in C and C++, suitable for both beginners and intermediate levels.
Mathematics from Secondary to Bachelor:
This part of the course offers a comprehensive path to consolidate and broaden your understanding of mathematics, from high school concepts to the more advanced requirements of the Bachelor level. Dive into algebra, geometry, differential and integral calculus, statistics, and much more. Our experienced instructors will guide learners through clear explanations, detailed demonstrations and practical exercises to reinforce understanding and problem solving.
Fundamentals of Programming in C and C++ for Beginners and Intermediates:
Explore the exciting world of programming with our section dedicated to C and C++ languages. Designed for beginners, this course begins with an in-depth introduction to basic programming concepts, ranging from syntax to control structures. Learners will gain a solid understanding of fundamentals before moving on to more advanced topics.
For intermediate levels, the course expands programming skills by focusing on real-world projects, code optimization, and advanced use of C and C++ features. Participants will have the opportunity to develop practical applications, strengthening their expertise while honing their problem-solving skills.
Pedagogical Approach:
Our educational approach is based on the interactive engagement of learners. Classroom sessions, practical work and real-world projects ensure a thorough understanding of the concepts taught. Instructors are dedicated to creating a stimulating learning environment, encouraging questions and active participation.
Whether you are looking to strengthen your high school math skills or master C and C++ programming, our academic support program provides a comprehensive platform to stimulate your intellectual and professional growth. Join us on an enriching educational journey, where skill acquisition becomes an exciting and educational adventure.
Abdallah
Programming and Coding Lessons, Adults, Kids( Python, HTML, CSS, Java Script, MySQL, Dart and Flutter, C++, C#, ) Offline Egypt and OnlineAfter Completing Our Course:
- High Earning Potential: Skilled programmers are in high demand, commanding competitive salaries across various industries.
- Versatile Career Opportunities: Open doors to careers in software development, data science, web development, game design, and more.
- Cutting-Edge Skills: Stay ahead in the fast-evolving tech landscape by mastering the most popular and widely used programming languages and frameworks.
- Innovation and Creativity: Enhance your ability to create innovative solutions, develop new technologies, and contribute to exciting projects.
- Problem-Solving Abilities: Strengthen your logical thinking and problem-solving skills, essential for tackling complex technical challenges.
- Career Advancement: Stand out in the job market with a robust programming skill set, increasing your chances of career advancement and promotions.
- Lifelong Learning: Cultivate a mindset of continuous improvement and lifelong learning, staying relevant and adaptable in your career.
**Programming and Coding Lessons for All Ages**
Unlock the world of coding with our comprehensive programming and coding lessons designed for both adults and kids. Whether you're a beginner or looking to enhance your skills, our courses cover a wide range of programming languages and technologies to suit your needs.
**Course Offerings:**
- **Python**: Learn the fundamentals of programming with one of the most versatile and popular languages.
- **HTML & CSS**: Build and style your own websites from scratch.
- **JavaScript**: Add interactivity to your web projects and enhance user experience.
- **MySQL**: Master database management and SQL queries.
- **Dart & Flutter**: Create beautiful, natively compiled applications for mobile, web, and desktop from a single codebase.
- **C++**: Dive into the world of object-oriented programming and system-level coding.
- **C#**: Develop robust applications with this powerful language used in a variety of industries.
**Class Formats:**
- **Offline Classes in Egypt**: Join us in person for hands-on learning and direct interaction with our experienced instructors.
- **Online Classes**: Participate from anywhere in the world with our flexible online courses, designed to fit your schedule.
**Who Can Join?**
- **Adults**: Whether you're looking to start a new career, enhance your current skills, or simply explore a new hobby, our classes are perfect for you.
- **Kids**: Our engaging and interactive lessons make learning to code fun and accessible for younger students.
**Why Choose Us?**
- **Experienced Instructors**: Learn from industry professionals with years of teaching and real-world experience.
- **Comprehensive Curriculum**: Our courses are designed to provide a solid foundation and advanced knowledge in various programming languages.
- **Flexible Learning Options**: Choose between offline and online classes to suit your lifestyle and learning preferences.
Join us today and start your journey into the exciting world of programming and coding with the expert instructor Abdallah!
========================================
Comment:
Looking to master programming and become a skilled developer?
In this course, you will learn the basics and tools to manipulate coding and programming languages as well as using them to build machine learning models. We also provide assistance to students specializing in programming and database management using SQL
Under special request, we provide courses on other programming languages.
If you have any further questions, feel free to contact us.
Coding is a powerful general-purpose programming methods. It is used in web development, data science, software prototyping, etc. Fortunately for beginners, Coding has a simple and easy to use syntax. This makes Python a great language for learning programming for beginners.
In this course, you will learn the basics and tools for manipulating python as well as its use to build machine learning models. We also provide assistance to students specializing in python programming and database management using SQL
If you have any further questions, please do not hesitate to contact us.